Visual FoxPro

Fetch ISBN XML from isbndb.com and Parse

See more HTTP Examples

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

LOCAL lnSuccess
LOCAL loHttp
LOCAL lcStrXml
LOCAL loXml
LOCAL loXml2

lnSuccess = 0

* This example assumes the Chilkat API to have been previously unlocked.
* See Global Unlock Sample for sample code.

loHttp = CreateObject('Chilkat.Http')

* The access_key in this URL is a valid access key, but limited to 100 queries per day.
* If the key does not work, it may be that others were testing and exhausted the limit.
lcStrXml = loHttp.QuickGetStr("http://isbndb.com/api/books.xml?access_key=OV8L2Y9I&results=details&index1=isbn&value1=0443074348")
IF (loHttp.LastMethodSuccess <> 1) THEN
    ? loHttp.LastErrorText
    RELEASE loHttp
    CANCEL
ENDIF

loXml = CreateObject('Chilkat.Xml')
lnSuccess = loXml.LoadXml(lcStrXml)

* 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:
lnSuccess = loXml.FirstChild2()
lnSuccess = 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:
lnSuccess = loXml.SaveXml("book.xml")

RELEASE loHttp
RELEASE loXml