API & Developers

Archives for December 2021

Whats the easiest way to add a row of data into smartheet using the API for c#?
The sheet will only contain 1 row, and I'm looking for the easiest way to insert the data using C# into that row.
API - C# - Delete rows from a specific index
Hi there, I'm newbie on Smartsheet. I am working on integration of data from another system to Smartsheet through API. The requirement is that we need to delete all rows from the fourth row to the last one of sheet then adding the new data into sheet every time we run API. I've already implemented adding row data into…
Log4j Vunerabillity and Smartsheet
Has anyone seen a statement or received a statement regarding the Log4J vulnerability and Smartsheet cloud or on prem? Just doing due diligence as regards this issue. https://www.cisa.gov/uscert/apache-log4j-vulnerability-guidance
API returns status code 500 with error code 4000
Hello. We need some help. Sometimes we have API returns status code 500 with error code 4000. Example of error body: { statusCode: 500, errorCode: 4000, message: 'An unexpected error has occurred. Please contact the Support team at https://help.smartsheet.com/contact for assis tance.', refId: '1epuw7ruti51a' } This happens…
Resource Manager: How to assign approver using API
Hello! I've been reviewing the API documentation for Resource Management (https://10kft.github.io/10kft-api/). I was able to add a new user using the API. However, now I also need to assign an approver for the user profile. I found I can send a GET request to the…
How to get highlighted cell reference using API call?
I am working on automation project and we need to get yellow highlighted cell reference details using API call. I have to get recently updated cell (for example the cell that has been updated today is highlighted in yellow).
Updating a Multi_Contact_List cell with values not containing an email
Hi everyone I have a put request to a Multi_Contact_List cell that i want to contain one email value and one name not containing an email. Currently this is my put request, but I don't think the cell.attribute "email" is fitting here and value/displayValue etc. has also not worked for me. I also tried with "name", but this…
Resource Management (10,000ft) API Sample
Hi, I'm looking for sample api requests to update multiple custom fields at the same time. Is this possible? As of now, I can do this for one field at a time using the below but since we have multiple custom fields in use want to update in one shot PUT /api/v1/users/<user_id>/custom_field_values/<id> curl --location…

Trending in API & Developers

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?…
Bridge Search for a value - What are the modules to use?
I have a use case as follows: When a row changes or is added in the source sheet, I want to search for the row's column named "Key" against a column also named "Key" on a target sheet. If found I want to update a column named "History" in the target sheet that matches the source sheet's key. I also want to write the word…

API & Developers

Discussion List