Product questions?
Ask it here! The community's got your back.

API & Developers

Connect with other developers from around the world and collaborate on ideas using the Smartsheet API.

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…
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…
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…
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…

Popular Tags

Trending in API & Developers

URL String - Any common thread between Sheet and Form?
Hi there, I came across a circumstance where someone had a link to the form but forgot where the sheet lives. Is there anything within the URL of the form that can bring you to just the sheet? I tried cutting out the 'form' from the URL, but unsuccessful. TYIA!
Newly Received 404 with Error Code 1006 on DELETE sheets/{sheetId}/rows API with ignoreRowsNotFound
Hey there, Was a recent breaking change pushed to the smartsheets API? Previously, when calling the DELETE Request to the rows endpoint, I would receive a 200 with a valid response. Now, when requesting a valid sheet, with a valid row, I am unable to get a 200 response and am only receiving 404 with error code 1006 in…
When I Copy Workspace, Everything Copies Fine Except for CellLinking
Hi, Using the API documentation, I'm able to copy entire workspaces which has been great for scalability. I've been noticing that the only thing that doesn't work correctly out of all the sheets, reports, and sights, is the cellLinks in my sheet. In the instructions, you can tell it all the different things to pull in. I'm…

API & Developers

Discussion List

Categories

Popular Tags