API & Developers

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

Python API Copy Sheet - Data not copying to new sheet
I am copying a sheet (source) to a new sheet (destination) using Smartsheet's SDK API. The copy of an empty sheet is the result. I tried the include parameter but it makes no difference. Does anyone know the correct syntax to use so when I copy a sheet the data within is copied to the destination sheet as well? Here's…
Inbound Links
Hi, I have a sheet with a million instances of "Used in Formula on <unknown sheet>". Is it possible to delete the "unknown sheet" references using the API and Python code?
What is the maximum limit of batch size to insert, update, or delete the rows?
Hi, For https://smartsheet.redoc.ly/tag/rows API for "Add Rows", "Update Rows" and "Delete Rows", how many records can we insert, update and delete per call request? Is there any limitation in the number of rows or batch size? If so, what's the limit and what kind of error would we receive beyond the limit? I did not…
Smartsheets and Acumatica
Acumatica shows a list of templates that can be used with the product. We have created several and have issues finding out new templates after publishing them. I wonder if anyone has found a way to find missing templates.
Does anyone have a Swagger file for the RM API?
Haven't been able to find a swagger file (JSON) for the RM API, wondering if anyone has either built one or got a Postman collection they can share? Many thanks Iain
Add a link to an existing cell that has validation turned on -- want to override the validation
I have the following code that has been working properly for quite sometime. It adds links to multiple sheets and cells. It is run from an account that has ADMIN access (and I can perform the desired functions in the UI successfully). #############ORIGINAL CODE################# def set_sheet_link(ss_client,…
What happens when webhook ongoing verification times out or gets a non-200 response
Hello - Your docs state that after every 100 callbacks is delivered to a webhook callback URL, there will be an ongoing verification request, similar to the original verification request. If that request happens to land when the server on the callback URL is down (which would lead to a timeout) or perhaps is in some kind…
Trying to connect Acumatica to Smartsheets
I keep getting an error and cannot find any explaination anywhere. There error says Unable to parse request. The following error occurred: Field "value" was not parsable. value must be a primitive type at [Source: java.io.PushbackInputStream@318c0afb; line: 1, column: 1012]. Could someone explain what I am doing wrong
Remove licenses from users using SmartSheet API
Hello all. I have a list of users who I want to transition to free collaborators. I want to do this using the API. I first tried using the deactivate method but it doesn't reclaim the license. It just blocks access to Smartsheet. I also tried using the update user method. The user sees that they are unlicensed. However, in…
Is it possible to create bulk/multiple sheets using Create Sheet API in a single call?
Is it possible to create bulk/multiple sheets using Create Sheet API in a single call? FYI: I am aware of looping the request to create multiple sheets, but how can I perform bulk creation within a single call? Please help me with knowing how to achieve this. The response schema in the API documentation allows me to think…

Popular Tags

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

Trending in API & Developers

Deactivate A Form
Is it possible to deactivate a Smartsheet Form using Power Automate?
API calls succeed but data requires manual File > Save to persist
API returns HTTP 200 SUCCESS Activity log shows "Rows Inserted" No data appears in sheet until manual File > Save. Data can be manually added (by a human) to the same sheet, but the data is not persistent until after File > Save. Browser correctly warns that leaving the page will lose the data. Activity log does not show…
rowNumber attribute for Row objects not accessible
When accessing the row objects of a Smartsheet, I can get some attributes, like row.id and row.expanded without issue, but when I try row.rowNumber it returns an AttributeError, saying that that attribute does not exist. By my understanding of the row object from the get_row response (Get Row), the attributes 'id',…

API & Developers

Discussion List

Categories

Popular Tags