BAQ with mandatory parameters to excel using REST

[arrobatony (Juan Vazquez)]

Hi Epicor experts.

I have an issue with a BAQ when setting the OData feed. Since it’s a BOM BAQ based on PartNumber, I set parameters for PartNum and Quantity.
This works fine in Excel as long as include parameters in the feed, my question is there a way to dynamically change this parameter?
Trying to have a template that replaces this PartNum parameter, but so far I can’t figure out a practical way to do it.

Any ideas?

[Banderson (Brandon Anderson)]

Check this out.

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…

[arrobatony (Juan Vazquez)]

Thank you for the file Brandon, do you have a reference to the article related with power query?
That’s the key issue I have, not really sure how to use the OData feed with dynamic parameters.

I found this article explaining a bit this, but uses a local file.

How To Parameterize Your Power Query | How To Excel

[Banderson (Brandon Anderson)]

It tells you how to do it in the post that I referenced. And you can download the Excel file and see what Andrew is doing as well. I haven’t done it myself, I just know that it’s available to use.