Issue parsing text from long XML containing field

kaylakirzinger — Wed, 27 May 2020 21:49:21 GMT

I have several fields which has some preamble text followed by a relatively long XML. I need to parse a field out of the XML. In some cases it is working, while in others it is not.

I have tried removing the preamble text and parsing the XML using parse XML, but since only a handful of these fields contain an XML, that got very messy.

I'm parsing at a field that is cut off in the preview. The full XML is attached. I'm trying to parse at "customerCode".

Not working:

Working:

PostInvoice response = <?xml version="1.0" encoding="utf-16"?>
<Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://schemas.xmlsoap.org/soap/envelope/">
<Header />
<Body>
<VertexEnvelope xmlns="urn:vertexinc:o-series:tps:7:0">
<InvoiceResponse documentDate="2020-05-21" documentNumber="4100000012" transactionId="RC" transactionType="RENTAL">
<Seller>
<AdministrativeOrigin>
<StreetAddress1>631 S. 62nd Street</StreetAddress1>
<City>KANSAS CITY</City>
<MainDivision>KS</MainDivision>
<SubDivision>WYANDOTTE</SubDivision>
<PostalCode>66111</PostalCode>
<Country>USA</Country>
</AdministrativeOrigin>
</Seller>
<SubTotal>200.000</SubTotal>
<Total>216.500</Total>
<TotalTax>16.500</TotalTax>
<LineItem lineItemId="0.00/1.00" lineItemNumber="1" locationCode="100">
<Selle...

