API & Developers

Archives for April 2022

Why is the row id in the webhook data different to the smartsheet row id?
Heres my webhook code $challenge = file_get_contents('php://input'); $result = json_decode($challenge); $Response = $result->challenge; $WebHookId = $result->webhookId; header("Authorization: Bearer".SS_TOKEN); header('Smartsheet-Hook-Response:'.$Response); http_response_code(200); $events = $result->events;…
Access to Event Reporting API other then Enterprise plan
Hi, As Event Reporting API(https://api.smartsheet.com/2.0/events?since=2022-01-10T00:00:00Z) is available via Enterprise plan only, Is there any way we can access this API with free trial or Developer account. We require the access of this API for development purpose only. So Please let us know if there is another way to…
How can I access the Smartsheet API from Excel power query?
Hi, I have ODBC connector for Excel but need to use the API in this instance. I'd like to create an API connection that can be run by anyone with access to the Excel document. I have a secure token but am unable to configure the parameters in Power Query so that the Smartsheet API is happy and provides access. I currently…
List Discussions function limited characters
Hello, I am trying to pull all discussion and comments associated with a sheet ID. I was able to pull using the API through python as shown below. However the comments came in with only limited characters, in other words I can only see the first 100 characters. Please advice PYTHON CODE BELOW " import smartsheet import…
Event Reporting API
Hi team, I have a question on smartsheet Event Reporting API. As event API is available as an Add on feature on Enterprise Plan only, So If a customer has an Enterprise plan and we use the API will it also bring in activity for any users who are using a Business plan for example? Or will it only bring in users from the…
need help on Attachments API
How can i pull attachments added to row in smartsheet from third party system using API without using attachment id
need help on Comments API
I want to pull recently added comments to row in smartsheet from servicenow using API. But existing api to fetch comments need comment id , as third party system i dont comment id to pull . I would like to know how to get recently added comments to row using api without using comments id
Smartsheet Admin license/Creating an App
I have been tasked with creating an app using the Smartsheet API/SDK. Our company only has a fixed number of licenses and does not plan on purchasing any more so I have to get an admin license transferred to me. I plan on creating an app in developer tools and storing the client id/secret in Azure Vault. Should I have the…
Smartsheet pulling data from a API
Asking the community to see if you all have found a solution that smartsheet currently does not have one for. We are building an API for ourselves and our 3rd Party Partners to have access to a single source of data that smartsheets and other products would pull from. However, smartsheet does not have a solution to PULL…
Do Smartsheet Support an API to fetch header names of a template?
I want to make an API call to fetch the column names and respective datatypes of a user-created-templates.

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