Product questions?
Ask it here! The community's got your back.

API & Developers

Connect with other developers from around the world and collaborate on ideas using the Smartsheet API.

SOURCE_SHEETS Report Inclusion not working?
Hello, We are trying to get the array of sheets using a GetReport with the SOURCE_SHEETS as part of the include and it always returns null. We are using the C# api. Is this a bug or are we doing something wrong? see code below: ReportInclusion[] include = new ReportInclusion[] { ReportInclusion.SOURCE_SHEETS }; Report…
Power Bi - How do i get the data held (comments) in Conversations into Power Bi?
I have successfully added Smartsheet to Power BI and its GREAT! How do i get the data held (comments) in Conversations into Power Bi?
Sorting Rows
Hi, I am working on something that requires to sort the Smartsheet based on a column. The type of column is 'TEXT_NUMBER'. 1/0/12 1/0/1 1/0/14 1/0/3 1/0/11 After sorting the smartsheet with the above column the result is this 1/0/1 1/0/11 1/0/12 1/0/14 1/0/3 I am using python sdk in my project, but it doesn't sort all the…
How to update value of a cell that have a Hyperlink by Smartsheeet API C# SDK?
We have to update value of a smartsheet Cell. This Cell contains Hyperlink to a different sheet. Hyperlink URL is assigned. We want to update this cell value by Smartsheet API C# SDK.
Accessing sheets within workspaces using the Smartsheet API
Hi! I am attempting to pull sheets from inside one of my workspaces using the api, but have run into issues passing both the workspace id and sheet id to GET in sequence. For example, I am able to use GET /workspaces/{workspaceid}to retrieve the workspace object and its contents, but how would I go about using a GET…
Combined Charts and Dashboard filter/Slicer
Hi, Anyone know if the Combined Charts and Dashboard slicer like in excel will be included on the Dashboard update on January 2021? Anyone know or has the scope of the updates? Anyone knows an alternative chart for line & bar combined chart?
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…

Popular Tags

Trending in API & Developers

URL String - Any common thread between Sheet and Form?
Hi there, I came across a circumstance where someone had a link to the form but forgot where the sheet lives. Is there anything within the URL of the form that can bring you to just the sheet? I tried cutting out the 'form' from the URL, but unsuccessful. TYIA!
Newly Received 404 with Error Code 1006 on DELETE sheets/{sheetId}/rows API with ignoreRowsNotFound
Hey there, Was a recent breaking change pushed to the smartsheets API? Previously, when calling the DELETE Request to the rows endpoint, I would receive a 200 with a valid response. Now, when requesting a valid sheet, with a valid row, I am unable to get a 200 response and am only receiving 404 with error code 1006 in…
When I Copy Workspace, Everything Copies Fine Except for CellLinking
Hi, Using the API documentation, I'm able to copy entire workspaces which has been great for scalability. I've been noticing that the only thing that doesn't work correctly out of all the sheets, reports, and sights, is the cellLinks in my sheet. In the instructions, you can tell it all the different things to pull in. I'm…

API & Developers

Discussion List

Categories

Popular Tags