gargamalebarbosa
Board Regular
- Joined
- Aug 4, 2022
- Messages
- 118
- Office Version
- 365
- Platform
- Windows
Hi,
I used the code from the link Şimdi herkes besanaliz.com da buluşuyor. Türkiyenin en kapsamlı bes analiz platformu. to fetch the entire table, but it failed. I couldn't retrieve the desired table. I kindly request your assistance.
thank you,
I used the code from the link Şimdi herkes besanaliz.com da buluşuyor. Türkiyenin en kapsamlı bes analiz platformu. to fetch the entire table, but it failed. I couldn't retrieve the desired table. I kindly request your assistance.
thank you,
VBA Code:
Sub test()
Set rq = CreateObject("MSXML2.XMLHTTP")
dt = "{'RaporParams':{'Url':'fonbul-fon-ara-bul-fon-ara','RaporParametreleri':[{'key':'IlkTarih','value':''},{'key':'SonTarih','value':'23/02/2024'}],'RaporKriter':{'VeriGrup':'FonKriter','Kriter':[{'key':'FonKategori','value':'307, 308, 309, 310, 311, 312, 313, 314, 315, 316, 318, 319, 320, 321, 322, 323, 324, 325, 326, 405, 406, 407, 327, 328, 329, 330, 333, 334, 337, 338, 339, 340, 341, 342, 404, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305'},{'key':'AnaKategori','value':'290'},{'key':'AnaKategori','value':'290'},{'key':'FonYonetici','value':'0'},{'key':'DegerlemeTarihi','value':false}]}}}"
dt = Replace(dt, "'", """")
url = "https://www.besanaliz.com/FonBulPlusServis/fonbul/tr/RaporTabloHesapla?key=YtBTs2R0OjoluczSy3RxOI4ah4NSMFPuOHfaQpkwnMneqEugUhaxwk/eA9V6IYif9GRSQnjW2vLi4mc6pck8q7hHRfGR1/395t3hEloIRlfGFFhAyMe5EfEErqGJgIdBEvLni4lr7+M0Iw3P2nI+0qTDaEE208FjwTqVrXK/RxFylxtXOZ6AqEzYEn9xcPKhHBH0Ic1i/cIAz00d21WbUuLl7z3slDiPttebMyDlh9yVS0No4Zvk33+PCkCPPEW/C4wdqjKRuZ8+EcsNsG40alXtCDe+P7ieT3qf35D3IAbhxdJFsrOloWX3RTr2yyYg"
rq.Open "POST", url, False
rq.setrequestHeader "Accept", "application/json, text/javascript, /; q=0.01"
rq.setrequestHeader "Accept-Encoding", "gzip, deflate, br, zstd"
rq.setrequestHeader "Accept-Language", "en-GB,en;q=0.9,tr-TR;q=0.8,tr;q=0.7,en-US;q=0.6"
rq.setrequestHeader "Content-Type", "application/json; charset=UTF-8"
rq.setrequestHeader "X-Requested-With", "XMLHttpRequest"
rq.send (dt)
Do
DoEvents:
Loop Until rq.ReadyState = 4
MsgBox rq.responsetext
End Sub