API & Developers

Archives for April 2021

API - Report Filters in API query
Hi, Does anyone know if there is a way to pull via the API, the Filters, Group and Summarize parameters of a report? I am wanting to store this info somewhere safe in the event of a data loss event occurring and needing to rebuild the many reports we have in the tool today. I can't seem to find any parameters on the…
Is there anyway to autonomously get a sheet's forms?
Hello, I've been working with the Smartsheet API to automate many different things but does anyone know if there is a way to autonomously get the forms that exist in a sheet? I need to dynamically grab the link to a specific form for many sheets in an ongoing project. Thanks!
[New Feature Request] Attach all Files to a Row from an Existing Row from the Same Smartsheet
Hello. I use the C#.Net SDK and Smartsheet API to develop Smartsheet scripts for my company. I was wondering if the Smartsheet Development Team would add a way for Smartsheet API to attach all attachment files to a row from an existing row from the same Smartsheet. Currently, the…
Is there an API to get the Published Items report?
I know you can export the Published Items report from Admin Center -> User Management -> More Actions -> Published Items. But is there an API we can use so we can automatically / programmatically get this report?
For how much time does the API access token valid.
I'm using SmartSheet APIs to automate some tasks in my SmartSheet. To do that I'm calling SmartSheet API calls within my API. Currently, for the authentication, I have generated an API access token via the following UI in the SmartSheet. I want to know how much time this token valid?
Unable to Attach File to Row
curl https://api.smartsheet.com/2.0/sheets/{sheetId}/rows/{rowId}/attachments \ -H "Authorization: Bearer xxxx" \ -H "Content-Type: application/msword" \ -H 'Content-Disposition: attachment; filename="ProgressReport.docx"' \ -H "Content-Length: FILE_SIZE" \ -X POST \ --data-binary @ProgressReport.docx Using Above API to…
Does Smartsheet Form have any APIs?
Hi, I'm trying to automate the form submission process for my team, I saw form submission seems to be calling https://forms.smartsheet.com/api/submit, just wondering if we have any APIs open for this like the api.smartsheet.com ones? Thanks
How to expand options : [Array] to show picklist values ?
I am using Node.js API calls to get the columns displayed in my terminal. Few of my columns are of types : Contact_List and Pick_List. I want the CLI to show me the options which are present in the dropdown in these columns. I want to expand options: [Array] { index: 4, title: 'New Picklist Column 1', type: 'PICKLIST',…
3rd Party Apps
How can I let my application know who is accessing the application before it has an actual Smartsheet access token? If I understand correctly the first time the user uses the authorize link it generates the token and we can use that initially. The second time the user accesses the web app they are going through the direct…
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…

Trending in API & Developers

Bridge Search for a value - What are the modules to use?
I have a use case as follows: When a row changes or is added in the source sheet, I want to search for the row's column named "Key" against a column also named "Key" on a target sheet. If found I want to update a column named "History" in the target sheet that matches the source sheet's key. I also want to write the word…
Smartsheet ODBC, Tableau, and DataTable
Hello, We are trying to connect Smartsheet data in a Smartsheet DataTable to Tableau. We have too much data for a single Smartsheet sheet to hold all the data. Is there a way to pull data from a Smartsheet DataTable into Tableau? So far the methods considered are: Smartsheet ODBC connector Not seeing the DataTable as…
Bridge - Error with POST call to API - Invalid Body
I'm trying to make a post call to an API using the "Call API" action within Bridge. Unfortunately, every time I try this action, it fails with an "Invalid Payload" response. I've tested the payload in Postman, and it seems to be working correctly. The API I'm using is a "POST" to a Slack Webhook. (It will automatically…

API & Developers

Discussion List