-
Will and API token for a report give access to the Sheet the Report generated from?
Hi, I have a large Smartsheet, I want to generate a row report that reduces information displayed down to a specific group. For that Row Report, if I were to generate an API token and share it to a third party, will that third part have access to the information on the original 'Grid' sheet, or will it be reduced to what…
-
Power Automate - Post Attachments to Row/Sheet
Hello everyone! I spent WAY to long looking for this answer so I thought I would share it with the Community in hopes of helping someone else. Problem: Adding attachments to rows/sheet is not possible through the standard SmartSheet Connector Solution: This can only be done by creating a Custom Connector. It CANNOT be done…
-
If deprecating GET /templates, provide another mechanism to get the same data
Last week, Smartsheet announced the deprecation of the API call "GET /templates" with no plan for any replacement mechanism. We have a long-standing integration from our software platform that serves mutual customers of Smartsheet and our product that fundamentally depends on the response to the "GET /templates" API call.…
-
Allow System Admins to View and Manage All Active API Tokens Across the Enterprise
Description: As a Smartsheet System Admin for our enterprise account, we need the ability to view, audit, and manage all active API tokens created by users in our organization. Currently, admins have no visibility into which users have created tokens, when they were created, what they’re used for, or whether they’ve…
-
Ability to use public facing ID in the permalink to access objects through the API
Smartsheet Objects (Sheet, Report, etc) consist of two identifiers, the object's ID and the public facing string found in the permalink (PUBLIC_ID). Example of a Permalink: https://app.smartsheet.com/sheets/{PUBLIC_ID}?view=grid Navigating to File, Properties a user can find the ID and the share url which contains a…
-
Enable activity log download via API
We would like to automatically obtain & process access data for dashboards and/or sheets, to determine usage. Ideally, we'd like an API endpoint which allows to perform these pulls with the same parameters as currently provided by the manual download.
-
Smartsheet SSO SAML to EntraID
Hello everyone, We are facing an issue with our EntraID tenant, which currently has 10 domains associated with it. After migrating from Okta SSO to EntraID SSO, we encountered a problem where users who sign in with an email alias (different from the primary tenant domain) are unable to authenticate via Microsoft 365…
-
How can I pull reports data from Resource Management connect to Power BI?
I'm not a developer and my knowledge of APIs are limited. I'm working on getting data from the resource management tool to power bi. I was able to pull all data, except for reports. I know I have to do a POST request, which I'm trying for the first time. I did run this query and I'm still getting errors. I'm getting this…
-
Hyperlinks
Hello all, I need help i have a sheet that every week i add about 300-700 lines and each one of them have a Different link, is there a faster or easy way to add them all together? and not each line at a time ? I don't mind adding them all as "LINK" but for now as i am adding them one at a time i am adding Them to the…
-
Issue in Web Content Widget
Hi Team, Please help us on Web Content Widget, as i am facing issue when i add a Weblink of a power BI dashboard, when follow the actual procedure it is ending up with an error. Attached snipped for your reference. Thanks, Santhosh Kumar B