The Community Search page is currently unavailable. We are investigating this and hope to have a fix as soon as possible. Please use alternate search engines (e.g. Google) or navigate to your profile to find individual posts. Thank you!

API & Developers

Archives for July 2022

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…
How to use either Zapier of Make.com to automatically child rows
HI All Sorry im pretty new to the world of API's and have to use helper sites like make.com (integromat) Im trying to create a sales order system in Smartsheet and although I can create it with everything about an order being in one row it becomes very messy to actually use. I was hoping row hierarchy could help me bring…
Why HttpClientException is thrown from time to time while using Proxy?
Hi, When I'm using a proxy, I experience a bug that is not always reproducible: HttpClientException is thrown while calling ObtainNewToken from OAuthFlow. AutherizationResult parameter that is sent is always the same. Exception is thrown with message: "There was an issue connecting." Please help in finding a solution.…
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.…
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.
Sheet Access via API
I've looked through all of the documentation for the API but have been unable to find out if there was a way to see Collaborators and Permissions for each sheet. I had seen previous posts of people asking for this and had it recommended as a future feature. Is there an update on this? Was this done and I'm just missing the…
What is the proper syntax for using "Invoke-WebRequest" command with api.smartsheet.com?
Hello All, I'm using Windows Powershell to access and download smartsheet data via https://api.smartsheet.com. When using the curl command from dos prompt, the following works fine: curl https://api.smartsheet.com/2.0/sheets/{7517664106047364} -H "Authorization: Bearer *********************" -H "Accept:…
Getting last login information via API call
I have looked at the documentation for the API call but when I am hitting the users endpoint: https://api.smartsheet.com/2.0/users?include=lastLogin,source&includeAll=true it is not including the lastLogin information. If I hit: https://api.smartsheet.com/2.0/users?include=lastLogin then I will receive it for those users…
.net 6?
Hi, Any estimate on .net 6 for the api? Issue seems to be RestSharp and its last major update. Your code when pushed to new AWS .net 6 runtime fails: Void RestSharp.RestClient.set_FollowRedirects(Boolean) at SmartsheetBuilder().SetAccessToken(apiToken).Build() We are using smartsheet-csharp-sdk @ 2.126.0 Many thanks, Brian
Python API - How do I transfer a date-time value from a Pandas data frame to a new row?
Hi! This is my first question in the forum, so please let me know if I'm doing something wrong. I have some data in an excel csv file, and I have copied it into a Pandas data frame. One of the fields in the csv has this format: "3/17/2022 10:59:00 AM" and when transferred to the data frame it shows '3/17/2022 10:59'. So I…

NEW Smartsheet API Documentation - bookmark the updated link! https://developers.smartsheet.com

Trending in API & Developers

Issues with Excel from using Power Automate
We are trying to use Power Automate to pull in Excel attachments from email and put into One Drive, so we can then utilize Data Shuttle to pull in the data. For some reason it does not allow us to open the document, but it opens fine in the email. We have researched and have not found a fix for this issue. Does anyone have…
Smartsheet API- Add Image To Cell
I'm trying to write a python code with the API that will add an image to a cell but I continuously get this error message. I'm trying to use this endpoint: POST /sheets/{sheetId}/rows/{rowId}/columns/{columnId}/cellimages based on this: https://developers.smartsheet.com/api/smartsheet/openapi/cellimages/addimagetocell
API to modify FORM "Label"
I have to update 250 form labels on a single form. Is there ANY way to do this automatically? I am dreading doing this manually :) There doesn't appear to be any API functionality for forms according to the documentation. Am I just overlooking something or is this not possible? Thanks!

API & Developers

Discussion List