-
Unable to extract sheetId from row object in a Report
Hello! I would like to create a pandas dataframe with smartsheet Report data. # Method to convert report to dataframe col_names = ['sheet_id','row_id'] + [col.title for col in report.columns] rows = [] for row in report.rows: # Append the id first cells = [] cells.append(row.sheetId) # This is where I get an error!…
-
ODBC-Smartsheet connector
I am trying to add smartsheet connector in User DSN through ODBC Data Source Admin. It keeps on saying invalid username/password. I am pretty sure I am using right credentials. I can login to smartsheet with that. We recently enabled SSO for smartsheet. I even tried User API token for SSO login. I generated the access…
-
Search Sheet SMartsheet Api not finding values
I am developing a Power Automate workflow that needs to search a sheet for particular values. I used the "query" portion to search for a "Project Name", "User", "Date of Entry", and "Phase" however, it will not produce any results. Testing further, I can get the search to work for "Project Name" and "User" but the "Date of…
-
Simple row update via API/Powershell
Just getting started with the API. Just want to show a proof of concept of updating a cell. I'm able to authenticate and get sheet, row and column details. I'm getting the error: Invoke-RestMethod : { "errorCode" : 1008, "message" : "Unable to parse request. The following error occurred: Unrecognized token 'value': was…
-
Smartsheet is adding a leading apostrophe when writing numeric data.
I am using Python to copy excel data to the Smartsheet. I have an excel column that can be either a number or text/string, and I want to ensure that numeric values are not automatically formatted with a leading apostrophe in Smartsheet. I noticed that when using the value attribute instead of object_value, the leading…
-
Smartsheet API Call
Hello Team, Please let me know the best way to make an API call from Smartsheet to request data from another tool and how to handle the response. I know I need to use a GET request to make the API, call but I am not sure how to handle the response in Smartsheet. Many Thanks,
-
webhook suddenly stopped working.
I created a Smartsheet webhook last month, and it was working fine. However, from yesterday it stopped working. I faced the same problem before, so I created a new webhook, but now, even the second webhook stopped working. Can you help me understand the reason for this issue?..
-
Smartsheet API - Post
Hello Team, I am using Postman to write an API to POST data into Smartsheet. I am looking for examples of a script, which uses the POST method to update specific columns in Smartsheet. Many Thanks.
-
Get multiple pages of data in Bridge
Hi all I just wanted to pass along a pro-tip that I got from the Technical Engineering group at ENGAGE 23. If you need to deal with paged data in Bridge, it's not immediately obvious how to do that. At least not to me :-) So I asked. For example, if you do a List Sheets in Bridge, you may get some of the data back on page…
-
/reports api response should have createdAt and modifiedAt fields like /sheets call
/reports api response should have createdAt and modifiedAt fields like /sheets call Hi, As of now createdAt and modifiedAt date fields are present in /sheets and /sights how ever these 2 fields are not present in /reports call. https://smartsheet.redoc.ly/tag/reports documentation says that these 2 fields should be part of…