Dynamic URL Refresh

[Mekist]

Hello

I want to retrieve the data by changing the "produce Name" section using the dynamic url address.

How can I

For example; ADEL, ULKER

"https://www.isyatirim.com.tr/_layouts/15/IsYatirim.Website/Common/Data.aspx/MaliTablo?companyCode=" & produceName & "&exchange=TRY&financialGroup=XI_29&year1=2024&period1=12&year2=2024&period2=9&year3=2024&period3=6&year4=2024&period4=3"

produceName = "EREGL"

[Omid_Motamedise]

You can use the list definitaion and using List.Transform. SO creat a list including all the product name as :

a={"ADEL", "ULKER"} ,

then use list.transform to convert the text to the url as bellow.

b=List.Transform(a, each 

"https://www.isyatirim.com.tr/_layouts/15/IsYatirim.Website/Common/Data.aspx/MaliTablo?companyCode=" & _ & "&exchange=TRY&financialGroup=XI_29&year1=2024&period1=12&year2=2024&period2=9&year3=2024&period3=6&year4=2024&period4=3")

it going to convert all the text into the url so  in the next step you can load the data by another list.transform as

=List.Transform(b, each Web.Contents(_))

[Mekist]

I don't understand exactly how it is done, if you don't mind, is it possible for you to share your PBI transfer?

[Omid_Motamedise]

Just go to the power query Editer, and then Advance editor, and past the next code.

let
    Part1="https://www.isyatirim.com.tr/_layouts/15/IsYatirim.Website/Common/Data.aspx/MaliTablo?companyCode=",
    
    Part3="&exchange=TRY&financialGroup=XI_29&year1=2024&period1=12&year2=2024&period2=9&year3=2024&period3=6&year4=2024&period4=3",

    Products={"ADEL", "ULKER"},

    Combine=List.Transform(Products, each  Json.Document(Web.Contents(Part1&_&Part3)))
in
    Combine

[Mekist]

Thank you very much

Can I have it poured into the products table?

[Omid_Motamedise]

Can you share the image of your product table?

[Mekist]

Adding pbix file does not allow

Can you proceed with the product codes in the example?

[Mekist]

I added the PBI file

https://dosya.co/khwe9tnu7xo3/TEST.pbix.html

[Mekist]

I added the PBI file

https://dosya.co/khwe9tnu7xo3/TEST.pbix.html