Loop and union of data from webservice based on secondary table

[LCHolmes]

Morning,

I hope someone can help me with this.

I am attempting to pull and merge/union a number of datasets based on another list of ID's

So the first query would be something like the following:

This gives me my list of id's:

I need then to loop through and make calls to the webservice based on the ID:

and union it all together as unfortunately the webservice doesnt have a call for give me all absensces for everyone.

Any help, guidance or ideas on this would be much appreciated as I am relatively new to power query and not to sure where to start with this.

[Jimmy801]

Hello @LCHolmes 

you can add a new column where you making the data access and use the ID of parameter of it lik

Web.Contents("httpxxxxxxx/" & _[ID] & ")")

Depending what this web service is handing over, you can combine the results like

Combine = Table.Combine(YourPrevisousStep[YourNewColumn])

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

[LCHolmes]

Thanks for your reply @Jimmy801 .

Apologies though, I'm new to this language and don't really understand what you mean.

When I make the call to the webservice with the ID included i get the following back:

So I need to make that call for each uniqueID from the initial request and union them.

[Jimmy801 · Accepted solution]

Hello @LCHolmes 

so add a new column to your id-Table where you calling this webservice like you did in you last post. Substitute the "ID"-part with the column reference as I was showing in my previous post. 

Then you should get a table in every cell of your new column. Then you can combine this table-column with Table.Combine(YourPreviousStep[YourNewColumn])

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

[LCHolmes]

Thanks for that.

This is what I have ended up with, while it might not be the best its working and I can tweak as I learn more

Thanks for the help and the extra explination @Jimmy801