API & Developers

Archives for November 2020

Smartsheet API Error using Python
Hello all, I am trying to extract smartsheet data from a particular sheet using python and the Api but I keep getting an error preventing me from doing so. The code I use works for other sheets so I wonder whats preventing it from working now. The error I get is shown below. ApiError: {"result": {"code": 1006, "errorCode":…
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…
How to find folder id for existing smartsheet
All, I am trying to create and maintain a bunch of smartsheets using the API. I would like to find an existing smartsheet to use as a template and create new smartsheets based on the source sheet and in the same folder as the source sheet. I have code to locate the source smartsheet as shown below. I can find the sheet no…
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.…
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…
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…

Trending in API & Developers

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?…
Bridge Search for a value - What are the modules to use?
I have a use case as follows: When a row changes or is added in the source sheet, I want to search for the row's column named "Key" against a column also named "Key" on a target sheet. If found I want to update a column named "History" in the target sheet that matches the source sheet's key. I also want to write the word…
Smartsheet ODBC, Tableau, and DataTable
Hello, We are trying to connect Smartsheet data in a Smartsheet DataTable to Tableau. We have too much data for a single Smartsheet sheet to hold all the data. Is there a way to pull data from a Smartsheet DataTable into Tableau? So far the methods considered are: Smartsheet ODBC connector Not seeing the DataTable as…

API & Developers

Discussion List