API & Developers

Archives for November 2020

Discussion List

  • Smartsheet API Error using Python
    In API & Developers
    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…
    Unanswered
    5 0
    Question 5 views 0 comments Started by Adiele Ejiofor API & Developers
  • Powerbi and Youtube Analytics
    In API & Developers
    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…
    Unanswered
    10 0
    Question 10 views 0 comments Started by Ven Kat API & Developers
  • Python : Unable to import 'smartsheet' pylint(import-error) [1, 1]
    In API & Developers
    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]…
    Answered - Pending Review
    14 1
    Answered - Pending Review 14 views 1 comment Most recent by Genevieve P API & Developers
  • Bad Gateway Error when automating Office Forms API to Smartsheet
    In API & Developers
    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 smartshe…
    Answered - Pending Review
    13 1
    Answered - Pending Review 13 views 1 comment Most recent by Sean Morgan API & Developers
  • File Attachment to Row
    In API & Developers
    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-…
    Answered - Pending Review
    15 3
    Answered - Pending Review 15 views 3 comments Most recent by evaluation API & Developers
  • How to find folder id for existing smartsheet
    In API & Developers
    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…
    Answered - Pending Review
    20 1
    Answered - Pending Review 20 views 1 comment Most recent by Genevieve P API & Developers
  • Updating a cell in a column formula is not supported. columnId
    In API & Developers
    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 suppo…
    Answered - Pending Review
    26 2
    Answered - Pending Review 26 views 2 comments Most recent by Genevieve P API & Developers
  • Pushing a Tableau User Name into Form-Fill through the URL
    In API & Developers
    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 C…
    Answered - Pending Review
    10 1
    Answered - Pending Review 10 views 1 comment Most recent by Andrée Starå API & Developers
  • Sheet Summary Report From Smartsheet Into Appsheet
    In API & Developers
    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…
    Accepted
    17 1
    Accepted Answer 17 views 1 comment Most recent by Chris Mondeau API & Developers
  • Does the unique row id have a check digit?
    In API & Developers
    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 Exce…
    Accepted
    21 1
    Accepted Answer 21 views 1 comment Most recent by Martin Bell API & Developers