-
Python equivalent of API doesn't give the same result
I tried using the python equivalent function of the api https://api.smartsheet.com/2.0/reports?modifiedSince=2024-08-01T00:00:00Z&include_all=True as self.smartsheet_client.Reports.list_reports(modified_since='2024-08-01T00:00:00Z', include_all=True) This time it's giving me all the reports 360 of it, why didn't the python…
-
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…