-
Create Workspace with REQUEST BODY SCHEMA
I've been tried to create an entire workspace based on another existed workspace following the "REQUEST BODY SCHEMA" on the documentation, but not successful. For some reason we can't use the "Copy Workspace" method(inter-region data migration). Could you advice if this method still feasible?
-
Account setup for Sandbox for developers
in order to create an account, does the email address need to be within your domain for it to work? I'm trying to understand what type of email account we will need to create and if its worth the MS license to create an email account or if we can use gmail for sandbox?
-
Resource Management - API Error [Code:500] - [Message: Internal Error]
Hello, I am trying to make an API call on Resource Management Reports API, it works fine until I pass the group_by parameter then i receive the subject error (500: Internal error) although the group_by is one of the parameters that we can pass according to the API documentation and by default if not passed its (group_by:…
-
With the recent tableau update to version 2023 the smartsheet WDC is no longer working.
So We recently updated our tableau server to 2023.1.2 version and the smartsheet wdc stopped working , we can still connect to smartsheet but now we are not able to refresh the published datasource. Is anybody else facing this issue? any workaround found for this one? Also according to tableau the smartsheet wdc was based…
-
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,
