Using Excel to Pull Data With REST and Multiple BAQs

[josecgomez]

@NateS

I think I need a way to make the values in the Excel range Sheet1 C2:C40, the parameter filter for the BAQ. Is this doable? Am I on the right track? Thank you for your time!
Nate

Doable? possibly
@amurdock has an excel sheet template that does some of this though I think its just one BAQ as well. Let me dig it up

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…