Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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><ns1: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" xmlns:ns1="urn:vertexinc:o-series:tps:7:0"><ns1:Login><ns1:UserName>RENTAL</ns1:UserName><ns1:Password>*******</ns1:Password></ns1:Login><ns1:InvoiceRequest documentDate="2020-01-10" documentNumber="8100000005" transactionId="RI" transactionType="RENTAL"><ns1:Currency isoCurrencyAlpha="USD"/><ns1:Seller><ns1:AdministrativeOrigin taxAreaId="172090440"><ns1:StreetAddress1>631 S. 62nd Street</ns1:StreetAddress1><ns1:City>KANSAS CITY</ns1:City><ns1:MainDivision>KS</ns1:MainDivision><ns1:SubDivision>WYANDOTTE</ns1:SubDivision><ns1:PostalCode>66111</ns1:PostalCode><ns1:Country>USA</n... |
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>
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
1 | |
1 | |
1 |