API Report restricted to first page

Gary Maddren

We wish to download through url access a report that is 850 rows so expands over 2 pages.  When we access it we only get the first page.  Is there a way to get all pages?

 

Below is our curl code (the XXXXX.... is our authorization which we have masked):

 

curl https://api.smartsheet.com/2.0/reports/1321831786407812?includeAll=true -H "Authorization: Bearer XXXXXXXXXXXXXXXXXXXXXXXX" -H "Accept: application/vnd.ms-excel" -o P:\Documentation\Engineering\EngineeringPlanningExtract.xlsx

 

We researched and found the IncludeAll function but could not get it to work.  Do we have it in the wrong place?

 

Jenny Lam

Hi Gary,

 

GET report supports paging:

• pageSize: Number of rows per page. Default is 100, it can be at most 500 (i.e. 500 rows per page)
• page: Which page number (starting from 1) to return.

 

In your situation, please get the report in 2 pages:

https://api.smartsheet.com/2.0/reports/1321831786407812?pageSize=500&page=1

https://api.smartsheet.com/2.0/reports/1321831786407812?pageSize=500&page=2

 

Gary Maddren

Thanks Jenny.  We tried this syntax as you wrote it and got a "page' is not recognized as an internal or external command" error.  Any ideas?

 

Full error:

"errorCode" : 1004,

  "message" : "You are not authorized to perform this action.",

  "refId" : "o5pnv2zuv3zb"

}'page' is not recognized as an internal or external command, operable program or batch file.

Jenny Lam

Hi Gary,

 

Looks like the curl command exports the report as a spreadsheet. So the paging option is not applicable.

 

The pageSize and page parameters are applicable to retrieving a report as a Report object only (not export).

 

I will look a bit more into this ...

Gary Maddren

Thanks Jenny, 

Actually we don't have to have export as xlmx - is it possible to do csv or html?

 

Jenny Lam

Hi Gary,

 

I have tried the curl command. I also receive the first page (500 rows) when getting the report as xlsx or csv.

 

I am going to speak with my team and will post here when I know more.

Jenny Lam

Hi Gary,

 

I have spoken with my team and we are working on this. At the mean time, please get the report as xlsx / csv via the website (https://app.smartsheet.com/b/home) to retrieve a report with more than 500 rows.

 

Thanks a lot!

 

Jenny Lam

Hi Gary,

 

You should be able to get the report as xlsx/csv with more than the first page using GET reports/{id} now. Please give it a try.

 

Thanks,

 

Jenny

Gary Maddren

Thanks Jenny it works now. 

Gary