API & Developers

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

Smartsheet API - Add sheets to existing sheets.
Hello, Is there a way via the API to be able to add existing sheets to another sheet under a different folder. We are currently doing this manually.
Webhook delay with attachments (1-2hours!)
Hello! I'm using webhooks to notify me when a file is attached either to a sheet or a row. Sometimes I get a notification after the usual delay of ~1 minute, however I regularly see cases where there is a delay of around 1-2 hours. I don't see this delay when making row/cell changes to the sheet. I always get the webhook…
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.
Bulk POST operation syntax
Hi. I have been able to stumble my way to successfully add new rows to my Smartsheet with the POST API request. However, I can't figure out the correct format to send more than one row at a time. I see reference to Bulk Operations in the documentation but I can't find any examples of exactly what that looks like. Would…
Cell last update timestamp from api
Hi, Is there a way to get a cell last update datetime from api, that is not using get_cell_history? I'm asking because get_cell_history is an expensive call (takes 10 tokens).
PowerAutomate - Insert row
I am using the the Smartsheet Connector in Power Automate. It all works fine, if I am using "insert row" with a fixed sheet name. But if i want to use a dynamic sheet ID, am ask for row Can anybody help me, what values in which format I have to put in this field. I could not find any documentation.
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…
Error using Invoke Web Service
URL: https://api.smartsheet.com/2.0/workspaces Method: POST Accept: Application/json Custom Headers: Authorization: Bearer %my API Code% Conent-Type: application/json Content Type: Application/json Request body: %RequestBody% Save response: Get text into variable (for web pages) Variables produced WebServiceREsponseHeaders…
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…
Update Smartsheet table with data from SQL DB
HI there. I'm not very familiar with SMartsheet yet, but i'm gradually getting the hang of it. I succeed to connect a sheet in PowerBI with the integrated connector, and now I need a step forward: I have some data in SQL tables and i'd like to take those data from SQL BS server and upload a table in Smartsheet. I was…

Popular Tags

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

Trending in API & Developers

unable to move a row in Python
I use Smartsheet to govern a project that does ~10k tasks per year so automating as much of the project is extremely helpful. I have multiple python scripts that are updating sheets and grabbing data form sheets but this is the first time i have tried to move data in a sheet. I am trying to move a row below another row…
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…

API & Developers

Discussion List

Categories

Popular Tags