Tuesday, 15 July 2014

json - How can I use MSXML in Visual Basic 2010 -



json - How can I use MSXML in Visual Basic 2010 -

i have excel applications written in vba. used utilize soap access api api has changed utilize json. have converted of vba code , got working. have .dll created using visual basic 2010. utilize .dll within vba code create asynchronous calls, otherwise vba code has wait response each time phone call api. vba application time critical can't that. need alter visual basic 2010 code. vba code want duplicate is:

dim xhr : xhr = createobject("msxml2.serverxmlhttp") xhr .open("post", url & "/", false) .setrequestheader("x-application", appkey) .setrequestheader("content-type", "application/json") .setrequestheader("accept", "application/json") .setrequestheader("x-authentication", session) end xhr.send(requeststring) sendrequest = xhr.responsetext

the variables url, appkey, session, requeststring known variables.

how can recreate code in visual basic 2010? know there more efficient ways accomplish want, can't afford spend 3 months learning python write couple of dozen lines of code. i've found examples of using httpwebrequest calls can't them work me. can point me working example?

json visual-studio-2010 vba msxml

No comments:

Post a Comment