-
Postgres SQL and updating records in Smartsheet
I am trying to keep an up to date list of different job information in Smartsheet. I would like to use this up to date information to reference data across different sheets but am struggling on how to exactly do this. I have a Postgres SQL API with the information I need, but can't seem to find a way to keep these records…
-
Workspace Shares - API (cURL) Error 1004 - Not Authorized to Perform This Action - 403 Forbidden
Hi all, I'm getting following error when trying to GET a list of workspace shares (GET /workspaces/{workspaceId}/shares) "errorCode": 1004, "message": "You are not authorized to perform this action." The same happens when trying to GET a specific workspace share (GET /workspaces/{workspaceId}/shares/{shareId}) Following…
-
Apostrophe added on mass insert thru CDATA
Hello, We are currently using a third party tool CDATA to upload excel data to a smartsheet. When any numeric data is entered, an apostrophe is always added to the beginning of the string. Upon checking the logs, CDATA is not sending an apostrophe to Smartsheet. The only thing I can think of is Smartsheet is adding the…
-
Smartsheet data connection in TIBCO Spotfire server
I am able to create an ODBC connection and get smartsheet data in my Spotfire Analyst client. I followed this link - https://smartsheet-platform.github.io/odbc-docs/#tibco-spotfire-desktop. However, I would like to create an information link and publish data in Spotfire library and share the web link with the users. The…
-
Add new_row including values for a multi-select dropdown via Python SDK
I've tried different thing but I still get the same error. When I try the following code: multival = smart.models.MultiPicklistObjectValue() multival.values = value new_cell.strict = True new_cell.object_value = multival new_row.cells.append(new_cell) The column submission looks like: "{"columnId": 7199257397618564,…
-
Report Row Sorting
I am trying to use reports to reduce the amount of columns and rows I need to handle via the API. Along with this, I would like to have the report also sort the rows, but it seems that when using the API make a Get Report request, the row numbers in the JSON response do not line up with the associated reports row numbers.…
-
*NEW: Proofing using Reports
The new Proofing capability is something we would like to implement in our department, but we are having issues with accessing this in Reports. We see that Proofing can be done in the main smart sheet, but our Artists access new design requests via Reports so that they only see what tasks and designs are assigned to them.…
-
Search rows API after create rows API from Power Automate/Flow returns incorrect row object ID's
I'm attempting to have a flow in Microsoft Power Automate/Flow create rows in a Smartsheet sheet and update a field once an approval outcome is present. The first part works with no problem - rows are created with a value in one column to help identify (e.g., SR001) - but after they're created, querying the sheet for all…
-
Is there anyway to autonomously get a sheet's forms?
Hello, I've been working with the Smartsheet API to automate many different things but does anyone know if there is a way to autonomously get the forms that exist in a sheet? I need to dynamically grab the link to a specific form for many sheets in an ongoing project. Thanks!