Witango-Talk: Need help with XML parsing probably simple

Dan Stein Fri, 16 Jun 2006 11:30:47 -0700

Sorry here is the attachment

This attached is the XML returned from USPS after I send a rate request.

I just need one of two things

At least to get in a one column array the postage. It always comes back in the same order so I can easily grab what I want from even the one column array.
An added bonus would be to have a two column array one with the method svcDescription

I think all I have messed up is the child declarations

I am trying

<@ASSIGN request$Total_Array value=<@ARRAY rows=10 cols=1>>

<@FOR start=1 stop=10>

<@ASSIGN request$Total_Array[<@CURROW>,1] <@ELEMENTVALUE object=request$result element=root().child(1).child(2).child(<@CALC <@CURROW>>).Child(5) type=text>>

</@FOR>

Boy is this easier in FileMaker I just need the element name Postage and the occurrence to get the value.

Anyway any help would be much appreciated.

<?xml version="1.0"?>
<IntlRateResponse>
    <Package ID="0">
        <Prohibitions>
		</Prohibitions>
        <Restrictions>
		</Restrictions>
        <Observations>
		</Observations>
        <CustomsForms>
		</CustomsForms>
        <ExpressMail>C
		</ExpressMail>
        <AreasServed>Please reference Express Mail for Areas Served.</AreasServed>
        <Service ID="0">
            <Pounds>1</Pounds>
            <Ounces>0</Ounces>
            <MailType>Package</MailType>
            <Country>FRANCE</Country>
            <Postage>41</Postage>
            <SvcCommitments>2 - 3 Days</SvcCommitments>
            <SvcDescription>Global Express Guaranteed Document Service</SvcDescription>
            <MaxDimensions>Max. length 46", width 35", height 46" and max. length plus girth 108"</MaxDimensions>
            <MaxWeight>70</MaxWeight>
        </Service>
        <Service ID="1">
            <Pounds>1</Pounds>
            <Ounces>0</Ounces>
            <MailType>Package</MailType>
            <Country>FRANCE</Country>
            <Postage>46.5</Postage>
            <SvcCommitments>2 - 3 Days</SvcCommitments>
            <SvcDescription>Global Express Guaranteed Non-Document Service</SvcDescription>
            <MaxDimensions>Max. length 46", width 35", height 46" and max. length plus girth 108"</MaxDimensions>
            <MaxWeight>70</MaxWeight>
        </Service>
        <Service ID="2">
            <Pounds>1</Pounds>
            <Ounces>0</Ounces>
            <MailType>Package</MailType>
            <Country>FRANCE</Country>
            <Postage>27.4</Postage>
            <SvcCommitments>3 - 5 Days</SvcCommitments>
            <SvcDescription>Global Express Mail (EMS)</SvcDescription>
            <MaxDimensions>Max.length 60", max. length plus girth 108"</MaxDimensions>
            <MaxWeight>66</MaxWeight>
        </Service>
        <Service ID="3">
            <Pounds>1</Pounds>
            <Ounces>0</Ounces>
            <MailType>Package</MailType>
            <Country>FRANCE</Country>
            <Postage>9.5</Postage>
            <SvcCommitments>4 - 6 Days</SvcCommitments>
            <SvcDescription>Global Priority Mail - Flat-rate Envelope (Large)</SvcDescription>
            <MaxDimensions>9-1/2" x 12-1/2"</MaxDimensions>
            <MaxWeight>4</MaxWeight>
        </Service>
        <Service ID="4">
            <Pounds>1</Pounds>
            <Ounces>0</Ounces>
            <MailType>Package</MailType>
            <Country>FRANCE</Country>
            <Postage>5.25</Postage>
            <SvcCommitments>4 - 6 Days</SvcCommitments>
            <SvcDescription>Global Priority Mail - Flat-rate Envelope (Small)</SvcDescription>
            <MaxDimensions>6" x 10"</MaxDimensions>
            <MaxWeight>4</MaxWeight>
        </Service>
        <Service ID="5">
            <Pounds>1</Pounds>
            <Ounces>0</Ounces>
            <MailType>Package</MailType>
            <Country>FRANCE</Country>
            <Postage>10.5</Postage>
            <SvcCommitments>4 - 6 Days</SvcCommitments>
            <SvcDescription>Global Priority Mail - Variable Weight (Single)</SvcDescription>
            <MaxDimensions>Max. length 24", Max. length, height, depth combined 36"</MaxDimensions>
            <MaxWeight>4</MaxWeight>
        </Service>
        <Service ID="6">
            <Pounds>1</Pounds>
            <Ounces>0</Ounces>
            <MailType>Package</MailType>
            <Country>FRANCE</Country>
            <Postage>9.15</Postage>
            <SvcCommitments>4 - 7 Days</SvcCommitments>
            <SvcDescription>Airmail Letter Post</SvcDescription>
            <MaxDimensions>Max. length 24", Max. length, height, depth combined 36"</MaxDimensions>
            <MaxWeight>4</MaxWeight>
        </Service>
        <Service ID="7">
            <Pounds>1</Pounds>
            <Ounces>0</Ounces>
            <MailType>Package</MailType>
            <Country>FRANCE</Country>
            <Postage>17.5</Postage>
            <SvcCommitments>4 - 10 Days</SvcCommitments>
            <SvcDescription>Airmail Parcel Post</SvcDescription>
            <MaxDimensions>Max.length 60", max. length plus girth 108"</MaxDimensions>
            <MaxWeight>66</MaxWeight>
        </Service>
        <Service ID="8">
            <Pounds>1</Pounds>
            <Ounces>0</Ounces>
            <MailType>Package</MailType>
            <Country>FRANCE</Country>
            <Postage>4.1</Postage>
            <SvcCommitments>4 - 6 Weeks</SvcCommitments>
            <SvcDescription>Economy (Surface) Letter Post</SvcDescription>
            <MaxDimensions>Max. length 24", Max. length, height, depth combined 36"</MaxDimensions>
            <MaxWeight>4</MaxWeight>
        </Service>
        <Service ID="9">
            <Pounds>1</Pounds>
            <Ounces>0</Ounces>
            <MailType>Package</MailType>
            <Country>FRANCE</Country>
            <Postage>19.25</Postage>
            <SvcCommitments>4 - 6 Weeks</SvcCommitments>
            <SvcDescription>Economy (Surface) Parcel Post</SvcDescription>
            <MaxDimensions>Max.length 42", max. length plus girth 79"</MaxDimensions>
            <MaxWeight>66</MaxWeight>
        </Service>
    </Package>
</IntlRateResponse>

________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: Need help with XML parsing probably simple

Reply via email to