Sheet Summary Report From Smartsheet Into Appsheet
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.
Best Answer
-
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.
Answers
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives