-
Date Format in Bridge
Hello, I was trying to get date out from smartsheet to smartsheet bridge to do integration. However, when I see log file, the date is very different format and I cannot reformat the date using utility function: The Appt Date, DOB and Start Date is all coming from date from Smartsheet, could someone help me on this? Thank…
-
How can I copy a row's attachements to another row with Bridge?
-
Workaround for PowerBI Navigator record limit
Problem statement: When looking to utilise PowerBI via the Live Data Connector I was unable to find the sheets I wanted to connect. Cause: The PowerBI Navigator will return a maximum of 10,000 records from a given source. Workaround: I've managed to work around this by setting up a second DSN connection for the Live Data…
-
Live Data Connector not finding sheet
Hello, I've setup the Live Data Connector and it seems to be working correctly. But the sheet I'm an Admin on is not displaying as a possible connection. Does anyone know how I can fix this?
-
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…