How do I get all the rows in a Smartsheet by sending an API call using the requests package in pytho

Moaz

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

https://stackoverflow.com/questions/75150962/how-do-i-get-all-the-rows-in-a-smartsheet-by-sending-an-api-call-using-the-reque

Any help is greatly appreciated.

Ryan Sides

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

Moaz

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?

Ryan Sides

@Moaz there are only these two ways: Get Sheet (for all rows) or Get Row (for individual row at a time).