Fetch ISBN XML from isbndb.com and Parse

Download Chilkat XML ActiveX

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

LOCAL loXml0
LOCAL loXml
LOCAL loXml2

loXml0 = CreateObject('Chilkat.Xml')

*  The Chilkat XML component/class is freeware.

loXml = loXml0.HttpGet("http://isbndb.com/api/books.xml?access_key=XXXXX&results=details&index1=isbn&value1=0443074348")
IF (loXml = NULL ) THEN
    =MESSAGEBOX(loXml0.LastErrorText)
    QUIT
ENDIF

*  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:
loXml.FirstChild2()
loXml.FirstChild2()

*  Show the Title and AuthorsText:
? loXml.GetChildContent("Title")
? loXml.GetChildContent("AuthorsText")

*  Show the publisher_id attribute of the PublisherText node:

loXml2 = loXml.FindChild("PublisherText")
? loXml2.GetAttrValue("publisher_id")

RELEASE loXml2

*  Save the XML to a file:
loXml.SaveXml("book.xml")

RELEASE loXml