(DataFlex) Fetch ISBN XML from isbndb.com and Parse

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

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

Use ChilkatAx-win32.pkg

Procedure Test
    Handle hoHttp
    String sStrXml
    Handle hoXml
    Boolean iSuccess
    Variant vXml2
    Handle hoXml2
    String sTemp1
    Boolean bTemp1

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

    Get Create (RefClass(cComChilkatHttp)) To hoHttp
    If (Not(IsComObjectCreated(hoHttp))) Begin
        Send CreateComObject of hoHttp
    End

    // 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.
    Get ComQuickGetStr Of hoHttp "http://isbndb.com/api/books.xml?access_key=OV8L2Y9I&results=details&index1=isbn&value1=0443074348" To sStrXml
    Get ComLastMethodSuccess Of hoHttp To bTemp1
    If (bTemp1 <> True) Begin
        Get ComLastErrorText Of hoHttp To sTemp1
        Showln sTemp1
        Procedure_Return
    End

    Get Create (RefClass(cComChilkatXml)) To hoXml
    If (Not(IsComObjectCreated(hoXml))) Begin
        Send CreateComObject of hoXml
    End
    Get ComLoadXml Of hoXml sStrXml To iSuccess

    // 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:
    Get ComFirstChild2 Of hoXml To iSuccess
    Get ComFirstChild2 Of hoXml To iSuccess

    // Show the Title and AuthorsText:
    Get ComGetChildContent Of hoXml "Title" To sTemp1
    Showln sTemp1
    Get ComGetChildContent Of hoXml "AuthorsText" To sTemp1
    Showln sTemp1

    // Show the publisher_id attribute of the PublisherText node:

    Get ComFindChild Of hoXml "PublisherText" To vXml2
    If (IsComObject(vXml2)) Begin
        Get Create (RefClass(cComChilkatXml)) To hoXml2
        Set pvComObject Of hoXml2 To vXml2
    End
    Get ComGetAttrValue Of hoXml2 "publisher_id" To sTemp1
    Showln sTemp1

    Send Destroy of hoXml2

    // Save the XML to a file:
    Get ComSaveXml Of hoXml "book.xml" To iSuccess


End_Procedure