BAQ with mandatory parameters to excel using REST

[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…