Access a webpage, and retrieve response.

[NightFox]

Hi all,


Via an API i need to retrieve some data from a website, given some inputs (in the URL).


For instance, the url is

http://www.website.com/API/?XML=<?xml version='1.0' ?><open-url><object_description><object_metadata_zone><issn>Cell A1</issn><title>Cell A2</title><date>Cell A3</date><__service_type>getFullTxt</__service_type></object_metadata_zone></object_description></open-url>


When i manually open this URL, the response is

[pre]<?xml version="1.0" ?>
<openurl_result>
<target>
<target_name>Chronicling America: Historic American Newspapers</target_name>
<service>getFullTxt</service>
<url>http://chroniclingamerica.loc.gov/lccn/sn82014424/issues/</url>
</target>
</openurl_result>

[/pre]
and this i have to have copied into a cell. but how can i let excel open the webaddress, and retrieve the information i need?


note: i need to do this for 8000 rows, so it has to be automated.


Thanks in advance

 

[NARAYANK991]

Hi ,


I am not able to understand the exact URL which you wish to open ; nor do I understand what information you wish to retrieve from the opened web-page.


In case you are still looking for a solution , can you explain ?


Narayan