Invoice xml received = <?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Body>
<VertexEnvelope xmlns="urn:vertexinc:o-series:tps:7:0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="urn:vertexinc:o-series:tps:7:0 VertexInc_Envelope.xsd">
<Login>
<ns1:UserName>RENTAL</ns1:UserName>
<ns1:Password>******</ns1:Password>
</Login>
<InvoiceRequest transactionType="RENTAL" documentNumber="4000136" documentDate="2020-06-03" transactionId="RC">
<Currency isoCurrencyAlpha="USD" />
<Seller>
<AdministrativeOrigin taxAreaId="172090440">
<StreetAddress1>631 S. 62nd Street</StreetAddress1>
<City>KANSAS CITY</City>
<MainDivision>KS</MainDivision>
<SubDivision>WYANDOTTE</SubDivision>
<PostalCode>66111</PostalCode>
<Country>USA</Country>
</AdministrativeOrigin>
</Seller>
<LineItem lineItemId="1/1" lineItemNumber="1" taxDate="2020-06-03" locationCode="100" transactionType="RENTAL">
<Seller>
<Company>US</Company>
<Division>100</Division>
<Department>100</Department>
<PhysicalOrigin taxAreaId="172090440">
<StreetAddress1>631 S. 62nd Street</StreetAddress1>
<City>KANSAS CITY</City>
<MainDivision>KS</MainDivision>
<SubDivision>WYANDOTTE</SubDivision>
<PostalCode>66111</PostalCode>
<Country>USA</Country>
</PhysicalOrigin>
</Seller>
<Customer>
<CustomerCode classCode="100016">100016</CustomerCode>
<Destination taxAreaId="470130000">
<StreetAddress1>2900 12S Quincy St Ste 501c</StreetAddress1>
<City>Arlington</City>
<MainDivision>VA</MainDivision>
<SubDivision/>
<PostalCode>22206-2231</PostalCode>
<Country>USA</Country>
</Destination>
</Customer>
<Product productClass="">12000055720</Product>
<Quantity unitOfMeasure="EA">1</Quantity>
<Freight>0</Freight>
<UnitPrice>34.33</UnitPrice>
<ExtendedPrice>152.03</ExtendedPrice>
<LandedCost>0</LandedCost>
<FlexibleFields>
<FlexibleCodeField fieldId="1">100016</FlexibleCodeField>
<FlexibleCodeField fieldId="2">1003</FlexibleCodeField>
<FlexibleCodeField fieldId="3">D</FlexibleCodeField>
<FlexibleCodeField fieldId="4">D-R-0004000136-20200603</FlexibleCodeField>
<FlexibleCodeField fieldId="5">103096.1000</FlexibleCodeField>
<FlexibleNumericField fieldId="1">2020</FlexibleNumericField>
<FlexibleNumericField fieldId="2">06</FlexibleNumericField>
</FlexibleFields>
</LineItem>
<LineItem lineItemId="1/2" lineItemNumber="2" taxDate="2020-06-03" locationCode="100" transactionType="RENTAL">
<Seller>
<Company>US</Company>
<Division>100</Division>
<Department>100</Department>
<PhysicalOrigin taxAreaId="172090440">
<StreetAddress1>631 S. 62nd Street</StreetAddress1>
<City>KANSAS CITY</City>
<MainDivision>KS</MainDivision>
<SubDivision>WYANDOTTE</SubDivision>
<PostalCode>66111</PostalCode>
<Country>USA</Country>
</PhysicalOrigin>
</Seller>
<Customer>
<CustomerCode classCode="100016">100016</CustomerCode>
<Destination taxAreaId="470130000">
<StreetAddress1>2900 12S Quincy St Ste 501c</StreetAddress1>
<City>Arlington</City>
<MainDivision>VA</MainDivision>
<SubDivision/>
<PostalCode>22206-2231</PostalCode>
<Country>USA</Country>
</Destination>
</Customer>
<Product productClass="">12000923039</Product>
<Quantity unitOfMeasure="EA">1</Quantity>
<Freight>0</Freight>
<UnitPrice>23.69</UnitPrice>
<ExtendedPrice>104.91</ExtendedPrice>
<LandedCost>0</LandedCost>
<FlexibleFields>
<FlexibleCodeField fieldId="1">100016</FlexibleCodeField>
<FlexibleCodeField fieldId="2">1001</FlexibleCodeField>
<FlexibleCodeField fieldId="3">D</FlexibleCodeField>
<FlexibleCodeField fieldId="4">D-R-0004000136-20200603</FlexibleCodeField>
<FlexibleCodeField fieldId="5">103096.1000</FlexibleCodeField>
<FlexibleNumericField fieldId="1">2020</FlexibleNumericField>
<FlexibleNumericField fieldId="2">06</FlexibleNumericField>
</FlexibleFields>
</LineItem>
<LineItem lineItemId="2/1" lineItemNumber="3" taxDate="2020-06-03" locationCode="100" transactionType="RENTAL">
<Seller>
<Company>US</Company>
<Division>100</Division>
<Department>100</Department>
<PhysicalOrigin taxAreaId="172090440">
<StreetAddress1>631 S. 62nd Street</StreetAddress1>
<City>KANSAS CITY</City>
<MainDivision>KS</MainDivision>
<SubDivision>WYANDOTTE</SubDivision>
<PostalCode>66111</PostalCode>
<Country>USA</Country>
</PhysicalOrigin>
</Seller>
<Customer>
<CustomerCode classCode="100016">100016</CustomerCode>
<Destination taxAreaId="470130000">
<StreetAddress1>2900 12S Quincy St Ste 501c</StreetAddress1>
<City>Arlington</City>
<MainDivision>VA</MainDivision>
<SubDivision/>
<PostalCode>22206-2231</PostalCode>
<Country>USA</Country>
</Destination>
</Customer>
<Product productClass="">12000940129</Product>
<Quantity unitOfMeasure="EA">1</Quantity>
<Freight>0</Freight>
<UnitPrice>21.23</UnitPrice>
<ExtendedPrice>94.02</ExtendedPrice>
<LandedCost>0</LandedCost>
<FlexibleFields>
<FlexibleCodeField fieldId="1">100016</FlexibleCodeField>
<FlexibleCodeField fieldId="2">1001</FlexibleCodeField>
<FlexibleCodeField fieldId="3">D</FlexibleCodeField>
<FlexibleCodeField fieldId="4">D-R-0004000136-20200603</FlexibleCodeField>
<FlexibleCodeField fieldId="5">103096.1000</FlexibleCodeField>
<FlexibleNumericField fieldId="1">2020</FlexibleNumericField>
<FlexibleNumericField fieldId="2">06</FlexibleNumericField>
</FlexibleFields>
</LineItem>
<LineItem lineItemId="2/2" lineItemNumber="4" taxDate="2020-06-03" locationCode="100" transactionType="RENTAL">
<Seller>
<Company>US</Company>
<Division>100</Division>
<Department>100</Department>
<PhysicalOrigin taxAreaId="172090440">
<StreetAddress1>631 S. 62nd Street</StreetAddress1>
<City>KANSAS CITY</City>
<MainDivision>KS</MainDivision>
<SubDivision>WYANDOTTE</SubDivision>
<PostalCode>66111</PostalCode>
<Country>USA</Country>
</PhysicalOrigin>
</Seller>
<Customer>
<CustomerCode classCode="100016">100016</CustomerCode>
<Destination taxAreaId="470130000">
<StreetAddress1>2900 12S Quincy St Ste 501c</StreetAddress1>
<City>Arlington</City>
<MainDivision>VA</MainDivision>
<SubDivision/>
<PostalCode>22206-2231</PostalCode>
<Country>USA</Country>
</Destination>
</Customer>
<Product productClass="">12000953557</Product>
<Quantity unitOfMeasure="EA">1</Quantity>
<Freight>0</Freight>
<UnitPrice>31.83</UnitPrice>
<ExtendedPrice>140.96</ExtendedPrice>
<LandedCost>0</LandedCost>
<FlexibleFields>
<FlexibleCodeField fieldId="1">100016</FlexibleCodeField>
<FlexibleCodeField fieldId="2">1003</FlexibleCodeField>
<FlexibleCodeField fieldId="3">D</FlexibleCodeField>
<FlexibleCodeField fieldId="4">D-R-0004000136-20200603</FlexibleCodeField>
<FlexibleCodeField fieldId="5">103096.1000</FlexibleCodeField>
<FlexibleNumericField fieldId="1">2020</FlexibleNumericField>
<FlexibleNumericField fieldId="2">06</FlexibleNumericField>
</FlexibleFields>
</LineItem>
<LineItem lineItemId="3/1" lineItemNumber="5" taxDate="2020-06-03" locationCode="600" transactionType="RENTAL">
<Seller>
<Company>US</Company>
<Division>600</Division>
<Department>600</Department>
<PhysicalOrigin taxAreaId="60050024">
<StreetAddress1>15427 E. Fremont Dr.</StreetAddress1>
<City>ENGLEWOOD</City>
<MainDivision>CO</MainDivision>
<SubDivision>ARAPAHOE</SubDivision>
<PostalCode>80112</PostalCode>
<Country>USA</Country>
</PhysicalOrigin>
</Seller>
<Customer>
<CustomerCode classCode="100016">100016</CustomerCode>
<Destination taxAreaId="470130000">
<StreetAddress1>2900 12S Quincy St Ste 501c</StreetAddress1>
<City>Arlington</City>
<MainDivision>VA</MainDivision>
<SubDivision/>
<PostalCode>22206-2231</PostalCode>
<Country>USA</Country>
</Destination>
</Customer>
<Product productClass="">12000953564</Product>
<Quantity unitOfMeasure="EA">1</Quantity>
<Freight>0</Freight>
<UnitPrice>25</UnitPrice>
<ExtendedPrice>110.71</ExtendedPrice>
<LandedCost>0</LandedCost>
<FlexibleFields>
<FlexibleCodeField fieldId="1">100016</FlexibleCodeField>
<FlexibleCodeField fieldId="2">1001</FlexibleCodeField>
<FlexibleCodeField fieldId="3">D</FlexibleCodeField>
<FlexibleCodeField fieldId="4">D-R-0004000136-20200603</FlexibleCodeField>
<FlexibleCodeField fieldId="5">103040.1390</FlexibleCodeField>
<FlexibleNumericField fieldId="1">2020</FlexibleNumericField>
<FlexibleNumericField fieldId="2">06</FlexibleNumericField>
</FlexibleFields>
</LineItem>
<LineItem lineItemId="4/1" lineItemNumber="6" taxDate="2020-06-03" locationCode="600" transactionType="RENTAL">
<Seller>
<Company>US</Company>
<Division>600</Division>
<Department>600</Department>
<PhysicalOrigin taxAreaId="60050024">
<StreetAddress1>15427 E. Fremont Dr.</StreetAddress1>
<City>ENGLEWOOD</City>
<MainDivision>CO</MainDivision>
<SubDivision>ARAPAHOE</SubDivision>
<PostalCode>80112</PostalCode>
<Country>USA</Country>
</PhysicalOrigin>
</Seller>
<Customer>
<CustomerCode classCode="100016">100016</CustomerCode>
<Destination taxAreaId="470130000">
<StreetAddress1>2900 12S Quincy St Ste 501c</StreetAddress1>
<City>Arlington</City>
<MainDivision>VA</MainDivision>
<SubDivision/>
<PostalCode>22206-2231</PostalCode>
<Country>USA</Country>
</Destination>
</Customer>
<Product productClass="">12000953564</Product>
<Quantity unitOfMeasure="EA">1</Quantity>
<Freight>0</Freight>
<UnitPrice>25</UnitPrice>
<ExtendedPrice>110.71</ExtendedPrice>
<LandedCost>0</LandedCost>
<FlexibleFields>
<FlexibleCodeField fieldId="1">100016</FlexibleCodeField>
<FlexibleCodeField fieldId="2">1001</FlexibleCodeField>
<FlexibleCodeField fieldId="3">D</FlexibleCodeField>
<FlexibleCodeField fieldId="4">D-R-0004000136-20200603</FlexibleCodeField>
<FlexibleCodeField fieldId="5">103040.1390</FlexibleCodeField>
<FlexibleNumericField fieldId="1">2020</FlexibleNumericField>
<FlexibleNumericField fieldId="2">06</FlexibleNumericField>
</FlexibleFields>
</LineItem>
<LineItem lineItemId="5/1" lineItemNumber="7" taxDate="2020-06-03" locationCode="600" transactionType="RENTAL">
<Seller>
<Company>US</Company>
<Division>600</Division>
<Department>600</Department>
<PhysicalOrigin taxAreaId="60050024">
<StreetAddress1>15427 E. Fremont Dr.</StreetAddress1>
<City>ENGLEWOOD</City>
<MainDivision>CO</MainDivision>
<SubDivision>ARAPAHOE</SubDivision>
<PostalCode>80112</PostalCode>
<Country>USA</Country>
</PhysicalOrigin>
</Seller>
<Customer>
<CustomerCode classCode="100016">100016</CustomerCode>
<Destination taxAreaId="470130000">
<StreetAddress1>2900 12S Quincy St Ste 501c</StreetAddress1>
<City>Arlington</City>
<MainDivision>VA</MainDivision>
<SubDivision/>
<PostalCode>22206-2231</PostalCode>
<Country>USA</Country>
</Destination>
</Customer>
<Product productClass="">18000353390</Product>
<Quantity unitOfMeasure="EA">1</Quantity>
<Freight>0</Freight>
<UnitPrice>27.72</UnitPrice>
<ExtendedPrice>122.76</ExtendedPrice>
<LandedCost>0</LandedCost>
<FlexibleFields>
<FlexibleCodeField fieldId="1">100016</FlexibleCodeField>
<FlexibleCodeField fieldId="2">1003</FlexibleCodeField>
<FlexibleCodeField fieldId="3">D</FlexibleCodeField>
<FlexibleCodeField fieldId="4">D-R-0004000136-20200603</FlexibleCodeField>
<FlexibleCodeField fieldId="5">103040.1390</FlexibleCodeField>
<FlexibleNumericField fieldId="1">2020</FlexibleNumericField>
<FlexibleNumericField fieldId="2">06</FlexibleNumericField>
</FlexibleFields>
</LineItem>
<LineItem lineItemId="5/2" lineItemNumber="8" taxDate="2020-06-03" locationCode="600" transactionType="RENTAL">
<Seller>
<Company>US</Company>
<Division>600</Division>
<Department>600</Department>
<PhysicalOrigin taxAreaId="60050024">
<StreetAddress1>15427 E. Fremont Dr.</StreetAddress1>
<City>ENGLEWOOD</City>
<MainDivision>CO</MainDivision>
<SubDivision>ARAPAHOE</SubDivision>
<PostalCode>80112</PostalCode>
<Country>USA</Country>
</PhysicalOrigin>
</Seller>
<Customer>
<CustomerCode classCode="100016">100016</CustomerCode>
<Destination taxAreaId="470130000">
<StreetAddress1>2900 12S Quincy St Ste 501c</StreetAddress1>
<City>Arlington</City>
<MainDivision>VA</MainDivision>
<SubDivision/>
<PostalCode>22206-2231</PostalCode>
<Country>USA</Country>
</Destination>
</Customer>
<Product productClass="">18000421240</Product>
<Quantity unitOfMeasure="EA">1</Quantity>
<Freight>0</Freight>
<UnitPrice>25.25</UnitPrice>
<ExtendedPrice>111.82</ExtendedPrice>
<LandedCost>0</LandedCost>
<FlexibleFields>
<FlexibleCodeField fieldId="1">100016</FlexibleCodeField>
<FlexibleCodeField fieldId="2">1005</FlexibleCodeField>
<FlexibleCodeField fieldId="3">D</FlexibleCodeField>
<FlexibleCodeField fieldId="4">D-R-0004000136-20200603</FlexibleCodeField>
<FlexibleCodeField fieldId="5">103040.1390</FlexibleCodeField>
<FlexibleNumericField fieldId="1">2020</FlexibleNumericField>
<FlexibleNumericField fieldId="2">06</FlexibleNumericField>
</FlexibleFields>
</LineItem>
</InvoiceRequest>
</VertexEnvelope>
</soapenv:Body>
</soapenv:Envelope>

topic Issue parsing text from long XML containing field in Developer

Issue parsing text from long XML containing field