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…

Trending in API & Developers

Bridge: Move select columns/attachments/comments to another sheet
Hello all! I'm looking to see if a Bridge workflow can be done with moving/copying select columns from one sheet to another BUT also bringing their attachments/comments over as well. I've made a workflow to copy select columns from a source sheet to a targeted sheet but never have the comments/attachment follow. I have a…
is it correct passing time frame as an object to resource management reports API?
Hello, When connecting to the report rows endpoint, I am receiving an error when using the timeframe as shown in the API documentation. "time_frame":{ "from": "2022-01-01", "to":"2022-12-31"} Error message received: {'message': 'to is not a valid time_frame'} I also tried to pass the 'from' and 'to' as a separate parameter…
Transfer attachments between sheets
Is there a feature available to set up a workflow rule that triggers when a new attachment is added to the source sheet, the rule would then automate the transfer of that attachment to another sheet?

API & Developers

Discussion List