-
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…
