Finally figured out how to tie live BAQ's to Excel!

Experts' Corner
, , ,
12

p function used below:

let
    Source = (paramName) => (Excel.CurrentWorkbook(){[Name=paramName]}[Content]{0}[Column1])
in
    Source

API v2 OData request

let
    Headers = [
          #"Authorization"="Basic " & p("Base64Auth")
        , #"X-API-Key"=p("x_api_key")
        , #"Content-Type"="text/plain"
        ],
    paramQuery="BAQ_Name",
    Source = OData.Feed(p("Uri_Protocol") & "://" & p("Server_FQDN") & "/" & p("Epicor_Instance") & "/" & "api/v2/odata/" & p("Company") & "/" & p("ServiceName") & "/" & paramQuery & "/Data?" , Headers, [Implementation="2.0"])
in
    Source

This used a named cell and pre encoded (base64) user:pw in that cell this was a TEST and does work, like I said below I was going to create a userform to take entry of epicor login info but … time is not my friend lately :frowning: