Hello,
I want to read a file with ‘.xlsx’ extension from a URL, then convert the data in this file to JSON and send it as a message to Telegram.
The problem: I could not read the XLSX file and convert it to JSON.
What did I use?
I tried to read the file with ‘.xlsx’ extension in the following URL using the ‘Get a File’ method under HTTP and ‘Make a Request’ method under HTTP.
URL: https://www.takasbank.com.tr/plugins/ExcelExportTefasFundsTradingInvestmentPlatform?language=tr
However, I could not find a method to parse the returned result to JSON. For example, I want a JSON like below:
[
{"code":"AFA", "name":"AK PORTFÖY AMERİKA YABANCI HİSSE SENEDİ FONU"},
{"code":"AFV", "name":"AK PORTFÖY AVRUPA YABANCI HİSSE SENEDİ FONU"}
]
How can I read a file from this URL => convert the data from the file to JSON?
