-
Update linkInFromCell via API results in error 4000
Hi, i'm requesting the API via axios.js with PUT https://api.smartsheet.com/2.0/sheets/{sheetId}/rows to update two cells of one row with the following data body: { "id": 1234 "cells": [ { "columnId": 1234, "value": null, "linkInFromCell": { "sheetId": 1234, "columnId": 1234, "rowId": 1234 }, { "columnId": 1234, "value":…
-
Why do some reports/sheets return 1006 "Not Found" when trying to access?
I am making the simple "sheets/[sheet id]" and "reports/[report id]" calls and some of them return 1006 "not found". I have access to these sheets/reports from the Smartsheet UI, and obtain the ID through properties as before. There does not seem to be any pattern to the ones which return 1006. Even the ones I do manage to…
-
Error code 5570 when sending e-mail notification
I have a trial account with Smartsheet. I am using smartsheet API with curl to create/update few sheets. The requirement is to email these sheets at EOD to a couple of users. However, receiving error code 5570, 'you have exceeded maximum number of e-mails that your account can send'. The limitations document states that…
-
Getting 204 with Smartsheets put request on Postman but 400 in .NET Core Web API
I am testing the same data in postman verses a .NET Core Web API project, however, one returns fine when content is being updated and another (.NET Core) returns 400. Any ideas on why this may be? It's the same data structures, and even same data.
-
Do refresh token expire ?
In Smartsheet, the refresh token generated using the OAuth 2.0 flow , do they expire ? If yes, what's the expiry time ? (I'm asking for refresh token , not access token).
-
Is it possible to create a Smartsheet that spits out an image and data after receiving information?
Is it possible to create a Smartsheet that spits out an image and data after receiving information? I would like to create a Smartsheet that allows someone to enter in a product name and also a URL (two separate items). All entries for product name would be inputted into "column a" and all URL entries would be inputted…
-
Developer needed....
I'm looking for a developer to help a business with a business / operations set up and on going support. We currently use Smartsheet and want to extend our use of it - manage projects, flow, contact with clients, contact with consultants.
-
Integration with Oracle Primavera P6
Has anyone had any luck with using API's or exporting/importing Smartsheet scheduling projects to Oracle Primavera P6? We are using the cloud version of P6 and both it and Smartsheet technically have open API's so it should be possible. However, rather than recreate the wheel, I'm wondering if someone has already worked…
-
Mass file transfer from One Drive folders to Smartsheet Attachments
Hello, I'm wondering if this is possible through the One Drive connector, any automation tool, or API. I have roughly ~1,000 folders in OneDrive, and the folders are named by client ID. Each client has 1 row in a smartsheet tracker, and the primary column is the client ID. The goal is to have all of the attachments in each…
-
Automatic creation of sheets
Hi, I'm wondering if there is a way to automatically create a tracker from a template when a row is added to a master sheet? So, I'd have a form add rows to a master sheet, then I'd like that to automatically start an individual tracker that I've setup as a template. And can those trackers be automatically saved in another…