(PowerBuilder) 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

integer li_rc
oleobject loo_Http
string ls_StrXml
oleobject loo_Xml
integer li_Success
oleobject loo_Xml2

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

loo_Http = create oleobject
// Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0
li_rc = loo_Http.ConnectToNewObject("Chilkat.Http")
if li_rc < 0 then
    destroy loo_Http
    MessageBox("Error","Connecting to COM object failed")
    return
end if

// 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.
ls_StrXml = loo_Http.QuickGetStr("http://isbndb.com/api/books.xml?access_key=OV8L2Y9I&results=details&index1=isbn&value1=0443074348")
if loo_Http.LastMethodSuccess <> 1 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_Http
    return
end if

loo_Xml = create oleobject
// Use "Chilkat_9_5_0.Xml" for versions of Chilkat < 10.0.0
li_rc = loo_Xml.ConnectToNewObject("Chilkat.Xml")

li_Success = loo_Xml.LoadXml(ls_StrXml)

// 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:
li_Success = loo_Xml.FirstChild2()
li_Success = loo_Xml.FirstChild2()

// Show the Title and AuthorsText:
Write-Debug loo_Xml.GetChildContent("Title")
Write-Debug loo_Xml.GetChildContent("AuthorsText")

// Show the publisher_id attribute of the PublisherText node:

loo_Xml2 = loo_Xml.FindChild("PublisherText")
Write-Debug loo_Xml2.GetAttrValue("publisher_id")

destroy loo_Xml2

// Save the XML to a file:
li_Success = loo_Xml.SaveXml("book.xml")


destroy loo_Http
destroy loo_Xml