Product questions?
Ask it here! The community's got your back.

API & Developers

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

Data Movements to Create Automated Workflows
Hi all, Quick question: We use qpulse as a quality reporting tool. We currently export data and manually enter it in Smartsheet from a .csv. I want to create a tool from that export, that drives a SQL import into Smartsheet, wherein the data from that import can automatically update my dashboards/reports/data source…
Keeping Track of Tableau Changes In Smartsheet
Hello, I currently have a sheet that links to various in-house Tableau dashboards: Is there a way for a user to click on one of the links, make changes to the dashboard, and then have Smartsheet show what changes were made? Ben O'Leary
Building A Test Package In SQL Dev That Writes To A Smartsheet
Hello, I am attempting to build a package in SQL Dev that takes data from a table in SQL Server and inserts it into a Smartsheet. For example, I have three lines of data in a table in SQL Server that I need to have added to a Smartsheet table. How do I go about creating a package that does this? I have never built a…
Column Specific Update Webhook Examples
I have successfully enabled a webhook to communicate with an Azure HTTP Trigger function which will run a Python script and perform other actions. This webhook only looks for row adds. I need a webhook for looking for an update to one column but don't understand the API documentation for scope and subscope. Does anyone…
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')…
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…
Delete and Lock row
Dear All I would like to know. Is it possible, if I want my team can edit the row but they can't delete it?
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.

Popular Tags

Trending in API & Developers

How to obtain sheet "created by" in Bridge for a child workflow
How can I use Bridge API Call OR Get Sheet OR another element to obtain the "Created By" metadata for use in a workflow? I see createdBy in the sheets summary in the SDK: sheetSummary - fields But I don't see it in the output of past runs of either the API Call or the Get Sheet element in Bridge. I see createdDate but not…
How and/or when does a CellLink Object 'status' get updated to 'BROKEN'?
Across our project portfolio, each project has a main project sheet. This sheet has rows added & deleted as tasks are added or canceled from a project. Individual departments have department specific tracking sheets which mirrors the task list in the in main project sheet and certain key values are linked to the main…
URL String - Any common thread between Sheet and Form?
Hi there, I came across a circumstance where someone had a link to the form but forgot where the sheet lives. Is there anything within the URL of the form that can bring you to just the sheet? I tried cutting out the 'form' from the URL, but unsuccessful. TYIA!

API & Developers

Discussion List

Categories

Popular Tags