Hello, I was able to successfully connect to Salesforce via the Salesforce Application Scope; however, when I use the download file activity I get the following error: “The filename, directory name, or volume label syntax is incorrect”.
I make sure that the folder download path is valid, as is the report id. I am not sure how to get rid of this error. Any ideas would be helpful!
Update: the activity only downloads files, not reports from Salesforce. Other than using an API call, is there a way to download a report from Salesforce?
you can use the Execute Report activity inside an Salesforce Application Scope, it will return you a datatable and you can write it into an excel file.