Product questions?
Sign in and ask it here! The community's got your back.

API & Developers

Connect with other developers from around the world and collaborate on ideas using the Smartsheet API.

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…
Using Smartsheet API to Access User Data Outside of My Own Account
Hello, I would like to build an OAuth integration with Smartsheet that would allow me to access data from users whose Smartsheet accounts are different from my own Smartsheet account. Is this possible with the Smartsheet API? Thanks, Farhana
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?
Hello Guys!
I´m using Data Shuttle to offload data from a Sheet to a csv file. I´m having a constant error which is new : "Workflow Execute: Your workflow maps columns that no longer exist. Please refresh your mapping to remove the deleted columns." I tried to go and edit the workflow to refresh the mapping but it didnt work. i didnt…
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…
Data Shuttle Data Mesh Schedule Run Times
I have issues with my automated systems failing due to timing both with Data Mesh and Data Shuttle. It is necessary that six Data Shuttle workflows run the same time otherwise they occasionally fail due to them fighting over the same certificate when obtaining information from my cloud account. This causes a catastrophic…
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…

Trending in API & Developers

SmartSheet API call via Alteryx
Hello, I have recently built an Alteryx model to extract data from various smartsheets that I have access to. While the model does what it needs to do, the API call seems to work only on a random selection smartsheet IDs. As a first step, I am extracting the details of the smartsheets that I am given access to (just the…
Bridge: Move select columns/attachments/comments to another sheet
Hello all! I'm looking to see if a Bridge workflow can be done with moving/copying select columns from one sheet to another BUT also bringing their attachments/comments over as well. I've made a workflow to copy select columns from a source sheet to a targeted sheet but never have the comments/attachment follow. I have a…
is it correct passing time frame as an object to resource management reports API?
Hello, When connecting to the report rows endpoint, I am receiving an error when using the timeframe as shown in the API documentation. "time_frame":{ "from": "2022-01-01", "to":"2022-12-31"} Error message received: {'message': 'to is not a valid time_frame'} I also tried to pass the 'from' and 'to' as a separate parameter…

API & Developers

Categories

Popular Tags

API & Developers

Discussion List

Categories

Popular Tags