API & Developers

Archives for July 2019

How to obtain access to WorkSheet Home without following 3-leg OAuth process
Hi. We are using SmartSheet to store multiple sheets that should be created by one person. This person will share one or more sheets in each of multiple workspaces. I am writing an application (in C#, hosted on AWS Lambda) that must access each Workspace, and Sheet, and read each Sheet. I am using the official SmartSheet…
API access token queries
Hello, We currently access SmartSheet Sheets using the latest version of the SmartSheet SDK. In our use-case, the plan is that only one person will create Sheets. It is this person that will have created the access token. There is only one application using this access token. This application is configured with the same…
Quickbooks & Smartsheet
So. I've been working on this Quickbooks & Smartsheet Integration for a couple of years now for my own internal use. It has many application & the proof of concept exists and we use it. We use it for an approval process (for invoices): The power of Smartsheet i.e. (approvals, communication, notes) makes this a beautiful…
Smartsheet Consultants Needed
Hi community, Our organization just purchased Smartsheet Enterprise License - and is looking for consultants to build the solutions which require API integration. We have contacted with Smartsheet internal team and they quoted us $12,900 + extra travel expense, just for 2 days on-site "discovery and planning workshop",…
Using an API with Smartsheet
I am interested in pulling information from the ISBN database into a Smartsheet using their API Does anyone know of a good resource to use to set this up in Smartsheet? Thanks
Smartsheet Lab - DocuSign
Is there a way to put parameters around what attachment does or does not integrate back into Smartsheet?
getting cell value by row id and column id
Hi, I am the primary column id. I want to iterate over rows and get cellvalues of the primary col in python. for MyRow in my_sheet.rows: After this is there any direct function to get the cell value using parameters MyRow.id,primary_col_id? Thanks
Alert a user when an automation isn't going to work
I have a sheet where there is potential for an incorrect email to be added via a form (SS requires an email be entered for it to populate correctly into a contact column if not in the SS directory-if you have a fix for this, I would love it!). As the owner, I am notified when a user will not be alerted due to an incorrect…
Sending form attachments to their own smartsheet or google drive folder
Hi everyone, We're currently trying to create a system that accepts form entries with attachments and stores those attachments in their own folder as soon as they are submitted. Preferrably, we would like this folder to update in real time and remove any attachments that are replaced when the same user uploads a different…
Automatically copy specific fields from new rows in one sheet to another
Hi Folks, We have an intake sheet / form and a separate project sheet. Goal is to automatically copy specific fields from new rows in the Intake sheet (source) to a different Project sheet (destination) each time a new row is entered by users. When a new row is entered, we want to copy (as a new row) specific fields from…

Trending in API & Developers

Python SDK API to add rows with Multi Columns to Smartsheet
I have a script that reads columns from my source Smartsheet (SS) and gets the values from the columns in the SS and stores them in variables. This code works. Where I am getting stuck is assigning the variables (2 or more columns) to a new row and then adding the row to the destination SS. For example: Source SS, reads…
Smartsheet IP Addresses for Network Restrictions
Hi! I am using Smartsheet webhooks to stream events of updates on items Along with hmac authorization, I also want to restrict network access so that requests coming from Smartsheet server will be catered, and all other go unauthorized can I get the set of IPs of Smartsheet?
Reseting a row parentId
Hi, For some needs, i would like to reset the parentId value of a given row. what value should i be using to force the parentId to be reset ? I tried :0; null; "0"; "null" and none of them made any positive result :

API & Developers

Discussion List