API & Developers

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

Script to get data from Google Sheet to Smartsheet
I'm trying pull data from either s csv or google sheet. Can anyone explain to me what is wrong with my script below? No matter how hard I try I get the error: "Unable to parse request. The following error occurred: Field \"null\" was of unexpected type.", function copyDataFromGoogleSheetToSmartsheet() { var…
JAVA SDK - Update a Multi Picklist
Hello, I am having trouble updating the value of a multi-picklist in my sheet. I am using the Java SDK smartsheet-sdk-java 3.1.1, on Java 17. I am setting the column value with the following code: Cell c = new Cell(column.getId()); c.setObjectValue(new MultiPicklistObjectValue(List.of("All", "Some", "None"))); My column I…
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…
Power automate question (multi-contact list)
I'm using power automate to wire up some info into smartsheets. I have everything working so far but multi contact list and multi pick list. The contact list error I get is this: The value "John smith" could not be saved in column "Assignment". This column is restricted to MULTI_CONTACT_LIST values only. The name is…
How to get page 2 of the reports list from the API /reports endpoint?
Hello! Perhaps I'm being dense, but how do you get page 2 results from the API using this endpoint using CURL: https://api.smartsheet.com/2.0/reports I can see that there are 3 pages from the response to this endpoint: "pageNumber": 1, "pageSize": 100, "totalPages": 3, Thanks in advance.
Add row with multiple values in cell using c# sdk
One of columns has 'Contact List' type with checked 'Allow multiple contacts per cell' see example. I tried to add row using smartsheet-csharp-sdk(v2.3). Cell object: new Cell { ColumnId = 111111, Value = "Test@test.com", Strict = false } and I got the next error: { "errorCode": 1235, "message": "Value is not supported for…
Generating click.smartsheet email
Hey guys, I am helping a client elevate their Smartsheet setup. Currently, they have an email automation that sends an email to a customer when a certain field in smartsheet has been updated. The email contains a URL starting with "click.smartsheet", the customer clicks on it and updates certain fields in smartsheet. I…
End of Line Characters and automated API Reports
Our IT is getting automated reports with our API Key from Smartsheet and has sent me the following email / question: The end of line character in the file is also a line feed (LF), instead of line feed + carriage return (CR) that is common. This causes confusion for the processing, as when processing the file, it is not…
"Row Moved" not in Cell History when called by the API?
"When I call "List Cell History" with the API the "Row was moved from another sheet" does not show up. Am I doing something wrong? Why can't I get this cell history?
R package for Smartsheet
HI, Does anyone know of an R package for interacting with Smartsheet? Are there folks using R with Smartsheet? I am considering a project using R and I might start building out a package. Thanks Craig info@ngsanalytics.com www.ngsanalytics.com

Popular Tags

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

Trending in API & Developers

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…
Smartsheet API- Add Image To Cell
I'm trying to write a python code with the API that will add an image to a cell but I continuously get this error message. I'm trying to use this endpoint: POST /sheets/{sheetId}/rows/{rowId}/columns/{columnId}/cellimages based on this: https://developers.smartsheet.com/api/smartsheet/openapi/cellimages/addimagetocell

API & Developers

Discussion List

Categories

Popular Tags