Product questions?
Ask it here! The community's got your back.

API & Developers

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

Using Node.js to populate comments
Hi all. Not sure where to start :-( I have a spreadsheet in which we store evidence requirements for audits we do. A control may require evidence of a policy document, plus evidence that the control is actually working (screen shot, register, etc.), and explaining what's needed will make it easier for the customers to fill…
Debugging Webforms and webhooks
My client has been complaining data some registration data has been lost that was supposed to be sent over one of my webforms. The problem is that I cannot reproduce the problem and the data is inserted to Smartsheet as expected. Is there a possibility to debug webforms as well webhooks.
Will Smartsheets Webhooks introduce more authentication methods for callbacks? Or any workarounds?
The Smartsheets webhooks are great ideas, but without even basic authentication they require an exposed endpoint to use since the only way to authenticate is by receiving and examining the payload. Having an exposed endpoint is not an option for most enterprise solutions, where at the very least Basic Auth is necessary.…
Can I force a specific row to copy to a sheet if the automation failed?
I have a formula that triggers a row to copy over if a certain condition is met; the submission for this particular row was not met and the cell that was wrong had to be updated. Our team has updated this cell; however, the row did not copy to the next sheet. Can I force just this row's automation to have it flow to the…
API search/get multiple rows in a sheet
I need some help formulating an API call to retrieve multiple rows of data in a sheet that have a specific key word. I can successfully use the /2.0/search/sheets/xxxxxx?query="A2" query to get a list of rows however I don't know how to continue this query to then pull all the rows of data that match the query.
Python get_columns response.
I am trying to find specific columns through the python api. Running something like listColumns = smartAPI.Sheets.get_columns(83053825###, include_all=True) gives me the object and not the Field Name. [<smartsheet.models.column.Column object at 0x000001FBBBD26C18>, <smartsheet.models.column.Column object at…
How to implement SCIM APIs?
Hi, I have a Smartsheet Enterprise account with System Administrator permissions. I'm trying to develop an SDK that will fetch the Users, Groups, and Roles/Membership related information from the Smarsheet SCIM APIs. I've got the SCIM base URL(https://scim.smartsheet.com/v2 ) from the…
Webhook's repeating same events
Hi, I'm creating a row in smartsheet and after I save it , the webhook is being triggered multiple times and that too for the same events . I have made sure I return http status OK from my callback. The same is happening when I attach any attachments , same events are being fired & my webhook callbacks my post api…
How to access SCIM APIs?
I'm trying to access the API(https://scim.smartsheet.com/v2/users) by using the Token generated from an Enterprise account with system admin privileges. But, I'm getting an error response as shown below: { "schemas": [ "urn:ietf:params:scim:api:messages:2.0:Error" ], "detail": "This feature is not enabled for your…
Need to change Access Control of Published Items though api
In Smartsheet I have downloaded Published Items list from user management. Using this list I need to change the Access control (Public/Organization) value through api. Please help. Thanks

Popular Tags

Trending in API & Developers

How to obtain sheet "created by" in Bridge for a child workflow
How can I use Bridge API Call OR Get Sheet OR another element to obtain the "Created By" metadata for use in a workflow? I see createdBy in the sheets summary in the SDK: sheetSummary - fields But I don't see it in the output of past runs of either the API Call or the Get Sheet element in Bridge. I see createdDate but not…
How and/or when does a CellLink Object 'status' get updated to 'BROKEN'?
Across our project portfolio, each project has a main project sheet. This sheet has rows added & deleted as tasks are added or canceled from a project. Individual departments have department specific tracking sheets which mirrors the task list in the in main project sheet and certain key values are linked to the main…
URL String - Any common thread between Sheet and Form?
Hi there, I came across a circumstance where someone had a link to the form but forgot where the sheet lives. Is there anything within the URL of the form that can bring you to just the sheet? I tried cutting out the 'form' from the URL, but unsuccessful. TYIA!

API & Developers

Discussion List

Categories

Popular Tags