API & Developers

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

Problem Uploading Data using API
I am able to pull the data from reports and sheets with little trouble, however I am currently trying to pull the data from a report and then upload it to a sheet. I pull the report and save it as a dataframe with no trouble, however when uploading to the sheet, I keep getting errors. I simplified things by just trying to…
"Search Everything" API request always response with 'totalCount' limited to 100
Hello, Is there a limit to the total number of search results to 100? For the example, the GET request to URL: https://api.smartsheet.com/2.0/search/sheets/{sheetId}?query=stuff always response with "totalCount": 100 even though I know there are more than that. Is there a way to increase the search results beyond 100?…
Bridge - Extracting a filtered array
Hello, I have a multi-tier SCC solution and I want to update a dropdown column in projects intake sheet with only the names of programs that have already been provisioned. Here is my report: Looks, great in Bridge when I use the Smartsheet: Get Report element, but the whole thing falls apart in the Extract Field From Array…
Dashboard widget grouping
I have a large smartsheet with product codes as primary key and associated info with each code. Since you cannot show data wider than the width of the dashboard, I have to create multiple reports to show data for one code. Firstly, is there a way to link the reports so they show different info for the same code and second,…
Recent changes made to the C# sdk (version 3.x) are causing some file upload issues.
Hi, The changes made to the official c# sdk recently are creating some issues while uploading files, corrupting them. I bielive the DefaultHttpClient is in cause (on my solution i made change to override the method Resquest1 to revert it to its previous behaviour). Could you have a look at the issue :…
Can I set Series of SMS (Drip SMS) for Smartsheet reminders?
I'm curious about using a series of text messages (Drip SMS) for reminders in Smartsheet. Has anyone successfully implemented this feature?
Adding Predecessor That Includes Lag via API
I'm able to add predecessors to rows via API (PUT and URI https://api.smartsheet.com/2.0/sheets/{sheet ID}/rows), but am unable to add a lag value to the objectValue. I referenced: Is there any way to add or update the Predecessors column value by C# or Rest Api? — Smartsheet Community to build this. Kudos to @Genevieve P.…
Automatize the creation of new project sheet and synch them to the project master
Hello everybody, as many other users, I organised my project in a master file, containing one row for each project, and several sheets for each single project, where the first row is a replica of the corresponding master file row, and the rest is dedicated to hierarchically organised tasks. I have a business account, and I…
QR Code Asset Management & Tracking
All - I'm looking for a rather complex solution and have had no luck searching for existing integrations and/or partners. Hoping the community has some good input here. What I'm ultimately looking for is to be able to automatically produce a QR code per row and then scan said QR code from a printed sticker attached to a…
Change my gmail account to work email
I have a paid plan on my gmail account and i need to change it to my work email in order to integrate in with MS365

Popular Tags

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

Trending in API & Developers

API to modify FORM "Label"
I have to update 250 form labels on a single form. Is there ANY way to do this automatically? I am dreading doing this manually :) There doesn't appear to be any API functionality for forms according to the documentation. Am I just overlooking something or is this not possible? Thanks!
Bridge: How to automatically add users to "Licensed Users Group" or "Other Users Group"?
We're trying to maintain a "group" of users in our Smartsheet instance who are Licensed, so that we can use Smartsheet to share Licensed-user dashboards with them. And if they're not licensed, they would go into "Other Users Group" for a dashboard highlighting features available to free users. Currently, we intermittently…
API - Limit User Access to one report
I'm new to using Smartsheet and currently have access to one report. I’d like to access this report via the API, and I’m reaching out to check if it’s possible to get the necessary API access. However, I’ve heard from someone that API access can’t be restricted to a single report. I’ve looked through the Smartsheet…

API & Developers

Discussion List

Categories

Popular Tags