BAQ - How to create a complex query or queries that are linked

[Banderson (Brandon Anderson)]

@Yodelayheewho

I have a sneaky feeling access to a UD Table also requires high level permissions.

No, you’ll see those in a normal Epicor BAQ. Search “UD” and you’ll see them all.

@amurdock made a snazzy excel sheet that can bring in BAQ info into excel. I haven’t dug into it myself, so I don’t know how complicated it is to set it up, but I believe he’s already done much of the heavyu lifting.

Pull REST data into Excel based on values on excel?

Here is the sample file I presented at Insights. You can use this to generate a full REST url complete with filters, sorting, select columns, and the number of rows to return. EpicorQuery - zHomepage_SOOpen.xlsx (112.7 KB) The key is a function in Power Query Editor to read the full URL from a table and cell value. In the attached Excel example it is reading the URL from the ‘Parameters1’ table, and the 11th row of the ‘Value’ column and passing that into the EpicorBAQ query. [image] [ima…