Forum Discussion
Mekist
Helper III
Helper IIIDynamic 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...
Omid_Motamedise
Super User
Super UserYou 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(_))
MekistHelper III
Helper IIII don't understand exactly how it is done, if you don't mind, is it possible for you to share your PBI transfer?