Report fetched through API is restricted to 450 rows only

Ashish2024 · 03/11/24

Hello,

Please note that I am using Smartsheet api to fetch a report that has around 500+ rows.

Syntax - https://api.smartsheet.com/2.0/reports/<report id>

This is only fetching 450 rows and I have no idea where the remaining rows went. Based on few posts through Google search, I tried pagination ways like -

#1 https://api.smartsheet.com/2.0/reports/<report id>?pageSize=500&page=1

#2 https://api.smartsheet.com/2.0/reports/<report id>?pageSize=500&page=2

#1 - this still only brings 450 records again

#2 - exact replica of #1

Also tried doing includeAll=true but that also returns 450 records.

Has anyone faced this issue ? Appreciate any guidance.

Thanks.

Lee Joramo · 03/12/24

Really hard to diagnose based on this info. It seems like you have done what I would with the API.

What happens if you get the sheet as a CSV?

// Sample 4: Get sheet as CSV
curl https://api.smartsheet.com/2.0/sheets/{sheetId} \
-H "Authorization: Bearer {SMARTSHEET_TOKEN}" \
-H "Accept: text/csv" \
-o output.csv

Ashish2024 · 03/12/24

https://community.smartsheet.com/discussion/comment/424803#Comment_424803

Thanks for your reply. Wondering though if I can get the report as a sheet ? Are you suggesting that I should save the report as a sheet and try it ?

Lee Joramo · 03/12/24

Oh sorry, I missed "report" and was thinking about "sheets"

Report fetched through API is restricted to 450 rows only

Answers

Categories