API & Developers

Connect with other developers from around the world and collaborate on ideas using the Smartsheet API.

While posting data in smartsheet from servicenow i get this below error
I am using the below payload to insert rows var row = [ { "toTop": true, "cells": [ { "columnId": 8555792218515332, "value": "123" }, { "columnId": 393017893906308, "value": "123", "strict": false }, { "columnId": 4896617521276804, "value": "123", "strict": false }, { "columnId": 2644817707591556, "value": "555", "strict":…
API License - Not tied to user
Hello, We are using API within a larger report and for auditing reasons we don't necessarily want the user's name that built the API to populate every time the job runs. Is there a way to create a license or account with just the API - not connected to an individual/employee? We understand that this may require an…
Who else needs an input box to include a line # to jump to your plan?
My plans are usually more than 3k lines, scrolling them to find something in particular is painful and not effective specially when you are doing status calls or presentations. I heard that Dev team is promising to include this input box in the first line-title of the plan so you can input the line number and it will jump…
How to attach URLs to a row using the Node.js SDK?
This discussion was created from comments split from: Attach File or URL to Row - Request Body for cURL or Python.
Bridge - Renaming key(s) in array?
In bridge, I am using the "Search Sheet" integration and return "LAST NAME", "FIRST NAME", "EMAIL" in an array. I am wondering if there is way to convert the key(s) to different names such as lastName, firstName, and "email" for each object in the array? The solution I am currently doing involves just renaming the columns……
Some API calls are failing this morning
Is anyone having problems with the API hanging and then erring out? It's acting this way for retrieving items from the attachments call. Given the issues last Tuesday, I was curious if anyone else was experiencing these issues. I have submitted a support ticket. - Marc
Update the value of a contact
I am using the Smartsheet Python library, but this could also apply to the API. I am having trouble updating the Assigned To column, which I see is actually a column type of contact list. I have tried specifying a cell value and I get an error message saying "'Value is not supported for this column type. Use objectValue…
Setting Contact column to Placeholder using the API
I am programmatically updating a sheet using the SmartSheets API. I need to set a column that is a CONTACT type to a Resource Manager placeholder. When I do, I get the error message "The value for cell in column 6143599851818884, did not conform to the strict requirements for type CONTACT." Typically a contact can be set…
Webhook subscope documentation error
In the webhook API documentation the subscope attribute is defined as follows. An object that contains an array of column Ids if you want to limit the subscription to a subscope. Specified when a webhook is created and cannot be changed. But then the example has the following. That is not an array of column ids. That is a…
Salesforce/Smartsheet Connector - Attachments??
Can the Smartsheet/Salesforce connector send an attachment from salesforce to Smartsheet?

Popular Tags

NEW Smartsheet API Documentation - bookmark the updated link! https://developers.smartsheet.com

Trending in API & Developers

Bridge Get Row Id not showing.
Good Afternoon I am new to Bridge and trying to create my first simple workflow to move rows but, I am having an issue with getting the row id. I have tried following the steps in other threads I found with no luck there is something I must be missing. I have a sheet where form entries are submitted. I setup the Smartsheet…
Share solution? Find and replace text in a Sheet (including inside formulas)
I’m trying to build a solution that can search for a specific text string in a Smartsheet — and replace it with another value — across all cells in the sheet, including inside formulas. I'm trying to find a way to "Replace text including in formulas" since this feature is not available within Smartsheet. I've been told can…
Issues with Excel from using Power Automate
We are trying to use Power Automate to pull in Excel attachments from email and put into One Drive, so we can then utilize Data Shuttle to pull in the data. For some reason it does not allow us to open the document, but it opens fine in the email. We have researched and have not found a fix for this issue. Does anyone have…

API & Developers

Discussion List

Categories

Popular Tags