Smartsheet API Assistance Required
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!
Answers
-
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
-
Thank you Genevieve - can I hire you to create this for me?
-
Hi Genevieve,
Are you available to consult on this project? If so please message me or email me nate.junger@internationalrenewals.com.
Best,
Nate
-
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
-
Okay, thank you!
Categories
- All Categories
- 14 Welcome to the Community
- 10.8K Get Help
- 65 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.6K Ideas & Feature Requests
- 56 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives