nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to pull existing report definitions

Julie Fortney

I was excited to learn yesterday that we can update report definitions (filter, group, summarize, and sort) via the API. The Smartsheet API documentation details how to update report definitions, but I understand the caveat is that when you do so, you overwrite the existing. You have to first get the existing report definitions, add/change what you want, then include all of those in the update.

I'm using Bridge. The Get Report module does not include definitions. According to some AI chats I should be able to use this endpoint, but it doesn't work in Bridge or in Postman:

/reports/{report ID}/reportdefinition

Has anyone had any success with pulling existing report definitions?

Find more posts tagged with

API and Developers

Bridge

Accepted answers

Paul Newcome

I have tried a ton of different ways to get it through the API and have yet to figure it out. The few AI prompts I have tried all confirmed that it just isn't possible as well.

Here's a Product Idea:

https://community.smartsheet.com/discussion/147168/get-existing-report-definition-via-api

All comments

Adrien Leduc

Hello Julie,

I'm not very proficient with the API, but I've used bridge a lot. Sometimes you can get more info by using the advanced options of a module, have you tried all the options to see if you can get the definitions?

https://help.smartsheet.com/articles/2482022-smartsheet-reference-guide-bridge#toc-get-report

Otherwise instead of using bridge's module couldn't you use the API to get the definition?

Paul Newcome

I have tried a ton of different ways to get it through the API and have yet to figure it out. The few AI prompts I have tried all confirmed that it just isn't possible as well.

Here's a Product Idea:

https://community.smartsheet.com/discussion/147168/get-existing-report-definition-via-api

Julie Fortney

Thanks Paul - not what I wanted to hear, but at least I have confirmation that it just isn't possible at this time. I added my upvote.

Paul Newcome

@Julie Fortney Check my comment on the product idea. You mentioned using Control Center. That actually makes it easier because Control Center uses a template. This means you already know the report definition.

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.