Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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

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):

IDName
12345Object1
67890Object2

 

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

 

  • 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

2 Replies

  • 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