API & Developers

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

Dynamic String URL with automatic submit
Hello all, I'm an instructional designer that uses Smartsheet for intake, project management, time management, and just all kinds of things. Recently I've used smartsheet to create leaderboards within eLearning lessons to show real time to the learners how they placed with points or time on interactions. However, they…
Sheet API - Identify if sheet is created from Project template
Hi, Is there any way we can identify if a sheet has been created using Project template (default pre-existing Project template on Smartsheet) or not using APIs? Thanks, Aditya
API Updating Row Format
I was trying to find some documentation on the format string and came across this forum. https://community.smartsheet.com/discussion/13111/update-row-background-with-api I'm trying to update the format of an entire row ( mainly just trying to update the background color of an existing row ). In the forum above it says to…
Attach a file to a Row
Hello, I am unsure what this is and how to get it in order to attach a file to a row in Smartsheet. Can someone please help? Examples would be great. Thank you!
Long-working API requests now responding with 500 "Unexpected Error (ExtAuthN)"...
API requests like the following (that have been working flawlessly for months)… GET /2.0/sheets/542002634510212?level=2&include=objectValue" are suddenly responding with 500 errors and the message "Unexpected Error (ExtAuthN)". Status page does not show an issue. Can you help debug?
Getting the Group ID for adding a user to a group in Group Management through API
I am wanting to add an email to a group using the API 2.0 but do not know how to get the group number. I thought it would be the number in the URL when viewing the groups, as in: https://admin.smartsheet.com/manage/groups/1234567 (yes, there are only 7 numbers) I am using the following example from API documentation:…
Download row level attachments through API
Hi @everyone I am trying to download Row level attachments through API But failed after trying different methods If any one has a solution, please help here
Anyone has a working Alteryx Output macro?
Just have a simple use case of overwriting an entire sheet with latest data on a daily basis, all the existing rows need to be deleted and new rows added. Column schema is not going to change
Using Copy Sheet API to copy column data and not formulas ?
I am trying to use the Copy Sheet API call to take a snapshot and archive on a weekly basis what has been entered into a source sheet. The source sheet has many formulas but I only want the data copied over. So far the source sheet is getting cloned over with formulas. I cannot have the copied formulas in the target sheet…
Saving files attached to Smartsheet rows out to Sharepoint folder
What is the easiest way to take files attached to each row in a Smartsheet and save those files out to a sharepoint folder? I know you can download them all and then go to SP and attach them, but surely there exists an automated way to move the files without ever personally touching them. Bonus if I can do it when a…

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

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 ?
Getting Blank Rows While Inserting Data directly using Python
Hi Guys I have created a code which will push the latest ticket from ServiceNow Platform into Smartsheet using the Smartsheet API. I am trying to use the POST method to push the row to Smartsheet but due to some reasons it is not getting inserted even if in the activity log it keeps showing as row inserted. When I tried to…

API & Developers

Discussion List

Categories

Popular Tags