Forum Discussion

8 Replies

  • 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