API & Developers

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

Using get_sheet using report_id vs sheet_id?
Hello! I am running into issues using report_ids when calling the get_sheet api function. Is there a different call I should be using here? Is there a different api command for reports vs standard sheets? It is running into typical 1006 error.
Issue: Smartsheet API Not Returning Data for Formula Columns in Sheets
I am experiencing an issue with the Smartsheet API where data from columns containing formulas are not being returned when querying a sheet. However, the same data is correctly displayed in the UI and can be accessed through reports via THE API. So I can access sheet data for formula columns via a report that points to…
API/Python SSL errors
Hello, my department has many python scripts that use the smartsheet API to download/upload from the site all of my smartsheet python (which was working perfectly before today) started giving the following errorurllib3.exceptions.MaxRetryError: HTTPSConnectionPool(host='api.smartsheet.com', port=443): Max retries exceeded…
Beware of "Input column index X is different from the first input column index X"
If you try to create columns in one bulk request, do not give each column its own unique index. All the columns need one common index (example: 1), which is the starting point (from left to right) at which the entire column set will be created. If you try to give each column its own numeric index (1, 2, 3) in the request…
Salesforce Connector Integration inquiry
This discussion was created from comments split from: Smartsheet IP Addresses for Network Restrictions.
Adding attachments to a row in Smartsheet using a HTTP action in Power Automate
I am trying to upload attachments to a Smartsheet row using the HTTP action in Power Automate. Is this possible? The URI is accurate (populated by dynamic content in the flow). I am receiving this error: "Multipart upload request was invalid. Please check your request headers and payload." Does anyone have advice? Thanks!…
Visual Studio Python Extension Smartsheet API Not Working
My Python environment is handling the Smartsheet API Token just fine. This is great news! But, my Visual Studio with Python extension is erroring out. Any suggestions?
Using Python to connect to READ, ADD, UPDATE, DELETE from Smartsheet
Dear Colleagues, I definitely need your help. I am using the example https://github.com/smartsheet-samples/python-read-write-sheet/blob/master/python-read-write-sheet.py to connect to Smartsheet, but the end is always a new Sheet ID with the data I retrieved from Excel. What I want to do: Connect to a specific Sheet ID;…
SQL Code
Hello Everyone Hope you're very well Could you please help about it.. What the step by step to use SQL code for create automation Smartsheet? Example use data for extraction in the SAP? I have the SQL code but I don't know the step to put in the Smartsheet or if is possible use this too in Smartsheet. Regard Adilson Mota…
Apostrophe ' is added before the number
Hi All, i got an issue with one of my column -column 1 - '235245 The number is automatically populated via API but its adds an apostrophe ' before the number. This is a primary number so i can't change the column type to text and again convert it to a number.

Popular Tags

Upcoming Events

Brandfolder Collaborator User Guide
Get ready to seamlessly upload and organize content within your Brandfolder! This on-demand session is designed to help you become a confident contributor and collaborator, ensuring your team has the right assets at the right time. What You’ll Learn: Maximize Features in the Asset Modal: Learn to navigate the asset modal,…
Brandfolder Admin User Training
Managing digital assets doesn’t have to be complicated. Join us for this two-part, on-demand webinar series designed to give Brandfolder administrators the confidence and skills to create smooth, efficient workflows. Whether you’re just getting started or ready to optimize your setup, these sessions will help you unlock…
Smartsheet Customer Success Onboarding (Japan)
Smartsheet カスタマーサクセスオンボーディングは、Smartsheet についての基本を学びたい方向けに毎週開催しているインストラクター主導のトレーニングコースです。ウェビナーは、始めるための基本、共同作業、およびさまざまな方法での作業の視覚化の基本など、Smartsheet のご利用を開始するために必要なすべてを網羅しています。

NEW Smartsheet API Documentation - bookmark the updated link! https://developers.smartsheet.com

Trending in API & Developers

List folder children
I am attempting to use the Python example for Listing Folder Children from the API Reference Docs. No matter what I do I get the following error message: {'errorCode': 1006, 'message': 'Not Found', 'refId': 'qgsta7'} =======CODE======= import requests import os from dotenv import load_dotenv from dotenv import…
I'm embarrassed to ask: How do you write an API
I have a report that beautifully aggregates data from 70+ sheets. I need one column from that report to populate a helper sheet that I have: Source Sheets > Report > Helper Sheet As the report grows with data, I want the helper sheet to grow with it without manual intervention. Ergo, the API question. Here's what I know…
Server Status ?
Hi, Since yesterday (dec 18), many calls to the api are failing or taking way longer than expected (2500seconds to read a sheet). What is the current server status and when should it be back to normal ?

API & Developers

Discussion List

Categories

Popular Tags