-
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!…
-
How to Update a Smartsheet form dynamically
I have a form with questions that needs to dynamically change based on data from one of my company's internal webpages (Jira). Is there a way I can programmatically read data off Jira's API to then edit a dropdown list of questions? Thanks
-
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…
-
How can I a single cells value using API?
I have the below code, I am trying to get the value a specific cell but I am getting the 1006 error. However if I modify this for a put request, it works without issue? also to note, I am doing this in vb Sub GetCompletedCellValue(apiKey As String, sheetId As Long, rowId As Long, columnId As Long) Using client As New…
-
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…
-
I have Smartsheet PRO account and not able to generate the access token
-
Can we pull the capacity % information from RM to Smartsheet?
Hi, I am wondering if there is a way to pull the capacity % for the disciplines and roles that's already provided in the Capacity window (under the schedule tab in RM - snippet below) back to Smartsheet? The reason is that we are in the process of having 3 different RM workspaces for 3 different entities, however, the top…
-
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,