cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
djanszentql
Helper I
Helper I

Power Query Dynamic Parameter from Column Values

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.

3 REPLIES 3
Jimmy801
Super User III
Super User III

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

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?  

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors