-
Can Bridge get data from Admin > Groups?
Is there a known or suggested method or Bridge workflow I may use to record data from Admin Center > Groups to a Smartsheet? I want a workflow to look up the groups in our plan's Admin Center and replace the rows of a sheet and column on a daily recurrence.
-
Add Retry Logic to Bridge API
Bridge doesn't have a mechanism to retry a workflow when it's stopped by error. Smartsheet should improve Bridge, so that a workflow which is stopped because of either a timeout or sheet lock is retried until successful. This can happen when you have competing processes (e.g. DataMesh, Pivot, Automations) which temporarily…
-
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.