API & Developers

Archives for May 2022

Internal Server Error Please contact Smartsheet
Hi, I received the following error message when running the API: {"response": {"statusCode": 500, "reason": "Internal Server Error", "content": {"errorCode": 4000, "message": "An unexpected error has occurred. Please contact the Support team at https://help.smartsheet.com/contact for assistance.", "refId":…
Getting a Template's columns and rows using the API
Is there a method for retrieving a Template's columns and rows using the API? Trying to use the "Get Sheet" API method (e.g., /sheets/{sheetId}) with a Template ID returns a "Not Found". For now, I'm working around this by doing a "Create Sheet from Template", inspecting that temporary sheet as I need to, then deleting the…
Event Reporting User Events total fetch
Hi, Can you please let us know if there is any way We can check how many total user events have been fetched from my Account till today vis Event Report API(https://api.smartsheet.com/2.0/events)? Thank you
Webhook cant be enabled
Hello. On trying to enable a webhook , I encounter an error like- "disabledDetails": "An error occurred during SSL handshake: the peer's identity could not be verified." I'm not able to find a proper solution for it. Please help me out with the possible causes and fixes for the error. Thank you.
Is there a way to attach an URL to a proof?
Hello, I am able to create a proof with a link instead of file from UI. But I cannot see such functionality in API. I tried to do a POST request to /sheets/{sheetId}/proofs/{proofId}/attachments with the same JSON body like for adding URL to a row but with no luck - "errorCode" : 1011, "message" : "A required header was…
Did Smartsheet change its Timestamp syntax for webhooks?
Recently my python script [which takes in a webhook and outputs some row updates] has broken with the following error: [ pid=818344, time=2022-05-24 23:06:11,180 ]: /home/jw0nfo8iwcla/virtualenv/dj_app_01/3.7/lib/python3.7/site-packages/django/db/models/fields/__init__.py:1421: RuntimeWarning: DateTimeField…
How to test rate limiting algorithm?
I am building an app that I hope (and believe) will rarely if ever hit up against the Smartsheet rate limits. But of course in building a resilient app, I have to consider that it might. So I have built out a framework for handling rate limiting, and of course can test that in a mocked environment, but I would like to do…
What is the correct syntax for includeAll=true when pulling a report from the API?
Hi, I am using an API token to import smartsheet report data into Power Query in MS Excel. If I pass no information about pageSize or includeAll I get 100 rows returned. If I use the following: = Json.Document(Web.Contents("https://api.smartsheet.com/2.0/reports/8695992879998852/?pageSize=10013",…
Got many timeout errors recently.
Hi, I am extensivly using the api for years (using the C# sdk) , and in the pasts month i get more an more error relative to timeouts: Server timeout exceeded. Request has failed. at Smartsheet.Api.Internal.AbstractResources.HandleError(HttpResponse response) at…
Region EU sheets - how to connect with AppSheet?
Hi all, we moved with our licences to the region EU and don't know how to connect a sheet from AppSheet? Is there any solution because the AppSheet connector do not give us the possibillity to select a region. @Genevieve P. any idea? Thank you very much, Joachim

Trending in API & Developers

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 :
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?
Creating Webhook with subscope
Hi, I am trying to create a webhook via payload with the request body like the one below, which is an example from the API document, it failed and returned a HTTP status code 400. { "callbackUrl": "https://www.myApp.com/webhooks", "enabled": true, "events": [ "*.*" ], "name": "Webhook for Sheet Creation", "version": 1,…

API & Developers

Discussion List