API & Developers

Archives for October 2020

Get URL of a file attached to a row
Is there a way to get the URL of a file that is attached to a row? By way of example, if an arbitrary PDF file is attached, what is the url that results in previewing the file in a browser tab? In general this seems to be an https://s3.amazonaws.com/ storage location. For Arbitrary file.pdf in the image below (this link…
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…
10,000ft Update Project Error using API
Hello, This is an issue about 10,000ft API. The following error occurs when I tried to update a project using API "PUT /api/v1/projects/<project ID>". "HTTPError: Response code 500 (Internal Server Error)" The project update API works correctly for those projects without any activity. I wonder if this is a bug for 10,000ft…
API Catch form submission
Hello everyone, Do you know if there are some ways to catch a form submission with Smartsheet API, before the row is created in a sheet ? I did not find this information in the documentation. I need to do this to put some controls and verification to prevent someone from creating a form with a specific ID already existing…
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.
Need help in setting SAML SSO for Transform Holding Cooperation
Team, We need to setup SAML SSO between THC and smartsheet. 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…
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…
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
"send" function VS email recipient address NO longer displayed
At my company, we often use the function "send", to distribute emails to several people at the same time. This email contains important information & attachement. For years, this function has always sent the emails WITH all the recipients address clearly displayed into the emails heading. Seeing all the recipient is a…
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 =…

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