Using Excel to Pull Data With REST and Multiple BAQs

Kinetic ERP
19

I have the tPartsToFind Query working, but having an issue with the odata pull.

Capture3223wed
Capture3223wed1679×824 109 KB

Capture34fqfqrv
Capture34fqfqrv1605×832 115 KB

Captureasda32
Captureasda321306×444 60 KB

let
	PartsToFind = Table.RemoveColumns(
			Table.TransformColumns(
					Table.AddColumn(
							Table.Group(
									Table.AddColumn(
											if(Table.IsEmpty(dt("tPartsToFind"))) then 
													#table(type table [PartNumber = text], {{"Part1"},{"Part2"},{"Part3...etc"}}) // You could use this versus a named table
											else
													dt("tPartsToFind") // Use my named table called tPartsToFind
											, "GrpBy", each "EZ") // Add pseudo aggregator column GrpBy to each row
									, {"GrpBy"}, {{"PnTable", each _, type table [PartNum=text,GrpBy=text]}}) // Group into table
							, "PartsToFind", each Table.Column([PnTable], "PartNumber")), // Use all of our PartNums in our pseudo group table into list
					{"PartsToFind", each Text.Combine(List.Transform(_,Text.From),"&PartsToFind="), type text}) // Aggregate each list item with a new copy of the &param= dates will need more here
			,{"GrpBy", "PnTable"})
in
	PartsToFind

let   // OData Feed Pull
    // Encode Basic Authentication manually (username:password in Base64) : Change appropriately
    Base64Auth = "Basic " & Binary.ToText(Text.ToBinary("datapuller:mypass"), BinaryEncoding.Base64),

    // API Key : Change appropriately
    ApiKey = "mykey",
    Headers = [
        #"Authorization" = Base64Auth,
        #"X-API-Key" = ApiKey,
        #"Content-Type" = "text/plain"
    ],
    // Query Parameter(s)
    partsToFind = Table.FirstValue(PartsToFind),
    baseTableData = OData.Feed("https://myserver/api/v2/odata/VTAERO/BaqSvc/JobDetails/"&"?PartsToFind=" &partsToFind, Headers, [Implementation="2.0"]) 
in 
    baseTableData

In this one I keep getting an error: Expression.Error: The import PartsToFind matches no exports. Did you miss a module reference?