How do I get all the rows in a Smartsheet by sending an API call using the requests package in pytho
I am trying to get just the rows (list of rows) in a smartsheet in a single API call by using the Python requests package instead of the smartsheet SDK.
I tried to use /rows in my request like so:
r = requests.get("https://api.smartsheet.com/2.0/sheets/{sheetID}/rows", headers=smartHeaders, params=payload)
but unfortunately it does not work and I get a 400 level error code 405. I have created a post on this question in this link for more information
Any help is greatly appreciated.
Answers
-
Hi @Moaz , you'll want to use Get Sheet: https://api.smartsheet.com/2.0/sheets/{sheetId}
https://smartsheet.redoc.ly/tag/sheets#operation/getSheet
The row level data from the entire sheet is returned
-
Hello @Ryan Sides, This call will get the entire data for the smart sheet. I only want just the list of rows. is it possible to only get just the row level data with a single api call?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives