VBA Code to request data from API

[matthew101]

I would greatly appreciate VBA code to submit an API request from excel to the following URL:

https://geocoding.geo.census.gov/ge...A1&benchmark=4&vintage=4&format=json&layers=8

API Response data placed below A1.

Trigger to request API can be A2=Yes.

 

[igold]

Your URL returns nothing...

 

[matthew101]

correct url:
https://geocoding.geo.census.gov/geocoder/geogaphies/onelineaddress?address=[see note below]&benchmark=4&vintage=4&format=json&layers=8

Address must be formatted as 1600+Pennsylvania+Ave+Washington+DC+20500