Fetch ISBN XML from isbndb.com and Parse

Download Chilkat XML ActiveX

Demonstrates sending a query to isbndb.com and parsing the XML response.

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
Set outFile = fso.CreateTextFile("output.txt", True)

set xml0 = CreateObject("Chilkat.Xml")

'  The Chilkat XML component/class is freeware.

Set xml = xml0.HttpGet("http://isbndb.com/api/books.xml?access_key=XXXXX&results=details&index1=isbn&value1=0443074348")
If (xml Is Nothing ) Then
    MsgBox xml0.LastErrorText
    WScript.Quit
End If

'  The XML returned for this URL is the following:

'  <?xml version="1.0" encoding="UTF-8" ?>

'  <ISBNdb server_time="2007-10-25T14:07:25Z">
'      <BookList total_results="1" page_size="10" page_number="1" shown_results="1">
'          <BookData book_id="diagnostic_histopathology_of_tumors_2_volume_set_with_cd_rom" isbn="0443074348">
'              <Title>Diagnostic Histopathology of Tumors: 2-Volume Set with CD-ROMs</Title>
'              <TitleLong>Diagnostic Histopathology of Tumors: 2-Volume Set with CD-ROMs (Diagnostic Histopathology of Tumors (Fletcher))</TitleLong>
'              <AuthorsText>Christopher D. M. Fletcher (Editor)</AuthorsText>
'              <PublisherText publisher_id="churchill_livingstone">Churchill Livingstone</PublisherText>
'              <Details dewey_decimal="616" physical_description_text="2166 pages" language="" edition_info="Hardcover; 2007-03-13" dewey_decimal_normalized="616" lcc_number="" change_time="2006-12-13T14:53:42Z" price_time="2007-10-25T01:12:13Z" />
'          </BookData>
'      </BookList>
'  </ISBNdb>

'  First, navigate to the BookData node:
xml.FirstChild2 
xml.FirstChild2 

'  Show the Title and AuthorsText:
outFile.WriteLine(xml.GetChildContent("Title"))
outFile.WriteLine(xml.GetChildContent("AuthorsText"))

'  Show the publisher_id attribute of the PublisherText node:

Set xml2 = xml.FindChild("PublisherText")
outFile.WriteLine(xml2.GetAttrValue("publisher_id"))

'  Save the XML to a file:
xml.SaveXml "book.xml"


outFile.Close