-
Power Automate to Smartsheet - error on checkbox value
Hi all! I am using Power Automate to insert a row into a sheet. The sheet contains a checkbox field ( I have removed the 'Restrict to checkbox use only'). Upon insert I get this error: The value for cell in column 8850556387125124, True, did not conform to the strict requirements for type CHECKBOX. Am I missing something?…
-
Is there a way to automatically extract the activity log?
I have an extraction of the activity log every week and I was wondering if there is a way for an automatic extraction of this log
-
Getting APiERROR
INFO - {"request": {"command": "POST https://api.smartsheet.com/2.0/sheets/7024241635446660/rows"}} ERROR - {"response": {"statusCode": 400, "reason": "Bad Request", "content": {"errorCode": 5536, "message": "The value for cell in column 8477412257124228, did not conform to the strict requirements for type DATE.", "refId":…
-
Get Report API - Additional fields
Hi, I am making a get report api call to fetch the reports created after a certain date https://api.smartsheet.com/2.0/reports?modifiedSince=2024-08-01T00:00:00Z This is the reponse i get There are some additional fields i want in the data array like modifedAt, etc, these are mentioned in the response in the api…
-
When the CopySheet API responds, is the copied sheet really fully created?
I am synchronously using the CopySheet API to make a copy of a sheet. This API responds with a sheet summary, which itself includes the copied sheet's id. Immediately when that sheet is copied, I call the GetSheet API to get the full details of the new sheet. Mostly this works, but a moderate number of times, I will get a…
-
Smartsheet Python API Apply Wrap Text and Center Alignment from Column 1 to column 40
Hello everyone. I have approximately 75 sheets distributed in different folders and subfolders inside a folder. I've built a script that iterates in each sheet successfully, but i'm failing at achieving that in each sheet, from column 1 to column 40, the "wrap text" format is applied and the center alignment is applied.…
-
Combine data from smrtsheet EDW and sharepoint
I have set of smartsheets with fixed set of columns. I need to combine data from those sheets, EDW and sharepoint. Then create a template out of it. Is it possible to use power automate. Suggest some examples to start with and using connectors.
-
Best way to automatically copy a Smartsheet file to a SharePoint List?
I've been looking on the internet for a good way to copy a Smartsheet to a SharePoint list. One of the recommendations was to user Datashuttle which I tried but it only creates a .csv or .xlsx file in the SharePoint library. What I need is for the SharePoint List to be updated automatically from the Smartsheet file so the…
-
I cannot get the PUT method to work. What is wrong with my Google Script code ?
I cannot get the PUT method to work. It does not error but it also does not update the sheet. The same code framework will add columns (with a POST), and pull back data (with a GET)..but it will not put data into the sheet. Tried it with Content-Type in the Headers section and Options, with out single quotes and with,..all…
-
How we will implement a CDC with Smartsheets API using python. Is that even possible?
What are the key endpoints that you have to query Which of them are historical Which of them support CDC What are the key fields / logic to perform CDC and what parameters do you pass to the API to get CDC data