Smartsheet API Assistance Required

International Renewals

I am looking for assistance to provide a url to find the correct row of a given sheet per the provided identifier (country code; e.g. US, GB, AL, etc) and return all the values of the row. I'll need the correct smartsheet api url of our smartsheet account (please don’t refer me to the smartsheet api docs), no application or development needed.

Thank you!

Genevieve P.

Hi @International Renewals

You can use Get Sheet to get all the row data from your specific sheet:

https://api.smartsheet.com/2.0/sheets/{sheetId}

Then once you have all the sheet data, you can query what you received in the API response to identify the row(s) that match your criteria. The response will show you the row number, row ID, and other values in the row. This post in the Stack Overflow Community has a similar question and answer.

You could also create filters in the Smartsheet App UI on the sheet, and then use the API to gather the data that matches that filter. Here's another post from the Stack Overflow Community that goes into more detail on the filter solution.

If neither of the posts above help with your API question, you may want to talk to your Smartsheet representative about potentially partnering with our Consulting team for a custom API solution.

Cheers,

Genevieve

International Renewals

Thank you Genevieve - can I hire you to create this for me?

Nate Junger

Hi Genevieve,

Are you available to consult on this project? If so please message me or email me nate.junger@internationalrenewals.com.

Best,

Nate

Genevieve P.

Hi @International Renewals and @Nate Junger

No, I am not a consultant in this area and will be unable to work with you directly in custom building API solutions. You can contact our Consulting team with your request through this form, here!

Or you can learn more here: https://www.smartsheet.com/services/consulting

Cheers,

Genevieve

Nate Junger

Okay, thank you!