API & Developers

Archives for July 2021

Report Sorting
I've created a report, collating information from about 20 plans. I've group the tasks from each sheet together but I can appear to only be able to order them alphabetically, rather than actually order them in the same order the task would appear in the plan. For example my 2nd task is appearing first in my report. Anyone…
Unable to move checkbox while integrating
I am trying to integrate Airtable with Smartsheet using API connections. In the process, I want to move a checkbox column within Airtable to another checkbox column in Smartsheet. When I tried with the below code it throws an error of Unable to parse request. if(record.get('Calendar') != undefined && record.get('Calendar')…
Beware of "Input column index X is different from the first input column index X"
If you try to create columns in one bulk request, do not give each column its own unique index. All the columns need one common index (example: 1), which is the starting point (from left to right) at which the entire column set will be created. If you try to give each column its own numeric index (1, 2, 3) in the request…
How to Implement Dynamic Dropdown among Two Sheets
A department wanted a way to take a unique list from a project column in one sheet and use that distinct listing as a dropdown for another sheet, which updated every hour. I currently run the below script from Python Anywhere on an hourly basis, and I have shared this script so that anyone else can use it as a template for…
How do you access user data once authentication is made in OAuth flow?
context: I integrated a Node.js Smartsheet Oauth flow into my Django app by having the login button in django direct the user to the /auth url on the Node server. Once the flow is done and user logs in through Smartsheet, the redirect URL from the Smartsheet dev tools takes the user back to the Django website. Objective: I…
How to "GET" from an xml file?
My company is using a helpdesk/support ticket/eForm program to receive requests, and then manually entering those tasks into smartsheet. The program will allow me to POST the data via XML at the same time as form submission. I am trying to figure out how to automate this so that the data will then automatically be passed…
SmartSheet Tableau Web Connector
Can anybody please share the tech document for SmartSheet - Tableau Web Connector?
Attributes not present in response
Hi team, I have couple of queries, could you please address those? Query 1. While fetching all the users, I am not getting groups associated to the users in the response. url: https://api.smartsheet.com/2.0/users?include=groups Note: I have referred the documents to include groups and I am sure that the users are…
Azure Functions App
I'm having issues deploying a python script to Azure Function App. I've developed it to handle some simple repetitive tasks using the API but am running into issues. I have a ticket in to support but was wondering if anyone else had experience using an HTTP triggered by Smartsheet webhook deployed to Azure.
Facility Bookings
Hi all. We manage many government/public venues and facilities (sports arena, stadium, parks etc) for which we facilitate bookings. At present, bookings are logged using outlook only viewed by one person. We'd like to begin using smartsheets for bookings so clients (the public) can view available (or unavailable) dates,…

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