API & Developers

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

Harvest (time tracking app) +Smartsheet integration
Hello, Wondering if this has been solved yet? We are looking to integrate Harvest and Smartsheet to run reports on actuals vx. budgeted time. Has anyone created this integration? if so, how? thanks
Workday.com & Smartsheet Connection for moving data
Any thoughts on what the best path forward be to build a connection between workday.com and smartsheet? Currently stuck evaluating between using Bridge or Smartsheet API/Workday API. We would like to be able to select specific line detail to be sent to workday for the req to check process and bring the requisition number,…
Dashboard Search Functions
Is there a Search widget within Dashboard that we can create? Similar to say tracking of a delivery parcel. What I want to create is a Dashboard that only shows certain information when a client input a Keyword or reference number then the Dashboard will show all the information that is linked to that Reference number or…
How to I create a sheet that track disbursement payments and account balances
Can someone suggest a template that I can use to track construction payments to subcontractors and calculate the total amount paid and remaining balances in subcontractors' accounts? After this, I would like to create an intake form for accepting invoices and provide subcontractors with limited access to their account…
Leading zeros dropped on Python SDK add_rows
We are using the smartsheet-python-sdk to insert rows into SmartSheets. For almost two years we have had this script running with no issue, but in the last week, SmartSheets has started to trim the leading zeros on fields that are all numeric. Nothing has changed in our sheet or in our script. Are others having this issue?…
Importing or updating one grid from another in Smartsheet
Hi, I need 2 sheet talking to each other and help update one sheet from another as per preference. Any help is appreciated, i tried Data Shuttle but it is not giving me option of Smartsheet grid?
Why is permalink not included in response?
I'm hitting the Smartsheet API with: METHOD: POST URL: https://api.smartsheet.com/2.0/sheets/12345/rows?include=rowPermalink REQUEST BODY: [ { "cells": [ { "columnId": 11111, "value": "Random Text" }, { "columnId": 22222, "value": 1 } ] } ] I get back a success response that includes an array of row objects. The…
How to map columns and rows of a json file to get the values from a smartsheet API request
Hi Everyone, I'm new to work on the Smartsheet integration using API. I have a request to load the data from the Smartsheet to a database table using Azure Data Factory. Through Smartsheet API connection I could able to read the data in a json format. To load it a database table I have to map the columns and rows so that I…
syncing Google Calendar>Google Sheets>Smartsheet_API errors_using Apps Script
Hi Everyone Does anyone have a procedure or a code I can follow to have Google Apps Script parse data in google sheets over to smartsheet? I have been using this code below but the data still isn't appearing in smartsheet. I know I could be using zapier but I would prefer to use Apps Script so everything is dedicated on…
Barcode Scanner Options
Hi Hoping someone will be able to help. I’m looking into options for using the barcode scanner to help automate our production schedule. Currently we are using SmartSheets for all orders and manually ticking stages off (Printed, Staged, Built, QC, Shipped etc). I have added barcodes to orders so the team can scan them…

Popular Tags

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

Trending in API & Developers

API calls succeed but data requires manual File > Save to persist
API returns HTTP 200 SUCCESS Activity log shows "Rows Inserted" No data appears in sheet until manual File > Save. Data can be manually added (by a human) to the same sheet, but the data is not persistent until after File > Save. Browser correctly warns that leaving the page will lose the data. Activity log does not show…
rowNumber attribute for Row objects not accessible
When accessing the row objects of a Smartsheet, I can get some attributes, like row.id and row.expanded without issue, but when I try row.rowNumber it returns an AttributeError, saying that that attribute does not exist. By my understanding of the row object from the get_row response (Get Row), the attributes 'id',…
How am I causing this "Unable to parse request" error?
I'll show a successful request, a failed request, and the error I get. For context, 1111 is my sheet ID, 2222 is a row, 3333 is a text column, and 4444 is the special "Start Date" column that Smartsheet creates. Successful request PUT https://api.smartsheet.com/2.0/sheets/1111/rows/ [ { "id": 2222, "cells": [ { "columnId":…

API & Developers

Discussion List

Categories

Popular Tags