Report fetched through API is restricted to 450 rows only

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.

Answers