-
Update Columns API Possible Bug - unable to clear all options in a MULTI_PICKLIST column
NOTE: I tried to file this several times a support ticket, but the AI BOT was unable to create a ticket and the OG Support Portal no longer allows the direct creation of tickets. Grrrrrr. ISSUE: It appears that the Update Column API PUT https://api.smartsheet.com/2.0/sheets/{sheetId}/columns/{columnId} fails to work as…
-
How to bulk create cross sheet references using Python and Smartsheet API
Hello, This post provides a solution for quickly adding cross sheet references to a large number of sheets. The cross sheet reference refers to a single column. Caution The API code can update any sheet where you have permission to create cross sheet references. There is no way to automatically remove or edit cross sheet…
-
How to access the new end points via SDK
We were using python SDK to access smartsheet API's. Have seen most of the end points getting deprecated and provided new end points. Its providing the request with all params using direct API request in documentation. However no reference provided for using python SDK/other SDK's to access the API. Is Smarthsheet API…
-
How do you standardize addresses in Smartsheet?
Has anyone found a way to validate their address fields in Smartsheet? We are currently using a Smartsheet form to collect business license data and would like to integrate our data to ArcGIS to map the business locations. Currently, we are manually updating all of the citizen-submitted addresses which is a huge time suck.…
-
Power Automate EU connection
Hi, We just recently moved to the EU domain and I can't find a way to login within the microsoft connectors to update the flows I was suing on the US. Is there currently a solution? Thanks
-
Transferring files from Terminated "Provisional Members"
How do you transfer Smartsheet files belonging to Terminated "Provisional Members"? There are not the same options as for PAID Member users.
-
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…
-
Load sub children with the new api endpoints
The new api endpoints only returns the top level of a workspace or of a folder: As an example let's say i do that call : https://api.smartsheet.com/2.0/workspaces/1234567890/children?maxItems=1000 It will return only the sheets, reports, folder at the root of the workspace. (exact same behaviour for querying folders…
-
Merged: API/Bulk API to update license type for users
This discussion has been merged.
-
Provide API Access to Upgrade or Downgrade Users under User Subscription Model (USM)
We recently switched over to using USM for license management. This broke our automated scripts that gave users a license. We have a number of non-member employees who we cannot automatically update via the API. I'm told there is no solution for this and we are left manually updating our free users to a licensed member.…