-
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…
-
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…
-
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
-
Power Automate to Smartsheet - error on checkbox value
Hi all! I am using Power Automate to insert a row into a sheet. The sheet contains a checkbox field ( I have removed the 'Restrict to checkbox use only'). Upon insert I get this error: The value for cell in column 8850556387125124, True, did not conform to the strict requirements for type CHECKBOX. Am I missing something?…
-
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…
-
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…