API & Developers

Archives for February 2022

Inconsistent responses about PUT request to update row(s)
Hello Smartsheet Community! I've been getting a lot of issues recently with my PUT requests to update rows. To test it out, this is what I am doing. I created a sheet with 6500 rows and 17 column. I've fiddled with the number a bit and this is a good approximate for what I want to demonstrate. So I've tried to change one…
Workflows - No CC field to copy myself on automation tasks
I use workflow automation on my sheets and when I need to scale to multiple users in the sheet, I cannot see those workflows executed. Can you create a 'Cc Myself' function so I can receive the same messages or triggers I am sending to the recipients ? Is there a workaround you can recommend ?
How to backup only the sheets, and do not include attachments?
We have been using the Java API to backup our data. Since SS cannot keep the attachment links, It is not very useful, and it just takes up time and storage space. Is there a way to backup only sheets in excel file format? I've tried these parameters in properties file, but no success: downloadThreads=0 (not quite sure what…
Integrate Data from other platform with API Access Token
I've never used API Access Tokens, so not familiar with how that works; however, we just recently started using a program called Samsara that helps us gather metrics on our Shared Service drivers. I'm looking for a way to integrate the Samsara data into Smartsheet. We created an API Access Token in Samsara, but how do I…
API search/get multiple rows in a sheet
I need some help formulating an API call to retrieve multiple rows of data in a sheet that have a specific key word. I can successfully use the /2.0/search/sheets/xxxxxx?query="A2" query to get a list of rows however I don't know how to continue this query to then pull all the rows of data that match the query.
Linking to a Title Box on Dashboards
I have numerous Title Boxes on my Dashboard containing people's names. I want to list those names at the top of the dashboard so that when you click on a name it will take you to the Title Box with that name. Can this be done? and if so, How please?
Error when trying to log in to Smartsheet University
Expecting value: line 2 column 1 (char 2) I cannot access my courses? Can you help me.
API output to .xlsx using rowsModifiedSince
Is there a way to force the API to use the rowsModifiedSince parameter? Using JSON content type, it returns the filtered rows, but when I change to application/vnd.ms-excel, it includes all rows
API for administration
Has anyone used Smartsheet API to do an administrative task. For example, I would like to automate the process of going to Security Controls and modifying the list of approved domain sharing list.
Creating and Formatting Sheet Summary Field with API using Python
I am updating a handful of sheet summaries using Python. My current code creates the sheet summary fields that I want with the correct formulas however I am unable to get the formatting to work properly. Below is a partial screenshot of the code: According to the API docs I should be able to set the formatting of the sheet…

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