title: Download Json Obeject from URL by VBA
body: <p>I have a MS Access project that requires me retrieve and parse a Json object from a URL. I have done parse part, but I cannot figure out the correct way to retrieve the Json from the URL. If I copy and paste the URL on IE, it will automatically download the Json object as .json file for me. I have searched solution by Google, and none of them works for me. I think the problem is that the URL looks like "https://******.com/rest/external/session/123", which is not similar to a standard XML HTTP request URL. So most solutions which use XMLHTTP request does not work for me. </p>
  
  <p>I have tried to use following code to get it from URL. But all I get is homepage DOM tree instead of Json.</p>
  
  <pre><code>Dim wb As XMLHTTP
   Set wb = New XMLHTTP
   wb.Open "POST", "https://******.com/rest/external/session/123", False
   wb.send
   Do Until wb.Status = 200 And wb.ReadyState = 4
     DoEvents
   Loop
   Debug.Print wb.responseText
  </code></pre>
  
  <p>Anyone has any idea about what I should do here?
  Any help is appreciated!</p>
  
  <p>Updated:</p>
  
  <ol>
  <li><p>I have tried both POST and GET http request. And it gave me the same result</p></li>
  <li><p>Following are the processes captured by fiddler. </p></li>
  </ol>
  
  <p><a href="http://i.stack.imgur.com/OBjzi.png" rel="nofollow">This is captured processes if I copy the url directly on IE</a></p>
  
  <p><a href="http://i.stack.imgur.com/MMbPB.png" rel="nofollow">This is captured processes if I use the code above</a></p>