cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PhilippeVoyame
Regular Visitor

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

 

1 ACCEPTED SOLUTION
PhilipTreacy
Super User III
Super User III

Hi @PhilippeVoyame 

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



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

2 REPLIES 2
mahoneypat
Super User IV
Super User IV

Please see if this video helps.

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

 

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


PhilipTreacy
Super User III
Super User III

Hi @PhilippeVoyame 

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



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

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