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

Smartsheet API Documentation unexpectedly asking for login (23 Apr)
I'm unable to log into the smart sheet API Documentation. Till yesterday I was able to access the API documentation did not prompt for login. Kindly help me log in to SmartSheet Official API and SDK Documentation Log in with Redocly
QR Codes/Bar Codes
Dear Smartsheet Community. Is there a means within Smartsheet to allocate a unique QR/Bar Code to a specific line in a grid, such that if you subsequently scan the code (outside of Smartsheet), the specific line/data record can be accessed? For now, I am thinking of an image of the relevant code added in a cell as an…
Moving many rows to another sheet?
My task is to move 3500+ rows to an archive sheet every two weeks. I'm using the python SDK Sheets.move_rows() command but am running into a timeout error (4002) after just 250 rows (granted there are a lot of columns). Can anyone recommend a better method than telling python to loop through the list, moving 250 at a time?…

API & Developers

Discussion List