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.

Powerbi and Youtube Analytics
I want to link Powerbi and youtube API. I found a good way to do this https://github.com/migueesc123/YoutubeAnalytics with external connector... I already set up a new project in google developper console with Oauth credential and redirect URI... In Powerbi, I choose the connector and powerbi ask me to log in. After this…
Python : Unable to import 'smartsheet' pylint(import-error) [1, 1]
I am new to the SmartSheet API and am writing my first Python program using the API. When I write my first line of code (i.e., import smartsheet), I receive the error message below: Unable to import 'smartsheet' pylint(import-error) [1, 1] I installed Smartsheet's Python SDK via the terminal without issue before I started…
Bad Gateway Error when automating Office Forms API to Smartsheet
Solved: BadGateway error 502 - Power Platform Community (microsoft.com) Not sure how many of you are using Microsoft Forms to collect information and having a flow process to create a new row into smartsheet . Everything points to smartsheet, please see details in the link provided above. Can anyone from Smartsheet Support…
File Attachment to Row
Hi Team , I am trying to attach file to smartsheet row with the following details, https://api.smartsheet.com/2.0/sheets/{Sheet ID }/rows/{ Row ID }/attachments Header : Authorization:Bearer {ACCESS TOKEN} Content-Type:image/jpeg Content-Disposition:attachment; filename="C:\1.jpeg" ContentLength:64 Response I am getting…
Updating a cell in a column formula is not supported. columnId
Hi All, I am trying to update a smartsheet from a sql table. Several of the columns in the smartsheet have column formula's thus, when I try to update them, the API throws the error: "Updating a cell in a column formula is not supported. columnId" In my code, I open the smartsheet and read all the columns to build a model.…
Webhook is not triggering in Smartsheet
Hi Team, We are creating a webhook via API for Smartsheet sheet. After creating webhook we will add some data in the sheet to trigger the event. In some point of time the webhook is not triggering. Can you please help us here.
Sheet Summary Report From Smartsheet Into Appsheet
Greetings, I'm attempting to retrieve a Sheet Summary Report as a 'read-only' table in Appsheet. The error I'm receiving... The report you are attempting to open is a sheet summary report, which requires a query parameter of 'level=2' (or higher if available) to be specified in the API request. → Error 5623 in…
Does the unique row id have a check digit?
I need the row id (usually 16-digit) to perform query joins, to get info on attachments and their contents. In the code below, I append the row ids to an Excel sheet, but the Excel file converts back to INT. This may be a problem, as Excel only handles 15-digit INT and drops the last digit to 0. It won't be a problem if…
Pushing a Tableau User Name into Form-Fill through the URL
I currently use a Smartsheet Form-Fill that instantly creates commentary on a Tableau dashboard of mine. However, when a Tableau user is putting in commentary via the preset fields using a URL show/hide feature and then hits submit - the Created By reflects web-form@smartsheet.com on the Smartsheet Does anyone know of a…
Create Automation in the API
Any chance this is in the works? I'm not seeing a way to do in the API documentation and it'd be nice to automatically create an auotmation rule across 100 sheets instead of manually doing it.

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