API & Developers

Connect with other developers from around the world and collaborate on ideas using the Smartsheet API.

Did Smartsheet change its Timestamp syntax for webhooks?
Recently my python script [which takes in a webhook and outputs some row updates] has broken with the following error: [ pid=818344, time=2022-05-24 23:06:11,180 ]: /home/jw0nfo8iwcla/virtualenv/dj_app_01/3.7/lib/python3.7/site-packages/django/db/models/fields/__init__.py:1421: RuntimeWarning: DateTimeField…
What is the correct syntax for includeAll=true when pulling a report from the API?
Hi, I am using an API token to import smartsheet report data into Power Query in MS Excel. If I pass no information about pageSize or includeAll I get 100 rows returned. If I use the following: = Json.Document(Web.Contents("https://api.smartsheet.com/2.0/reports/8695992879998852/?pageSize=10013",…
Region EU sheets - how to connect with AppSheet?
Hi all, we moved with our licences to the region EU and don't know how to connect a sheet from AppSheet? Is there any solution because the AppSheet connector do not give us the possibillity to select a region. @Genevieve P. any idea? Thank you very much, Joachim
Commenter access level in API
Hello, I have shared a sheet with a user using Commenter access level. But when I request for shares with API I get VIEWER access level in response. How can I get a real value for Commenter access level? Also is it possible to set Commenter access level with API? Thanks, Michael
I can't find which column is "frozen"
I am working on a sheet built by another person, and they have frozen a column, but I'll be darned if I can find which one it is, and I've right-clicked on every column, and not seen an "Unfreeze Column" option listed. Any ideas how I can clear the Freeze Column? Thanks.
Populating a Dropdown List
Hi, is it possible to populate the contents of a dropdown list from another smartsheet?
Difference between users and contacts in API
While reading the API documentations I came through two API's one is list contact and another is list user https://api.smartsheet.com/2.0/contacts https://api.smartsheet.com/2.0/users what is the actual difference between them. Whether I need to add my assignee to contacts or users using API.
Smartsheet is duplicated multiple dates in G Calendar.
Hey, We have our Smartsheet's linked to our google Calendar. Events under a year look fine, however, over 1 year, these start to multiple and we have some dates with 700 duplicated events on the same day for the same event. This is causing major issues with our website that is then linked to these diaries. Anyone else have…
Is the Owner/Owner_id attribute broken?
I'm using Python and I've tried numerous ways to obtain the owner of various sheets via the API but it always returns "None," regardless of whether or not I include owner info in the get sheet command. I can get the owners of sheets when listing org sheets but the API documentation and the github repository seem to make it…
POST request form answer and css of questionnaire
I have to embed the form in our website, so I can see two ways of doing it. Somehow changing CSS of the form to fit the rest of the website, this would be preferred, any way of doing this? Or creating a custom form on our end and send a post request with the filled answers to your backend. I see that the submit button…

Popular Tags

NEW Smartsheet API Documentation - bookmark the updated link! https://developers.smartsheet.com

Trending in API & Developers

API to modify FORM "Label"
I have to update 250 form labels on a single form. Is there ANY way to do this automatically? I am dreading doing this manually :) There doesn't appear to be any API functionality for forms according to the documentation. Am I just overlooking something or is this not possible? Thanks!
Bridge: How to automatically add users to "Licensed Users Group" or "Other Users Group"?
We're trying to maintain a "group" of users in our Smartsheet instance who are Licensed, so that we can use Smartsheet to share Licensed-user dashboards with them. And if they're not licensed, they would go into "Other Users Group" for a dashboard highlighting features available to free users. Currently, we intermittently…
API - Limit User Access to one report
I'm new to using Smartsheet and currently have access to one report. I’d like to access this report via the API, and I’m reaching out to check if it’s possible to get the necessary API access. However, I’ve heard from someone that API access can’t be restricted to a single report. I’ve looked through the Smartsheet…

API & Developers

Discussion List

Categories

Popular Tags