API & Developers

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

500. It run successfully once, the second try gave an error : Response: { status: 414 Request-URI Too Large content: { << text\/html; charset=iso-8859-1 content type suppressed >> } JSONDecodeError: Expecting value: line 1 column 1 (char 0) The code below reads a…","categoryID":320,"dateInserted":"2019-01-31T18:53:56+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2020-10-14T00:48:24+00:00","insertUserID":76971,"insertUser":{"userID":76971,"name":"Wdjameh","url":"https:\/\/community.smartsheet.com\/profile\/Wdjameh","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-01-31T18:45:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":5873,"lastUser":{"userID":5873,"name":"DanS","url":"https:\/\/community.smartsheet.com\/profile\/DanS","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nH14DQG3YON84.png","dateLastActive":"2022-10-20T05:14:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":893,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/40381\/smartsheet-api-delete-row-function-error","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/40381\/smartsheet-api-delete-row-function-error","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">

Can I auto-tab to a new field in forms when scanning barcodes
I am attempting to use barcode 128 with a control code to tab into the next field. When I scan the barcodes I am being pushed out into the address bar, instead of the next field. I've tried the Codes for Horizontal Tab, Vertical Tab, Line Feed and Form Feed. Is there a special code for smartsheet? I'm not super savvy, but…
Need help in setting SAML SSO for Transform Holding Cooperation
团队,我们需要设置SAML SSO THC和sm之间artsheet. For this we need below mentioned details. Request you to please provide the same : • XML metadata for their assertion consumer service (ACS), • a list of the LDAP attributes to be sent (if any. e.g.: givenName, sn, mail, uid, etc.), • which attribute is to be used…
how do I get sheet size in bytes prior to download into pdf
I want get the sheet size in bytes. how do I get sheet size in bytes prior to download into pdf
I am trying to get access token using Oauth
I am trying to integrate Power Automate (Workflow service) with SmartSheet using OAuth 2.0 I have got the code successfully and when I finally try to get the token, it throws the message - 'You are not authorized to perform this action.' with error code 1004 I tried in Postman with same result. Any help would be much…
Can i integrate Smartsheet with a location finder like google maps
I am creating a work inspection register on a large airport in Saudi arabia and I would like the contractor to provide the GPS co-ordinates of the location where the inspection will be required.
Notification with Attachments
Hi there, I would like to send a notification with an attachment based of a status change. The notification works, but doesn't include the attachment. I have seen on the community that this is not possible in SS - is this still true? If so, do you know of any good apps/software to automate that process? I have looked into…
moveRowToAnotherSheet not deleting rows from source sheet
Hi there, We're using the NodeJS SDK to move rows from one sheet to another on a timed job but we often find that rows landing in our destination sheet aren't removed from the source sheet. This means that over time we end up with a lot of duplicates in our destination sheets. Eventually, after some number of attempts to…
Python SDK - projectSettings - nonWorkingDays
年代o me and the Python SDK is having a bit of a disagreement about updating projectSettings of a sheet and the SDK just gives me an error (the audacity!). Reading the API docs (https://smartsheet-platform.github.io/api-docs/?python#projectsettings-object) my interpretation is this: nonWorkingDays: "...The format for the…
why does "ss_client.models.ContainerDestination({" cause an error?
import json import os import requests from datetime import date import warnings from SSToken import MyToken #MyToken from simple_smartsheet import smartsheet from simple_smartsheet.models import Sheet, Column, Row, Cell, ColumnType MyShtIDNo = xxx folderID = xxx new_sheet_name = xxx ss_client =…
年代martsheet API Delete Row Function Error
Hi, When I run a code to delete multiple columns in a sheet >500. It run successfully once, the second try gave an error : Response: { status: 414 Request-URI Too Large content: { << text/html; charset=iso-8859-1 content type suppressed >> } JSONDecodeError: Expecting value: line 1 column 1 (char 0) The code below reads a…