Product questions?
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.

Keep sandbox (deveoper) account in sync with production smartsheet account
Good day, Is it possible to use the Smartsheet API to keep data in sync between both accounts? i.e. replicating sheet data in workspaces, say once a day from production to sandbox. Or will you need to build a 3rd party application to facilitate this? Thanks! Kind regards, Pierre
Copy Folder API is slow. How to optimize it?
Hi, I've created a Smartsheet webhook to do multiple tasks but it timesout in 59 seconds. I cound Copy Folder API to be the slowest. How can I optimize copy folder api? I'm using Python.
SOURCE_SHEETS Report Inclusion not working?
Hello, We are trying to get the array of sheets using a GetReport with the SOURCE_SHEETS as part of the include and it always returns null. We are using the C# api. Is this a bug or are we doing something wrong? see code below: ReportInclusion[] include = new ReportInclusion[] { ReportInclusion.SOURCE_SHEETS }; Report…
Power Bi - How do i get the data held (comments) in Conversations into Power Bi?
I have successfully added Smartsheet to Power BI and its GREAT! How do i get the data held (comments) in Conversations into Power Bi?
Sorting Rows
Hi, I am working on something that requires to sort the Smartsheet based on a column. The type of column is 'TEXT_NUMBER'. 1/0/12 1/0/1 1/0/14 1/0/3 1/0/11 After sorting the smartsheet with the above column the result is this 1/0/1 1/0/11 1/0/12 1/0/14 1/0/3 I am using python sdk in my project, but it doesn't sort all the…
How to update value of a cell that have a Hyperlink by Smartsheeet API C# SDK?
We have to update value of a smartsheet Cell. This Cell contains Hyperlink to a different sheet. Hyperlink URL is assigned. We want to update this cell value by Smartsheet API C# SDK.
Accessing sheets within workspaces using the Smartsheet API
Hi! I am attempting to pull sheets from inside one of my workspaces using the api, but have run into issues passing both the workspace id and sheet id to GET in sequence. For example, I am able to use GET /workspaces/{workspaceid}to retrieve the workspace object and its contents, but how would I go about using a GET…
Combined Charts and Dashboard filter/Slicer
Hi, Anyone know if the Combined Charts and Dashboard slicer like in excel will be included on the Dashboard update on January 2021? Anyone know or has the scope of the updates? Anyone knows an alternative chart for line & bar combined chart?
Connecting to Smartsheet from Oracle Analytics Desktop 12c
Hello, Has anyone successfully connected to Smartsheet from Oracle Analytics Desktop 12c? I have installed the Smartsheet live data connector, created a 64 bit ODBC Connection (DSN), tested from within Excel. It works. Now I want to connect directly from a data visualization tool (Oracle's Analytics Desktop 12c) and I am…
Smartsheet API Error using Python
Hello all, I am trying to extract smartsheet data from a particular sheet using python and the Api but I keep getting an error preventing me from doing so. The code I use works for other sheets so I wonder whats preventing it from working now. The error I get is shown below. ApiError: {"result": {"code": 1006, "errorCode":…

Popular Tags

Trending in API & Developers

How to obtain sheet "created by" in Bridge for a child workflow
How can I use Bridge API Call OR Get Sheet OR another element to obtain the "Created By" metadata for use in a workflow? I see createdBy in the sheets summary in the SDK: sheetSummary - fields But I don't see it in the output of past runs of either the API Call or the Get Sheet element in Bridge. I see createdDate but not…
How and/or when does a CellLink Object 'status' get updated to 'BROKEN'?
Across our project portfolio, each project has a main project sheet. This sheet has rows added & deleted as tasks are added or canceled from a project. Individual departments have department specific tracking sheets which mirrors the task list in the in main project sheet and certain key values are linked to the main…
URL String - Any common thread between Sheet and Form?
Hi there, I came across a circumstance where someone had a link to the form but forgot where the sheet lives. Is there anything within the URL of the form that can bring you to just the sheet? I tried cutting out the 'form' from the URL, but unsuccessful. TYIA!

API & Developers

Discussion List

Categories

Popular Tags