BAQ export format

[jasond (Jason Duncan)]

Is it possible to export (on a schedule) a BAQ in CSV UTF-8 format instead of standard CSV?

[timshuwy (Tim Shoemaker)]

I don’t believe so, but this would be something good to add as a suggestion in the Epicor Ideas site: https://epicor-manufacturing.ideas.aha.io/

[Mark_Wonsil]

You can call the BAQSvc from REST on a schedule from PowerShell and have full control of the encoding too.

[utaylor (Utah Taylor)]

This ^

[jasond (Jason Duncan)]

That sounds like a fantastic solution. Any way you could point me in the direction of some documentation on setting that up?

[timshuwy (Tim Shoemaker)]

Similar to what @Mark_Wonsil suggested, you can also use the new Epicor Automation Studio to run a BAQ, and then do anything you want to with the data that comes from the BAQ. But with Automation Studio, you don’t need to understand how to run a BAQSvc from REST… it is a built in component within Automation Studio and takes no-code. I just built this example in the last 3 minutes:

[Mark_Wonsil]

There’s a nice thread here.

PowerShell Rest Call - Help Needed

Finally got the code working as it should: $headers = New-Object "System.Collections.Generic.Dictionary[[String],[String]]" $headers.Add("Authorization", "Your Authorization") $response = Invoke-RestMethod 'Where the code came from' -Method 'GET' -Headers $headers $headers2 = New-Object "System.Collections.Generic.Dictionary[[String],[String]]" $headers2.Add("Content-Type", "application/json") $response2 = Invoke-RestMethod 'Where the data is going' -Method 'POST' -Headers $headers2 -Body (C…

I do have to remember Automation Studio as a new potential solution when we get to 2022.1.

[jasond (Jason Duncan)]

Thanks Tim. We are currently in the upgrade process to Kinetic now. Unfortunately this particular project can’t wait until then.

[jasond (Jason Duncan)]

Thank you very much Mark. Time to dig in.