Excel Parameter To Filter Epicor BAQ

Epicor ERP 10
, ,
2

There should be examples on here to grab OData results from a REST URL
Here is a sample Power M Functions/Query against the OData Feed parameterized to create Excel Dataset/Table…

Function p:

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

Function t:

let
    Source = (paramName) => (Text.From(paramName))
in
    Source

Function dt:

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

Table Query (Example uses above functions and named ranges to provide variability):

let
    baseTableData = Table.TransformColumnTypes(Table.AddColumn(Table.RenameColumns(Table.SelectColumns(
        OData.Feed(p("URI_Protocol")&"://"&p("Server_FQDN")&"/"&p("Epicor_Instance")&"/"&p("API_Version")&"/"&p("ServiceName")&"/"&p("BAQ")&"/"&"?ModelYr='"&t(p("ModelYr"))&"'&CostingSite='"&t(p("SiteCostID"))&"'&LaborRate="&t(p("LaborRate"))&"&BurdenRate="&t(p("BurdenRate")), null, [Implementation="2.0"])
        ,{"PartCost_CostID","ProdGrup_Description", "EZ_CfgOptionsTrailers_Trailer", "TrailerMasterPart_PartDescription", "Calculated_OptionType", "TrailerPart_PartNum", "PcConType_TypeDesc", "TrailerPart_PartDescription", "Calculated_IsDefault", "Calculated_TotalCost","Calculated_IncCost"}),{{"ProdGrup_Description", "Product Group"}, {"EZ_CfgOptionsTrailers_Trailer", "Trailer"},{"PartCost_CostID","Site CostID"}, {"TrailerMasterPart_PartDescription", "Trailer Description"}, {"Calculated_OptionType", "Option Type"}, {"TrailerPart_PartNum", "Option PartNum"}, {"PcConType_TypeDesc","Config Desc"},{"TrailerPart_PartDescription", "Option Description"}, {"Calculated_IsDefault", "Is Default Option"}, {"Calculated_TotalCost", "Item Total Cost"}, {"Calculated_IncCost", "Inc Cost"}}),"Trailer Model", each if Text.Contains([Trailer], "-01") then [Trailer Description]&" (Alum)" else if Text.Contains([Trailer], "-10") then [Trailer Description]&" (Galvanized)" else if Text.Contains([Trailer], "-12") then [Trailer Description]&" (Painted)" else [Trailer Description]&" (?)"),{{"Is Default Option", type logical}, {"Item Total Cost", type number}, {"Inc Cost", type number}}) 
in 
    baseTableData
1 Like