Product questions?
Ask it here! The community's got your back.

API & Developers

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

I am trying to update an AutomationRule Object and getting an error:
Exception thrown: 'Smartsheet.Api.InvalidRequestException' in smartsheet-csharp-sdk.dll An exception of type 'Smartsheet.Api.InvalidRequestException' occurred in smartsheet-csharp-sdk.dll but was not handled in user code Required object attribute(s) are missing from your request: action.includedColumnIds. in C# the Action…
SmartSheetAPI PUT
Hello, I want to use the Smartsheet API to update the content of a cell. I have set the API key in the header and tried the following using Postman: PUT Request URL: https://api.smartsheet.com/2.0/sheets/{sheetId}/rows/{rowId}/cells/{columnId} Request Body (JSON): { "value": "test", "displayValue": "test" } However, I'm…
Python SDK API to add rows with Multi Columns to Smartsheet
I have a script that reads columns from my source Smartsheet (SS) and gets the values from the columns in the SS and stores them in variables. This code works. Where I am getting stuck is assigning the variables (2 or more columns) to a new row and then adding the row to the destination SS. For example: Source SS, reads…
Smartsheet IP Addresses for Network Restrictions
Hi! I am using Smartsheet webhooks to stream events of updates on items Along with hmac authorization, I also want to restrict network access so that requests coming from Smartsheet server will be catered, and all other go unauthorized can I get the set of IPs of Smartsheet?
Triggering Workflows without Accessing the Sheet
I have the following workflow: Sheet 1 (an individual project) statuses are updated Sheet 2 (a summary of that individual project) has calculated fields based off of counting types of statuses in Sheet 1 When Sheet 2 values change the row is copied over to Sheet 3 (a portfolio sheet) Since Sheet 3 is getting a new row each…
Reseting a row parentId
Hi, For some needs, i would like to reset the parentId value of a given row. what value should i be using to force the parentId to be reset ? I tried :0; null; "0"; "null" and none of them made any positive result :
API Access
Hi, Is there any access level to use API, because via API I can get the value from Smartsheet but I'm unable to update or insert. Thanks, Sandhiya P
Activity log of all smartsheet usage under my admin
Is there an API now or some way to find the last time a smartsheet was accessed? I don't want to have to traverse the settings behind each smartsheet and export a report one-by-one. I didn't see any recent threads about some API access to that information. Thank you!!
Dynamic Dropdowns
I've been able to create and update 1500 dropdowns within seconds. I know a big issue in this community is wishing their is some way to update dropdown selections, with a small tweak to my javascript, options array may not contain null elements. FIX: const options = rows.map(x => x.cells.length && x.cells[0].displayValue)…
How to update picklist column
Hi, Currently I have a few columns which contain individual list items, but when I send an update through the API they appear as a single string Is there a specific way I need to be sending list items so that each item appears individually?

Popular Tags

Trending in API & Developers

URL String - Any common thread between Sheet and Form?
Hi there, I came across a circumstance where someone had a link to the form but forgot where the sheet lives. Is there anything within the URL of the form that can bring you to just the sheet? I tried cutting out the 'form' from the URL, but unsuccessful. TYIA!
Newly Received 404 with Error Code 1006 on DELETE sheets/{sheetId}/rows API with ignoreRowsNotFound
Hey there, Was a recent breaking change pushed to the smartsheets API? Previously, when calling the DELETE Request to the rows endpoint, I would receive a 200 with a valid response. Now, when requesting a valid sheet, with a valid row, I am unable to get a 200 response and am only receiving 404 with error code 1006 in…
When I Copy Workspace, Everything Copies Fine Except for CellLinking
Hi, Using the API documentation, I'm able to copy entire workspaces which has been great for scalability. I've been noticing that the only thing that doesn't work correctly out of all the sheets, reports, and sights, is the cellLinks in my sheet. In the instructions, you can tell it all the different things to pull in. I'm…

API & Developers

Discussion List

Categories

Popular Tags