API & Developers
Archives for November 2020
Discussion List
-
Smartsheet API Error using PythonIn API & DevelopersHello 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…
-
Powerbi and Youtube AnalyticsIn API & DevelopersI 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…
-
Python : Unable to import 'smartsheet' pylint(import-error) [1, 1]In API & DevelopersI 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]…
-
Bad Gateway Error when automating Office Forms API to SmartsheetIn API & DevelopersSolved: 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 smartshe…
-
File Attachment to RowIn API & DevelopersHi 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-…
-
How to find folder id for existing smartsheetIn API & DevelopersAll, 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…
-
Updating a cell in a column formula is not supported. columnIdIn API & DevelopersHi 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 suppo…
-
Pushing a Tableau User Name into Form-Fill through the URLIn API & DevelopersI 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 C…
-
Sheet Summary Report From Smartsheet Into AppsheetIn API & DevelopersGreetings, 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…
-
Does the unique row id have a check digit?In API & DevelopersI 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 Exce…