May 08
Doug Gentry Retrieving Info from XML
May 08, 2012; 12:04
Doug Gentry
Retrieving Info from XML
Hi, Folks -
I've dodged the XML bullet several times in previous projects, but no dice now.
Lasso 8.5x
I'm getting an XML response from a credit card gateway and I want to capture the value within <Page> </Page> from this
<TranxResponse>
<GatewayID>00004</GatewayID>
<ReceiptNumber>1096019995.50D2</ReceiptNumber>
<SalesOrderNumber>500</SalesOrderNumber>
<xxxName>John Smith</xxxName>
<xxxCompany>Customer Company</xxxCompany>
<xxxAddress>2201 Speers Road</xxxAddress>
<xxxCity>Buffalo</xxxCity>
<xxxState>NY</xxxState>
<xxxZipCode>123456</xxxZipCode>
<xxxCountry>US</xxxCountry>
<xxxPhone>8666388789</xxxPhone>
<xxxEmail>jsmith@customeraddress.com</xxxEmail>
<Date>2007/12/17 09:59:58</Date>
<CardType>VI</CardType>
<Page>90000</Page>
<ApprovalCode>123456</ApprovalCode>
<Verbiage> Approved</Verbiage>
<TotalAmount>1.01</TotalAmount>
<Products>
<product>
<code>PC-01</code>
<description> Test Product</description>
<quantity>1</quantity>
<price>1.01</price>
<subtotal>1.01</subtotal>
</product>
</Products>
<DoubleColonProducts>1.01::1::PC-01::Test Product::</DoubleColonProducts>
<AVSResponseCode>U</AVSResponseCode>
<CVV2ResponseCode>M</CVV2ResponseCode>
</TranxResponse>
I've got the XML response in a variable, response.
I fiddled a bit with XML_extract but got an empty array.
Any tips?
Thanks...Doug
---
Doug Gentry
Dynapolis & Southern Oregon University
p: 541-261-8501
doug@dynapolis.com
www.dynapolis.com - blog: www.plain-sense.com
#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso
Lasso@lists.lassosoft.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>
May 08
Carl Ketterling Re: Retrieving Info from XML
May 08, 2012; 14:16
Carl Ketterling
Re: Retrieving Info from XML
May 08
Steve Piercy - Web Site Builder Re: Retrieving Info from XML
May 08, 2012; 12:26
Steve Piercy - Web Site Builder
Re: Retrieving Info from XML
May 09
Rick Draper RE: Retrieving Info from XML
May 09, 2012; 05:27
Rick Draper
RE: Retrieving Info from XML
May 08
Doug Gentry Re: Retrieving Info from XML
May 08, 2012; 15:24
Doug Gentry
Re: Retrieving Info from XML