-
Any requirements imposed for the DATE type columns?
Hello, Is there any recent update or modification in Smartsheet that imposes new requirements for the DATE type columns, even when restricted date-only is not selected? My script, which previously (till yesterday) ran successfully without converting date strings to ISO format, is now encountering an error code 5536,…
-
Bridge - Extract From Array - Key
I'm trying to extract the values from a row into a consolidated list. In this scenario I think I can use either the Get Sheet or Search Sheet node to identify my list of values, but I'm unsure of how to format the key in either scenario so all values are presented in a consolidated list. Could someone please help me figure…
-
How do I get a report id from the permalink?
I have not been able to find a path forward in the api documentation, but ultimately I need the report ID after a user pastes their report permalink. How do I get a report ID from a report permalink?
-
Facing a NaN error code
Hi, I am working on adding rows to the smart sheet using JavaScript Node.js SDK, but I am facing this error, the error does not give me the error message and error code. This is the smart sheet error message Error Code: NaN - Cannot read properties of undefined (reading 'status') Ref ID: undefined (node:7328) Warning: a…
-
Aderant integrations
Has anyone used Aderant API or data to sync with Smartsheet financial data? I'm curious on the connectors available or if only a token is required.
-
Smartsheet Automations and API/Webhook Calls
Hi there, We have a sheet then when an item in the sheet is marked as complete it is moved to an Archive sheet using Automation. The problem is there is so much data in a short period of time that we hit the sheet cell limit and have to export the data out into a CSV. I am wondering if there is a way using automation to…
-
Issue in using Smartsheet CSharp SDK in SSIS Package
Hi, I am using Smartsheet CSharp SDK in SSIS Script Task. I added it by nuget package, but getting error as below : Error CS0246 The type or namespace name 'Smartsheet' could not be found (are you missing a using directive or an assembly reference?) Then, I downloaded Smartsheet CSharp SDK and added reference to the dll…
-
API "Search" Endpoint: Offline?
Is the "search" API endpoint nonfunctional at present? All other endpoints seem to be functional on my end (sheets, folders, etc.). This has been tested with both the requests library in Python and in Power Query web requests in Power BI. PQ web requests returns a 500 internal server error. The Python web request returns…
-
When setting up the API - it says to share the sheet with the Key what email address do you use?
I have my API key and I know what sheet I want to connect through the API. The instructions say to Share the Sheet: In the sharing settings, make sure that the Smartsheet API token (represented by an email address) has been added as a collaborator or viewer. Click on the "Share" button or the sharing icon, usually…
-
Download PDF from a row and get it with a watermark
Good afternoon everyone, I am currently working on developing a Smartsheet for document management for a client. The client requests that when downloading, sending, or previewing the attached documents in PDF format on each row of this Smartsheet, a watermark or text at the bottom of the page is added stating "Authorized…