API & Developers

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

errorCode: 5636, "message": You have reached the cell limit of 500,000 cells for this sheet.
Hello Community, I am trying to automate dataflow from excel to Smartsheet using Python. The excel has 12000+ rows and 42 Columns. The Python script was able to transfer 11000+ rows successfully, but then throwing these errors: ERROR:smartsheet.smartsheet:{"response": {"statusCode": 400, "reason": "Bad Request", "content":…
Drag & Drop Emails from Outlook to Smartsheet in Chrome & Email is Deleted from Outlook
When dragging the email from my Outlook window to Smartsheet in Google Chrome it removes the file from my Outlook entirely and the email is gone. I tested this in MS Edge and confirmed it does not happen when using Edge; the file copies and uploads to Smartsheet without deleting it from Outlook. * Windows 10 Pro for…
How quickly to webhook events need to be responded to?
When we get a webhook callback event, how quickly do we need to respond to it (presumably with HTTP status code 200) in order for Smartsheet not to mark that hook as "Timed Out"?
Webhook subscopes
When you specify a list of columnIds as the "subscope" for a webhook, what does that mean? Will you still get events for changes to the sheet, attachments, row order, etc..... things that aren't really relevant to a particular column, but filter out events on cells in that column or changes to the column itself? Or will…
Dashboard Widgets Not Showing up properly on Mobile (iPhone)
Hi All, Any idea on how to get my widgets showing up as they were before on my mobile device? They are web content widgets, and they used to show everything/be usable where I could input information - now they are just links. They work just fine on my computer. Thank you for any help!
Discrepancy in API document and response for Sheet Object
I noticed in the Sheet Object API document, https://smartsheet.redoc.ly/tag/sheetsObjects#section/Sheet-Object, the field is "proofs" object, while in the API response for the same for "Get Sheet" API, the field is a "proof" object. There is a difference in singular and plurality, Is this a discrepancy? Can you please help…
Question about nitpicky detail on dealing with infinite loop issues of Webhooks.
I think I understand that a webhook "Callback" is itself comprised of several "Callback Events", each of which may have its own changeAgent property, a string with a comma-separated list of change agents. Further I understand how I may append my own changeAgent designator in the SmartsheetChangeAgent header of any API I…
How to update the value of a summary field if it's text?
We introduced a new process where our team needs to fill in a bunch of summary fields for every smartsheet. I'm trying to update the data for summary fields using APIs for existing smartsheets as a backfill. I have all the data in a google sheet. I'm using Zapier to make the API call for every row in the google sheet. I…
How we can verify refresh token mechanism if token will expire in 7 days?
For our smartsheet account, Access token is getting expired in 7 days. As we refer to the support documents, we need to implement the refresh token to make it working continuously. One challenge we are facing here, after implementing a refresh token mechanism. We are not able to verify due to the current feature where…
Why did you break your API documentation?
it used to be top notch and extremely easy to use, now its a pain most of the important info is hidden! I mean for instance if you don't know where in the documentation to look for say update-cell syntax - you cant use the search to find it! If I am wrong what query string do you have to enter into the search to find the…

Popular Tags

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

Trending in API & Developers

Bridge Get Row Id not showing.
Good Afternoon I am new to Bridge and trying to create my first simple workflow to move rows but, I am having an issue with getting the row id. I have tried following the steps in other threads I found with no luck there is something I must be missing. I have a sheet where form entries are submitted. I setup the Smartsheet…
Share solution? Find and replace text in a Sheet (including inside formulas)
I’m trying to build a solution that can search for a specific text string in a Smartsheet — and replace it with another value — across all cells in the sheet, including inside formulas. I'm trying to find a way to "Replace text including in formulas" since this feature is not available within Smartsheet. I've been told can…
Issues with Excel from using Power Automate
We are trying to use Power Automate to pull in Excel attachments from email and put into One Drive, so we can then utilize Data Shuttle to pull in the data. For some reason it does not allow us to open the document, but it opens fine in the email. We have researched and have not found a fix for this issue. Does anyone have…

API & Developers

Discussion List

Categories

Popular Tags