-
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…
-
Quickbooks & Smartsheet
So. I've been working on this Quickbooks & Smartsheet Integration for a couple of years now for my own internal use. It has many application & the proof of concept exists and we use it. We use it for an approval process (for invoices): The power of Smartsheet i.e. (approvals, communication, notes) makes this a beautiful…
-
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?
