API & Developers

Archives for August 2021

ENHANCEMENT REQUEST!!
I created a scheduling system using a grid/form/dashboard. After implementation I found out that forms do not have any permission settings. Ex. I had a grid/form that I only want 10 people to access, the grid is restricted but everyone can access and submit using the form. For this project to be successful, I either need…
Direct personalised and specific help to customise my project setup ?
Hi , is there a list of experts or service / hire , who may be able to help me with the detail and specific project setup and reporting and cost management ? i've got all the info but having trouble getting it all humming with costs, dependencies, reporting and dashboards want to try to link with xero once somebody helps…
Reduce the amount of info in the webhook notification
Hi, Lets say you have a sheet with lots of formula columns and lots of rows. The webhook notification seems to include all the rows in the sheets and all the cells in all the formula columns for all the rows. This happens even if you just changed one cell in one row and saved the sheet. Is there a way to do any of the…
Smartsheet and QuickBooks Integration - "Amount is not equal" Error
Hi, I'm trying to integrate Smartsheet and QuickBooks Online using Zapier. I'm having two issues: When I use the trigger "When a row is updated" it looks to see any time the row is updated. I only want to send to quickbooks when a specific CELL in that row is updated. Is there a way to do that? (The workaround for this…
ArcGIS Dashboard
Has anyone used the Live Data Connector to connect data from Smart Sheets to ArcGIS Dashboard or to Excel then Dashboard?
Bulk create Sheet from template through smartsheet API
Hello, I've currently been facing an issue regarding the Smartsheet API, a quick breakdown of what i'm trying to do, I require to create 900+ sheets that will all have the same layout (a template is available for that) After skimming through the API discovered the feature of creating sheets based on a template, problem is,…
How to code Python in Zapier without using Smartsheet python SDK
Using Smartsheet Python SDK, I'm running the following code to access Smartsheet to: Get customer list from "Customer name" column of a Customer sheet Update Picklist of "Customer name" column with the customer list get from 1. import smartsheet # Initialize Smartsheet client smartsheet_client = smartsheet.Smartsheet(my…
Please update Python documentation for RowObject toTop toBottom
I was following the python sdk, and able to update rows on a sheet successfully. Then I went to add_rows, which was an easy adaptation. However, I started getting the error "Invalid row location: You must use at least 1 location specifier". Which I thought was odd, because the sdk example, and the python source code on…
Sort by Date
When a name enters the SmartSheet from a API form the name does not enter into the top of the SmartSheet like they do when entered from a UI form. They enter into the bottom. I really need away to have the newest date on top matter if they were added from a API form or a UI form. Any guidance you can give me will be…
Would i be able to share a folder?
I manage a project with several sub-projects. Is there a a way to share this?

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 のご利用を開始するために必要なすべてを網羅しています。
Smartsheet In Person User Group | Raleigh
Connect with fellow Smartsheet mobilizers and advocates! Join us at our in person user group in Raleigh, NC on Jan. 15. This is a great opportunity to discover how other local users are optimizing their use of Smartsheet. *Get inspired: We'll learn from local users, who will share success stories on how they use Smartsheet…

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

Trending in API & Developers

FolderResources.GetFolderChildren isn't returning the createdAt and modifiedAt for sheets
The new version of the api (FolderResources.GetFolderChildren) isn't returning correctly the createdAt and modifiedAt fields for sheets. As an examplle the following call isn't returing the fields correctly : SmartsheetClient.FolderResources.GetFolderChildren(9999, null, null, null, null, null, null); Can someone raise…
Reasons for error code 1008 in webhook subscription request
Hi, Zapier Integrations team here. We are experiencing users reporting being unable to set up a webhook subscription to Smartsheet when a POST request is made to https://api.smartsheet.com/2.0/webhooks Response received { "errorCode": 1008, "message": "Unable to parse request. The following error occurred: Field 'name'…
Smartsheet API List Workspace Children
Hello, I'm trying to use the Smartsheet API to get a list of sheets in a workspace using: https://api.smartsheet.com/2.0/workspaces/{workspaceId}/ However, my workspaces are organized with folders and this only returns the top level folder and nothing else. How can I have this return every child object in the workspace no…

API & Developers

Discussion List