API & Developers

Archives for December 2020

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…
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.
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
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…
Can the Dynamic View form submission allow new entries to appear at the top of your Smartsheet?
I know this option is available in Smartsheet, but when you enter a form through dynamic view there is not an option to have new items to go to the top of the sheet.
I would like to hire a developer / smartsheet expert
I own a commercial construction company and use the basics in smartsheet regularly. I have a particular client we perform construction services for nationwide and I need to connect with someone who can build out a customized client portal (dashboard). We perform branch expansions, branch remodels and maintenance for this…
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?
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,…

Trending in API & Developers

Reseting a row parentId
Hi, For some needs, i would like to reset the parentId value of a given row. what value should i be using to force the parentId to be reset ? I tried :0; null; "0"; "null" and none of them made any positive result :
How to update picklist column
Hi, Currently I have a few columns which contain individual list items, but when I send an update through the API they appear as a single string Is there a specific way I need to be sending list items so that each item appears individually?
Creating Webhook with subscope
Hi, I am trying to create a webhook via payload with the request body like the one below, which is an example from the API document, it failed and returned a HTTP status code 400. { "callbackUrl": "https://www.myApp.com/webhooks", "enabled": true, "events": [ "*.*" ], "name": "Webhook for Sheet Creation", "version": 1,…

API & Developers

Discussion List