how do I solve calling an api result where i need to pass a parameter from a column in another table

[nupur]

I have a table where I have the name column which contains the project name.. Now I need to pass each of these project name in an api call which in result will give me details about each project and I need to figure out which project was last commited. How can I pass each project name in the api and get all the result at once. I have this table:

Name	ID
Project A	A1
Project B	A2
Project C	A3
Project D	A4
Project E	A5
Project F	A6

I need to call this api in Power Bi for each project like this : https://api.ProjectA.com/value, https://api.ProjectB.com/value ..... and so on..and consolidate under one table. Is it possible in Power Bi?

[ImkeF]

Hi @nupur ,
did you watch the video that I linked in that blogpost?
Would be interested to understand what is missing in there.

[Greg_Deckler]

@nupur Should be possible, sounds like you need to create a function. Using custom functions in Power Query - Power Query | Microsoft Learn @edhans @ImkeF 

[ImkeF]

Hi @nupur ,
please check out this article/video: Web Scraping 2: Scrape multiple pages at once and refresh in Power BI service – The BIccountant

[nupur]

It would be nice if I could have a show and tell, its difficult for me to follow as I am a newbie to Power Bi and still learning the basic 

[nupur]

Hi @Greg_Deckler , thanks and yes as per my search I see that creating function is something which can work here. However I am still confused as where should I create the function .