API & Developers

Archives for November 2021

How to auto-populate manager's Name for entered user in smarsheet
Hi All, I am working with the organization where i have asked to create an automation on smarsheet:- Task is Manager's Name should get auto populate in a column from the database directly on selecting User Name in other column. (contact Column) Can we do this? if yes, Could you please guide me on this how to perform above…
Error Code on multiple scripts - PLEASE HELP - URGENT
Request failed for https://api.smartsheet.com returned code 400. Truncated server response: { "errorCode" : 1012, "message" : "Required object attribute(s) are missing from your request: values.", "refId" : "1nw852hwpq9h0", "detail... (use muteHttpExceptions option to examine full response) Request failed…
How add column with Type Symbol and Limited to symbol only via API
Hi, I am struggling with an CALL api I need to add a column type Symbol with a validation = True If i put in my body options list, i got an error : Columns options are not allowed when symbol is specified If i remobed from my body options, i got an error: this type of column must have at least one option valu I'm a bit…
Calendar Notification/Alert
Hello, We are using this notification for an automated greeting for milestones. Other than custom message, we would like to include an image on our post. However when we are trying to include the column with the image, its not going through. The message is showing the file name of the image (see image below). Adding the…
How to set the value via Python APIs for simple CONTACT_LIST column ?
Hi, i have the column where the type is CONTACT_LIST (single value only, not multiple values) ... here is the code snippet: case_owner_email = "owner.name@company.com" new_row.cells.append({ 'column_id': project_metadata_column_map["Case Owner"], 'value': case_owner_email }) all my email addresses are correct, and all my…
How to set the value via Python APIs for simple CONTACT_LIST column ?
Hi, i have the column where the type is CONTACT_LIST (single value only, not multiple values) ... here is the code snippet: case_owner_email = "owner.name@company.com" new_row.cells.append({ 'column_id': project_metadata_column_map["Case Owner"], 'value': case_owner_email }) all my email addresses are correct, and all my…
To make the Row ID (SmartSheet) reads its value from (Service Request #) column
After diving deeper in SmartSheet we notice that each row has an auto-generated ID to identify it, but to us what’s more important is our unique Id which is pre-created by our system (Service Request #), we have this unique number stored in specific column with unique value for each row in the sheet. So our question is…
How to make BULK request for: "create_cross_sheet_reference"
Hi, i need to create multiple cross sheet reference on the same sheet, and at the moment i'm doing one api call for each single reference ... is there a way to do this in a bulk request: only one api call for multiple references on the same sheet ? thx ljk
smartsheet reference manager - Status "Processing"
Good Afternoon, all of my references are still in a status of processing, and I set these up on Friday 10.29.21. Do we have a way to get these going? Every time I do these, they take forever

Trending in API & Developers

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…
Smartsheet ODBC, Tableau, and DataTable
Hello, We are trying to connect Smartsheet data in a Smartsheet DataTable to Tableau. We have too much data for a single Smartsheet sheet to hold all the data. Is there a way to pull data from a Smartsheet DataTable into Tableau? So far the methods considered are: Smartsheet ODBC connector Not seeing the DataTable as…
Bridge - Error with POST call to API - Invalid Body
I'm trying to make a post call to an API using the "Call API" action within Bridge. Unfortunately, every time I try this action, it fails with an "Invalid Payload" response. I've tested the payload in Postman, and it seems to be working correctly. The API I'm using is a "POST" to a Slack Webhook. (It will automatically…

API & Developers

Discussion List