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.

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…
What happens with webhooks after retries are exhausted?
In your docs, it states that if a webhook callback times out (30 seconds I think) or gets a status code between 400 and 599 excluding 410, it will be retried on an exponential back off strategy for 14 times. But what happens after those 14? Is it just that THAT PARTICULAR collection of events will be dropped, but other…

Popular Tags

Trending in API & Developers

How to obtain sheet "created by" in Bridge for a child workflow
How can I use Bridge API Call OR Get Sheet OR another element to obtain the "Created By" metadata for use in a workflow? I see createdBy in the sheets summary in the SDK: sheetSummary - fields But I don't see it in the output of past runs of either the API Call or the Get Sheet element in Bridge. I see createdDate but not…
How and/or when does a CellLink Object 'status' get updated to 'BROKEN'?
Across our project portfolio, each project has a main project sheet. This sheet has rows added & deleted as tasks are added or canceled from a project. Individual departments have department specific tracking sheets which mirrors the task list in the in main project sheet and certain key values are linked to the main…
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!

API & Developers

Discussion List

Categories

Popular Tags