Power Query Dynamic Parameter from Column Values

[djanszentql]

Is it possible in Power Query's M Language to have a query parameter in the API string that will iterate through a list of values that are in a separate query/column and ultimately merge the results into a single result set that also appends that same value to the final result set.

[Jimmy801]

Hello @djanszentql 

you have to do it the other way round. Use your column/list to iterate through (List.Transform) and apply on each step your api-call. Then you will have a list of api calls (with tables or lists). After that you can combine your result with List.Combine or Table.Combine.

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

[djanszentql]

Can you explain what you mean by "apply on each step your api-call".  I have to specify the API call multiple times? Doesn't that defeat the purpose of iterating through each row dynamically?  

[Jimmy801]

Hello @djanszentql 

I give you a short example with a list. The web.contents is launched 3 times and using the list item as parameter for the web-call

let
    Source = {1,2,3},
    CallWebAPi3Times = List.Transform(Source, each Web.Contents("YourUrl" & Text.From(_)))
in
    CallWebAPi3Times

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy