-
URGENT BUG : Endpoint https://api.smartsheet.com/2.0/users/sheets giving an incorrect response
Hi Team, @Genevieve P. We have been using this endpoint to fetch the sheets, this used to return the owner that was needed to be used in subsequent api calls with 'Assume-user'. Somehow the above api call is returning the owner field as empty and the ownerId as a 0. Therefore, all my processes are failing. Can someone…
-
How to determine the workspace ID & Name and folder name if I only have the sheetID?
Hi, I am using the Smartsheet API for Python. I can determine the workspace names and IDs. I can determine the Sheet name and ID. However, I need to know which workspace (ID & Name) and under which folder of that workspace a specific sheet (per sheetID) resides. How do I do that using python, please? Thank you.
-
Resource Management API - Users
Hi Every one, I am wondering if anyone faced this issue before. I am trying to make an API call using the users API as following. The issue that I don't get tags in the response as mentioned in the API documentation: I get ''tags' in the response only when I pass it as a sting as following: Below is a sample response after…
-
A way to place the Row ID (for APIs) into a cell value with formula?
For clarification, the ID I am after here is the Row ID you can view in the properties of a row. I'd like to be able to do something like have someone export a sheet and send it to me for processing, and have a pointer directly back to which records there might need a resulting update, to be done via automation, that would…
-
Excel VBA Examples
Does anyone have any examples of using Excel VBA to run api commands? I had some routines that used CreateObject("WinHttp.WinHttpRequest.5.1") with 1.1 but these don't work anymore, I get error occurred in the secure channel support. I am trying to update smartsheet rows from macros within excel and word which are used to…
-
Auto user provisioning
Can someone explain to me what will happen if I enable auto provisioning in Entra with our groups that are already setup in Azure AD? We already have users using smartsheets. They have had their Azure accounts given groups that coincide with the Smartsheets groups, but I'm just wondering if a user was not granted the group…
-
Issue with API Call to Update Rows in Smartsheet Using Custom Integration Tool
Hello Smartsheet Community, I am encountering a persistent issue when attempting to update rows using a custom integration tool that interacts with the Smartsheet API. Despite several attempts and adjustments, the API calls are not being processed successfully, and I'm consistently receiving parsing errors. Details of the…
-
How do you standardize addresses in Smartsheet?
Has anyone found a way to validate their address fields in Smartsheet? We are currently using a Smartsheet form to collect business license data and would like to integrate our data to ArcGIS to map the business locations. Currently, we are manually updating all of the citizen-submitted addresses which is a huge time suck.…
-
Loading data from excel into Smartsheet API to an existing sheet
I have data in Excel which I have loaded and cleaned in Python and I want to load the same into Smartsheet through API. This data goes into the existing sheet in Smartsheet, which is typically adding new data into the sheet. I have gone through few articles about "Add Rows" but it doesn't explain about loading data with…
-
C# API access to row attachments
Greetings, I have been able to use the Smartsheet C# API to access sheet and cell data without issues. I added an attachment to a row and attempted to get information about it via the API: // Load the entire sheet Sheet sheet = smartsheet.SheetResources.GetSheet(selectedSheetID, null, null, null, null, null, null, null);…