-
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.
-
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…
-
Multiselect Drop Down (Columns) and Export (Excel) or API
We have several multiselect drop down columns in our sheets that get either exported to Excel or get sent to other systems via an API; when it exports or the other "systems" receive the data that field / cell (which has multiple items) will not separate the items by anything (not a comma, colon, space, etc.). WHY? The…
-
Remove/Delete existing hyperlink using API
Per the problem outlined in the below community post, it appears the API is unable to remove existing hyperlinks from cells. It is possible to add or update hyperlinks, but not delete/remove them. Please add the ability to either completely clear cells (including hyperlinks) or remove just existing hyperlinks using the…
-
Merged: Formatting Capabilities in Automation Emails
This discussion has been merged.
-
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…
-
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…
-
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…
-
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…