Save BAQ result to Text File

Looking for example where BAQ results are Output to Text or XML files.
I have Cloud Kinetic 2022.2.11 in production.
If you know of an existing documentation and can point to it that would be great.

In this case you would have to export your BAQ results by right clicking on the data and going to export to Excel. You will have to convert it into the format you want from there.

If your BAQ is in a BAQ report, then you can choose to send the output to a xls, xml, csv, or other versions.
Good luck!
Nate

To a particular location in the cloud or on prem?

What’s the business problem that you’re trying to solve?

We are Cloud Based, The BAQ would run in background so need the File to be created as part of the process, File can end up in Epicor cloud FTP for pickup via Batch move.
Will contain groups of customer / order / part records (XML style groupings)

Are you familiar with this program (or REST endpoint)? I had it when I was in the cloud for 10.2.###.

You can then use this to retrieve the file (or call the REST endpoint) to avoid the less secure FTP.

image

Alternatively, you can call the BAQ REST Service and download your data directly via PowerShell.

Mark, Thanks will give that a try.

You can use the BAQ Export Process (as others has mentioned)
Then in the Output Filename path enter in the UNC path to the shared Epicor Cloud FTP site that was given to you with the filename.
Then in Schedule enter in the task schedule you created to run in the background (hourly, daily, etc).

You can also drop it in the folders that can be reached via Server File Download.

Edit, I’m an idiot and didn’t miss @Mark_Wonsil 's post, I actually misread it.

Hi Mark, we have automation studio and I was curious about this option for downloading the file and sending it out Via email. How do you locate and execute the REST endpoint for this service? I was looking through the rest help guide and found the DataExportSVC am I on the right track?

BAQSvc.