-
Issue with row "new event" trigger
Hi there, I am using make.com (formerly integromat) to update an external database whenever a row in my smartsheet is updated. The automation is set up so that whenever a row is updated, I get the row (all of the cells) and then send that data to update my database. I only need this to trigger when a cell value is changed.…
-
Public API not being supported anymore ?
Hi, Since January 9th the public repositories of smartsheet API are in the archived status (https://github.com/smartsheet-platform/smartsheet-csharp-sdk) . Are the public repositories still maintained ? What about the latest version of the nuget package (currently 3.0.0), what commit does it represent to the githib…
-
Is there any way to get a sheetID from the KEY retrieved from a sheet access report?
I am a system admin, and we recently had to let go of our other system admin. I am trying to find out what sheets he had access to that I didn't, so I could could access to those sheets. The only way I can compare what I have access to versus was he had access to was a sheet access report, which has a sheet Key, not the…
-
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…
