Question: I have the following json array which you can easily access at the below url: 

<https://crowdfluttr.firebaseio.com/test/array.json>

It has the following output: 

```
{"-0p":{"date":"2015-01-01","string":"apple","value":1},"-1p":{"date":"2015-02-04","string":"banana","value":50},"-2p":{"date":"2015-02-03","string":"carrot","value":99},"-3p":{"date":"2015-02-02","string":"banana","value":20},"-4p":{"date":"2015-03-01","string":"banana","value":11},"-5p":{"date":"2015-04-01","string":"kiwi","value":23},"-6p":{"date":"2015-05-01","strawberry":"banana","value":10}}

```

I'd like to pull this json data from this url and then parse it to push into microsoft access. 

I found resources explaining how to parse JSON ([Parsing JSON](https://stackoverflow.com/questions/30510570/parsing-json-feed-automatically-into-ms-access/35530085#35530085), [Parsing JSON in Excel VBA](https://stackoverflow.com/questions/6627652/parsing-json-in-excel-vba/7300926#7300926)) but not pull it from a URL and then parseit

Answer: 
Just in case someone stumbled on this same question but needs to send parameters first before getting the `responseText`, you will need to tweak [Axel's answer](https://stackoverflow.com/a/43625805/2685412) a bit.

```
httpObject.Open "POST", sURL, False '// instead of GET, use POST //
httpObject.SetRequestHeader "Content-Type", "Application/json" '// specify header //
httpObject.Send "{""param1"":""value1"",""param2"":""value2""}" '// pass parameter //
sGetResult = httpObject.responseText '// get response //

```

The next step is the same parsing of result using the functions provided above.
You can study the answer [here](https://stackoverflow.com/questions/38159050/vba-jsonparser-clsjsonparser-does-not-work/38159800#38159800) and then look up [VBA.CVRAPI](https://github.com/CactusData/VBA.CVRAPI) which contains all necessary Json modules to retrieve data from a URL. Though created for another purpose, the Json modules are generic and can easily be reused.

The demo form included demonstrates this. You should be able to adopt it to your URL for a test.