Sheet Summary Report From Smartsheet Into Appsheet

PB_PerfectPatterns

Greetings, I'm attempting to retrieve a Sheet Summary Report as a 'read-only' table in Appsheet.

The error I'm receiving...

The report you are attempting to open is a sheet summary report, which requires a query parameter of 'level=2' (or higher if available) to be specified in the API request. → Error 5623 in SmartsheetProvider

Hoping someone could give me their two cents on why this could be happening?

Obviously this question could also be asked to Appsheet support and I may do that as well. However I figured I'd start here as retrieving all other SmartSheet content has worked flawlessly so far in Appsheet.

Chris Mondeau

Hi @PB_PerfectPatterns ,

I was informed by Smartsheet that sheet summary reports had no API endpoint, so there wouldn't be anything to connect to (in my application I was trying to use one in PowerBI). Not sure if they've updated this or if it's a work in progress.

Chris Mondeau

Hi @PB_PerfectPatterns ,

I was informed by Smartsheet that sheet summary reports had no API endpoint, so there wouldn't be anything to connect to (in my application I was trying to use one in PowerBI). Not sure if they've updated this or if it's a work in progress.