REST API - Multiple Requests built on each other / Looping trough first table to build second

[Anonymous]

Hello Everybody

I was looking trough the forum but could not really find threds related to the subsequent challange, which might be caused by the fact that I do not really know how to call my issue.

Situation:

We do use a quality management SaaS solution. They do offer an API which would allow us to get the Data in PowerBI to display the results. 

Problem: 

In order to receive the desired Checklists with the respective quality control data, they do require a specific Object_ID in the URL:
https://xxxxxx.com/api/v3/assessments?object_id=12345

Therefore I do have to call for each of our 4000 Objects seperatly.

The Number of Objects can fluctuate, but they can also be called over the API, which returns a table (simplified):

ID	Name
12345	Object1
67890	Object2

Required Solution:

Im therefore looking for a PowerQuery Statement, that loops trough the Object-Table, getting the respective IDs, to call the according checklists.

If you have any hints where to look for respective Input on how this might be done or give me direct Input on a possible solution, you help would be highly appreaciated. 

Best Regards

Philippe

[mahoneypat]

Please see if this video helps.

(3) Power BI - Tales From The Front - REST APIs - YouTube

Regards,

Pat

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

If you have a query that calls the API and returns a table of ID/Objects - let's call that query GetObjID then you can get the Checklist for each of those ID'swith this code

Source = List.Transform(GetObjID[ID], each Web.Contents("https://xxxxxx.com/api/v3/assessments?object_id=" & Text.From(_)))

Regards

Phil