-
Connecting to Smartsheet from Oracle Analytics Desktop 12c
Hello, Has anyone successfully connected to Smartsheet from Oracle Analytics Desktop 12c? I have installed the Smartsheet live data connector, created a 64 bit ODBC Connection (DSN), tested from within Excel. It works. Now I want to connect directly from a data visualization tool (Oracle's Analytics Desktop 12c) and I am…
-
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…
-
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…
