Forum Discussion

Mekist's avatar
Mekist
Icon for Helper III rankHelper III
1 year ago

Dynamic URL Refresh

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.W...
Need Help
Omid_Motamedise's avatar
Omid_Motamedise
Icon for Super User rankSuper User
1 year ago

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's avatar
    Mekist
    Icon for Helper III rankHelper III
    1 year ago

    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's avatar
      Omid_Motamedise
      Icon for Super User rankSuper User
      1 year ago

      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's avatar
        Mekist
        Icon for Helper III rankHelper III
        1 year ago

        Thank you very much

        Can I have it poured into the products table?