Forum Discussion
Mekist
Helper III
1 year agoRefresh issue on portal
Hello I create a function and call it with a query. When I try to refresh it through the Portal, I get the following error. I went back and looked at the reason one by one. The function cannot b...
Mekist
Helper III
1 year agoHello
Without a dynamic URL, only one company data can be retrieved, I need to retrieve multiple company data at the same time
let
produceName = "ADEL", // Replace this with the actual produceName parameter
url = "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",
Kaynak = Json.Document(Web.Contents(url)),
value = Kaynak[value],
#"Tabloya Dönüştürüldü" = Table.FromList(value, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Genişletilen Column1" = Table.ExpandRecordColumn(#"Tabloya Dönüştürüldü", "Column1", {"itemCode", "itemDescTr", "itemDescEng", "value1", "value2", "value3", "value4"}, {"Column1.itemCode", "Column1.itemDescTr", "Column1.itemDescEng", "Column1.value1", "Column1.value2", "Column1.value3", "Column1.value4"})
in
#"Genişletilen Column1"
Mekist
Helper III
1 year agoHelp please