BAQ Export Process output location

[NateS (Nate Schoonover)]

Select your BAQ and click Submit. Look at the system monitor to see that the report is completed and to see the location it gets saved to. In my case I went to Server File Download, changed the drop down to Company, and my report was in there under my name.

[abill9 (Andrew B)]

Thank you, Nate. I was able to access the file this way, however I am trying to automate this export process. Is this possible? I have the BAQ export process scheduled to run each night but cannot find the export file.

[Mark_Wonsil]

ServerFileDownload is available via a REST endpoint, so you can still automate the download - especially if the file name is constant.

You will find examples of people here on the list calling endpoints from PowerShell.

[Mark_Wonsil]

BTW, you can skip the entire BAQ Export Process by calling the BAQSvc via REST and directly download the results. Again, examples can be found here on the list.

[abill9 (Andrew B)]

Thanks, Mark

This is all pretty new to me but my end goal is to bring information into Power BI. Maybe this method is not the easiest or correct to begin with.

I have been struggling with connecting Epicor with Power BI using an Odata source… so I turned to this.

[Mark_Wonsil]

You may want to look at what @Camren360 did here:

REST API access to PartNum and PartDescription in Same Table?; SaaS Implementation

I’d be interested to know if there is something not optimized with your query, or if accessing the BAQsvc is just faster. I tested your URL in my environment(changing parameters accordingly) It took 30sec for 1k, and 17 minutes for 30k. During those 17 minutes I made an equivalent BAQ, and accessed it through REST, and it took like 10 seconds to load the 30k rows of data. We regularly pull large BAQ datasets through REST into PowerBI… I have a BAQ to grab Part Data such as description, item t…

[abill9 (Andrew B)]

Anonymous does not work so I choose basic, enter my credentials and am prompted with this image:

Here is the URL I am attempting to use:
“https://centralusdtpilot50.epicorsaas.com/SaaS5107Pilot/api/v2/odata/{COMPANY}/BaqSvc/{BAQ}/Data?api-key={API}”

[Camren360 (Camren Carlyle)]

Do you have your api key linked to an access scope?

[abill9 (Andrew B)]

API Key Maintenance Access Scope Field is blank.

[Mark_Wonsil]

Silly question, but you’ve replaced {COMPANY}, {BAQ}, and {API} with your values?

[abill9 (Andrew B)]

Yes, of course

[Camren360 (Camren Carlyle)]

Create an access scope, add your BAQ, and then add it to your API Key. See if that fixes it.

[Mark_Wonsil]

Can you get to the BAQ Swagger page and execute your BAQ there?

https://yourhost/instance/apps/resthelp/#/home

[abill9 (Andrew B)]

Yes, I can access and run the BAQ in the Swagger page.

[abill9 (Andrew B)]

This did not fix it.

[Mark_Wonsil]

How are you trying to run it? In a browser window or PowerShell?

[Camren360 (Camren Carlyle)]

is the api-key enabled and not expired? Is it your BAQ, if it is someone else BAQ is it shared?

I don’t usually encounter this error often and when I do it is my own doing lol

[abill9 (Andrew B)]

Unsure of what you mean but I am running Swagger through a browser. I ultimately want to access the BAQ through Power BI.

[abill9 (Andrew B)]

Yes, the API key is enabled and the BAQ is a test BAQ I made.

Are there any specifics when entering the URL in Power BI I am not aware of that I may be missing?

[Camren360 (Camren Carlyle)]

When you are pulling this in power query are you doing it with through a web query or an odata query?

Very important to use the “From Web” option with Microsoft Power Query as REST v2 has problems with odata