API & Developers

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

How to avoid webhook triggering from cell format updates???
I'm using make.com to do some automations when certain columns in a row are updated. Works great until someone re-aligns the columns and updates 1500 cells at once, sending my webhook 1500 requests. I can filter them out by detecting the actual data cell history, but it still uses 3000 operations for no reason and ties up…
Form Customization
I was hoping there is a way to tap into the HTML of the forms to customize them a little more. I'm specifically unimpressed with the spacing options. The form looks as though it's made for mobile devices only. Also, is it possible to group questions? Ie all relevant questions enclosed in a box, same background color, etc.…
Smartsheet API in Python: Inaccessible 429 Response
I am trying to understand / plan for the rate limits, particularly for the get_cell_history method in the python api. When I run the code below, I see the following response printed to my console: {"response": {"statusCode": 429, "reason": "Too Many Requests", "content": {"errorCode": 4003, "message": "Rate limit…
Use API to detect change on ANY sheet?
I know you can use the API to poll for changes on a single sheet or a webhook to send changes whenever an individual sheet is changed. However, is there way to monitor an entire workspace (or the entire account I guess) for any changes that are made to any sheet?
I am unable to create a Developer Smartsheet Account using developer registration portal.
I am unable to create a new developer smartsheet account using the developer registration portal https://developers.smartsheet.com/register/ It throws an error. I have tried multiple times from different browsers or systems. Please help me out here. Thanks in advance.
Using a fillable PDF as a form to fill in Smartsheet
Hello, I am looking for ways to use fillable PDF (attached) as a form to fill out Smartsheet. Similar to how a form is generated in Smartsheet, is there a way for a fillable PDF to be used as a "custom form?" Each field can be defined and mapped beforehand to the corresponding smartsheet and "submit" would update the…
Is there a change log for the Smartsheet API Reference?
The Smartsheet API Reference shows that it was updated on 2022-07-13. Is there a way to see what changed?
Does SmartSheet back up all their accounts and associated sheets
Good morning, I have a question regarding Smart Sheets back up. If for some reason Smart Sheet was to go down and or crash do you guys keep a backup of all accounts and associated Smart Sheets connected to the accounts that the users can use to restore w.e Smart Sheets they need to recover
Getting last login information via API call
I have looked at the documentation for the API call but when I am hitting the users endpoint: https://api.smartsheet.com/2.0/users?include=lastLogin,source&includeAll=true it is not including the lastLogin information. If I hit: https://api.smartsheet.com/2.0/users?include=lastLogin then I will receive it for those users…
Update row based on cell value
I just wanted to ask if this is true: I am able to insert new rows in the sheet but now I am trying to update existing rows based on the primary column. Basically trying to develop an upsert integration. Looking at the Update Rows api docs, it seems like I will need to get the Row Id first of all the existing data/rows in…

Popular Tags

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

Trending in API & Developers

Snowflake Data into Smartsheet?
Hey everyone, Do you know if there is a way to connect Snowflake data into Smartsheet using the API? I have found many resources on getting Smartsheet data into Snowflake but nothing on the other way around. We are trying to either do something native within Smartsheet or use an open-source software such as Airbyte.
Parsing Multi Picklist through API
Hi everyone, I just started working with the SmartSheet API. So far, everything has been straightforward, except one thing; I am trying to submit new rows to a sheet but can't seem to get the value of the Multi Picklist right. If submitted as a string in various formats, the value only displays as one long tag including…
BRIDGE/API: Add Users to Group from Sheet?
Hey Y'all! I'M STUCK on the next step for my Bridge solution. I'm simply trying to add members to a group named "GroupTest" if the [Approval Status] in this sheet (image below) gets marked as "Approved", but only if it's not already in the group. Eventually, I also need to have the status of "REJECT" remove them from the…

API & Developers

Discussion List

Categories

Popular Tags