-
Smartsheet api call in python.
Hi im trying to use the smart sheet API in Python with the following code. #Establishes a connection to smart = smartsheet.Smartsheet(api_base="https://api.smartsheet.eu/2.0/sheets", access_token="MYTOKEN") smart.assume_user("MYEMAIL") #Establishes link to the time off requests smartsheetsheet_id = "MYSHEETID" sheet =…
-
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…
-
Where can I see all the API tokens being run in Smartsheet?
I am a relatively new system admin and was just made aware that an API token is no longer working. Is there a place where I can go to see all API tokens being used in the system, rather than just mine?
-
Please suggest a recommended way to fetching data at the organization level with admin user
We need a way to fetch the entire data at the organization level using admin user (Data of all the Non admin and admin users). From the APi documentation and from the below discussion it appears that admin user's oauth2 token is not sufficient to fetch the entire organization's data. Pleas help us with this query. Also…
-
Access to Event Reporting API other then Enterprise plan
Hi, As Event Reporting API(https://api.smartsheet.com/2.0/events?since=2022-01-10T00:00:00Z) is available via Enterprise plan only, Is there any way we can access this API with free trial or Developer account. We require the access of this API for development purpose only. So Please let us know if there is another way to…
-
Getting error when trying to use Assume-User functionality to fetch the data of all users.
The Admin account is unable to fetch data for other users incase of the developer account. When we try to use the Assume-User functionality to fetch data by impersonating other users, with the help of an admin account and Oauth2 session, we get the following error. { "errorCode": 1030, "message": "You are unable to assume…
-
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.
-
Is there a better way to completely remove user access via the API?
Hello, We're beginning to look into integrating the removal of a user's Smartsheet account as part of our employee offboarding process. My intent was to use the API for this functionality so that it could be automated. Unfortunately, I'm not finding the API endpoints available to accomplish this task in a relatively small…
-
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…