Smartsheet API Assistance Required

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