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

Smartsheet IP Addresses for Network Restrictions
Hi! I am using Smartsheet webhooks to stream events of updates on items Along with hmac authorization, I also want to restrict network access so that requests coming from Smartsheet server will be catered, and all other go unauthorized can I get the set of IPs of Smartsheet?
Reseting a row parentId
Hi, For some needs, i would like to reset the parentId value of a given row. what value should i be using to force the parentId to be reset ? I tried :0; null; "0"; "null" and none of them made any positive result :
How to update picklist column
Hi, Currently I have a few columns which contain individual list items, but when I send an update through the API they appear as a single string Is there a specific way I need to be sending list items so that each item appears individually?

API & Developers

Discussion List