Nested API with parameters

[Anonymous]

Looking to pull in from an API all users and the courses they have taken.

Currently I am able to pull a list of all users into a table with associated information, and I have reduced that to just the user-id's into a single column table/query.

Next I need to use [user-id] in the following API call (GET /users/{user-id}/courses) to grab the courses the user has done.  Looking to create a table with all the users and courses they have completed not sure how best to handle this without a middle step of storing data in a seperate database table.

 Users Table (can currently access)

| user-id | First Name | Last Name |

Course Table

| GUID | Course Name | Percent Complete |

Desired Table

| user-id | First Name | Last Name | GUID | Course Name | Percent Complete |

[Anonymous]

HI @Anonymous,

I'd like to suggest you write a custom function with parameter 'userid' and transform recovered data to a table. Then you can add a custom column to use 'user id' column as parameter to invoke above function.

After finish these steps, you can extract list of user tables to a new query table and use power query functions to merge these user tables.

Table.Combine

Regards,

Xiaoxin Sheng