I have a spread sheet that has Lat and long in 2 separate columns, several hundred rows.
I need to submit that lat/long from each row to a web api that will return the county, state and Fips number. The web api returns the data in xml. I need to write that data to the next 3 columns on the same row.
The web api is pretty simple, http://data.fcc.gov/api/block/2010/find?latitude=40.0&longitude=-85
and returns the following
<Response status="OK" executionTime="10"><Block FIPS="181770103002004"/><County FIPS="18177" name="Wayne"/><State FIPS="18" code="IN" name="Indiana"/></Response>
Your help is appricated, I am new to web services and api. This can be in vba, .net or vb.
Thanks
John
I need to submit that lat/long from each row to a web api that will return the county, state and Fips number. The web api returns the data in xml. I need to write that data to the next 3 columns on the same row.
The web api is pretty simple, http://data.fcc.gov/api/block/2010/find?latitude=40.0&longitude=-85
and returns the following
<Response status="OK" executionTime="10"><Block FIPS="181770103002004"/><County FIPS="18177" name="Wayne"/><State FIPS="18" code="IN" name="Indiana"/></Response>
Your help is appricated, I am new to web services and api. This can be in vba, .net or vb.
Thanks
John