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.

Find more posts tagged with

Reports

Sheet Summary

Accepted answers

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.

All comments

Chris Mondeau

Hi @PB_PerfectPatterns ,

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.