-
How do I determine the Root Domain for a Smartsheet Installation?
I have a customer who has several domains added to their Smartsheet installation, and I'm trying to determine how to idntify the original root domain, or the domain that was used when Smartsheet was originally implemented for the customer. Is there a way to identify the root domain? Thanks.
-
CORS interruption while fetching Smartsheet API
We want to use simple fetch to GET request the data from our Smartsheet instead to the Smartsheet JS SDK. The code snippet is as follows : This JS file has been linked to a HTML file which is being fired up on the browser using Live Server extension available in VsCode. But upon checking the console on the browser (all…
-
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.
-
Adding Sheet to Report using API
After some trouble with this command line string. I am getting a 1006 error even though I am the Owner of the Report and Owner of the Sheet that I am trying to insert. I can do this manually without any issues. Any thoughts? curl -H "Authorization: Bearer TOKENHERE" -H "Content-Type: application/json" -X POST…
-
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…
-
Smartsheet api call in python.
Hi im trying to use the smartsheet API in python with the following code. import smartsheet smart = smartsheet.Smartsheet(api_base="https://api.smartsheet.eu/2.0/sheets", access_token="MYKEY") smart.assume_user("MYEMAIL") sheet_id = "MYSHEETID" sheet = smart.Sheets.get_sheet(sheet_id) print(sheet) But I get the following…
-
How to divide single request with multiple contacts to individual requests.
Does anyone know how to take a single line, with a single multi-select cell, and have that line parse/delineate/divide in to individual lines, either through a formula or an automation? Scenario: we are receiving schedule block request for team, and multiple people may be on the block request, therefore we have multiple…
-
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…