Xml extract component not working

CloverDX Platform
1

Hi,

I’ve been using the xml extract component before and I’d never had a problem with it. However, I was using it today and I ran into an issue that I’ve been trying to figure out the whole day. I have an xml file, its a response from a soap request and its like this:


<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
   <soap:Body>
      <GetOrderListResponse xmlns="http://api.channeladvisor.com/webservices/">
         <GetOrderListResult>
            <Status>Success</Status>
            <MessageCode>0</MessageCode>
            <ResultData>
               <OrderResponseItem xsi:type="q1:OrderResponseDetailComplete" xmlns:q1="http://api.channeladvisor.com/datacontracts/orders">
                  <q1:NumberOfMatches>2</q1:NumberOfMatches>
                  <q1:OrderTimeGMT>2012-03-16T04:57:32.503</q1:OrderTimeGMT>
                  <q1:LastUpdateDate>2012-03-16T04:58:54.463</q1:LastUpdateDate>
                  <q1:TotalOrderAmount>47.9000</q1:TotalOrderAmount>
                  <q1:OrderState>Active</q1:OrderState>
                  <q1:DateCancelledGMT xsi:nil="true"/>
                  <q1:OrderID>10721618</q1:OrderID>
                  <q1:ClientOrderIdentifier>10721618</q1:ClientOrderIdentifier>
                  <q1:SellerOrderID/>
                  <q1:OrderStatus>
                     <q1:CheckoutStatus>Completed</q1:CheckoutStatus>
                     <q1:CheckoutDateGMT>2012-03-16T04:58:54</q1:CheckoutDateGMT>
                     <q1:PaymentStatus>Submitted</q1:PaymentStatus>
                     <q1:PaymentDateGMT>2012-03-16T04:58:54</q1:PaymentDateGMT>
                     <q1:ShippingStatus>Unshipped</q1:ShippingStatus>
                     <q1:ShippingDateGMT>1900-01-01T00:00:00</q1:ShippingDateGMT>
                     <q1:OrderRefundStatus>NoRefunds</q1:OrderRefundStatus>
                  </q1:OrderStatus>
                  <q1:ResellerID/>
                  <q1:BuyerEmailAddress>example@test.com</q1:BuyerEmailAddress>
                  <q1:EmailOptIn>false</q1:EmailOptIn>
                  <q1:PaymentInfo>
                     <q1:PaymentType>Personal Check</q1:PaymentType>
                     <q1:CreditCardLast4/>
                     <q1:PayPalID/>
                     <q1:MerchantReferenceNumber/>
                     <q1:PaymentTransactionID/>
                  </q1:PaymentInfo>
                  <q1:ShippingInfo>
                     <q1:AddressLine1>test</q1:AddressLine1>
                     <q1:AddressLine2/>
                     <q1:City>test</q1:City>
                     <q1:Region>UT</q1:Region>
                     <q1:RegionDescription>Utah</q1:RegionDescription>
                     <q1:PostalCode>11212</q1:PostalCode>
                     <q1:CountryCode>US</q1:CountryCode>
                     <q1:CompanyName/>
                     <q1:JobTitle/>
                     <q1:Title>Mr.</q1:Title>
                     <q1:FirstName>test</q1:FirstName>
                     <q1:LastName>test</q1:LastName>
                     <q1:Suffix/>
                     <q1:PhoneNumberDay>(877) 123-4567</q1:PhoneNumberDay>
                     <q1:PhoneNumberEvening/>
                     <q1:ShipmentList>
                        <q1:Shipment>
                           <q1:ShippingCarrier>FedEx</q1:ShippingCarrier>
                           <q1:ShippingClass>2 Day</q1:ShippingClass>
                           <q1:TrackingNumber/>
                        </q1:Shipment>
                     </q1:ShipmentList>
                     <q1:ShippingInstructions/>
                     <q1:EstimatedShipDate xsi:nil="true"/>
                     <q1:DeliveryDate xsi:nil="true"/>
                  </q1:ShippingInfo>
                  <q1:BillingInfo>
                     <q1:AddressLine1/>
                     <q1:AddressLine2/>
                     <q1:City/>
                     <q1:Region/>
                     <q1:RegionDescription/>
                     <q1:PostalCode/>
                     <q1:CountryCode></q1:CountryCode>
                     <q1:CompanyName/>
                     <q1:JobTitle/>
                     <q1:Title/>
                     <q1:FirstName/>
                     <q1:LastName/>
                     <q1:Suffix/>
                     <q1:PhoneNumberDay/>
                     <q1:PhoneNumberEvening/>
                  </q1:BillingInfo>
                  <q1:FlagDescription/>
                  <q1:ShoppingCart>
                     <q1:CartID>10721618</q1:CartID>
                     <q1:CheckoutSource>Unspecified</q1:CheckoutSource>
                     <q1:VATTaxCalculationOption>Unspecified</q1:VATTaxCalculationOption>
                     <q1:VATShippingOption>Unspecified</q1:VATShippingOption>
                     <q1:VATGiftWrapOption>Unspecified</q1:VATGiftWrapOption>
                     <q1:LineItemSKUList>
                        <q1:OrderLineItemItem xsi:type="q1:OrderLineItemItemResponse">
                           <q1:LineItemType>SKU</q1:LineItemType>
                           <q1:UnitPrice>37.9000</q1:UnitPrice>
                           <q1:LineItemID>11742511</q1:LineItemID>
                           <q1:AllowNegativeQuantity>false</q1:AllowNegativeQuantity>
                           <q1:Quantity>1</q1:Quantity>
                           <q1:ItemSaleSource>CHANNELADVISOR_STORE</q1:ItemSaleSource>
                           <q1:SKU>1000739664</q1:SKU>
                           <q1:Title>Title</q1:Title>
                           <q1:BuyerUserID>example@test.com</q1:BuyerUserID>
                           <q1:BuyerFeedbackRating>0</q1:BuyerFeedbackRating>
                           <q1:SalesSourceID>32192104</q1:SalesSourceID>
                           <q1:VATRate>0</q1:VATRate>
                           <q1:TaxCost>0.0000</q1:TaxCost>
                           <q1:ShippingCost>0.0000</q1:ShippingCost>
                           <q1:ShippingTaxCost>0.0000</q1:ShippingTaxCost>
                           <q1:GiftWrapCost>0.0000</q1:GiftWrapCost>
                           <q1:GiftWrapTaxCost>0.0000</q1:GiftWrapTaxCost>
                           <q1:GiftMessage/>
                           <q1:GiftWrapLevel/>
                           <q1:RecyclingFee>0.0000</q1:RecyclingFee>
                           <q1:UnitWeight UnitOfMeasure="LB">0</q1:UnitWeight>
                           <q1:WarehouseLocation/>
                           <q1:UserName/>
                           <q1:DistributionCenterCode>Pembroke Pines</q1:DistributionCenterCode>
                           <q1:IsFBA>false</q1:IsFBA>
                        </q1:OrderLineItemItem>
                     </q1:LineItemSKUList>
                     <q1:LineItemInvoiceList>
                        <q1:OrderLineItemInvoice>
                           <q1:LineItemType>SalesTax</q1:LineItemType>
                           <q1:UnitPrice>0.0000</q1:UnitPrice>
                        </q1:OrderLineItemInvoice>
                        <q1:OrderLineItemInvoice>
                           <q1:LineItemType>Shipping</q1:LineItemType>
                           <q1:UnitPrice>10.0000</q1:UnitPrice>
                        </q1:OrderLineItemInvoice>
                        <q1:OrderLineItemInvoice>
                           <q1:LineItemType>ShippingInsurance</q1:LineItemType>
                           <q1:UnitPrice>0.0000</q1:UnitPrice>
                        </q1:OrderLineItemInvoice>
                        <q1:OrderLineItemInvoice>
                           <q1:LineItemType>VATShipping</q1:LineItemType>
                           <q1:UnitPrice>0.0000</q1:UnitPrice>
                        </q1:OrderLineItemInvoice>
                        <q1:OrderLineItemInvoice>
                           <q1:LineItemType>GiftWrap</q1:LineItemType>
                           <q1:UnitPrice>0.0000</q1:UnitPrice>
                        </q1:OrderLineItemInvoice>
                        <q1:OrderLineItemInvoice>
                           <q1:LineItemType>VATGiftWrap</q1:LineItemType>
                           <q1:UnitPrice>0.0000</q1:UnitPrice>
                        </q1:OrderLineItemInvoice>
                        <q1:OrderLineItemInvoice>
                           <q1:LineItemType>RecyclingFee</q1:LineItemType>
                           <q1:UnitPrice>0.0000</q1:UnitPrice>
                        </q1:OrderLineItemInvoice>
                     </q1:LineItemInvoiceList>
                     <q1:LineItemPromoList>
                        <q1:OrderLineItemPromo>
                           <q1:LineItemType>Promotion</q1:LineItemType>
                           <q1:UnitPrice>0.0000</q1:UnitPrice>
                           <q1:PromoCode/>
                        </q1:OrderLineItemPromo>
                     </q1:LineItemPromoList>
                  </q1:ShoppingCart>
                  <q1:CustomValueList>
                     <q1:CustomValue>
                        <q1:ID>110</q1:ID>
                        <q1:Value/>
                     </q1:CustomValue>
                     <q1:CustomValue>
                        <q1:ID>111</q1:ID>
                        <q1:Value/>
                     </q1:CustomValue>
                     <q1:CustomValue>
                        <q1:ID>112</q1:ID>
                        <q1:Value/>
                     </q1:CustomValue>
                     <q1:CustomValue>
                        <q1:ID>113</q1:ID>
                        <q1:Value/>
                     </q1:CustomValue>
                     <q1:CustomValue>
                        <q1:ID>114</q1:ID>
                        <q1:Value/>
                     </q1:CustomValue>
                  </q1:CustomValueList>
                  <q1:BuyerIpAddress>172.20.70.10</q1:BuyerIpAddress>
                  <q1:TransactionNotes/>
               </OrderResponseItem>
               <OrderResponseItem xsi:type="q2:OrderResponseDetailComplete" xmlns:q2="http://api.channeladvisor.com/datacontracts/orders">
                  <q2:NumberOfMatches>2</q2:NumberOfMatches>
                  <q2:OrderTimeGMT>2012-03-16T05:01:15.013</q2:OrderTimeGMT>
                  <q2:LastUpdateDate>2012-03-16T05:51:01.257</q2:LastUpdateDate>
                  <q2:TotalOrderAmount>190.6000</q2:TotalOrderAmount>
                  <q2:OrderState>Active</q2:OrderState>
                  <q2:DateCancelledGMT xsi:nil="true"/>
                  <q2:OrderID>10721628</q2:OrderID>
                  <q2:ClientOrderIdentifier>10721628</q2:ClientOrderIdentifier>
                  <q2:SellerOrderID/>
                  <q2:OrderStatus>
                     <q2:CheckoutStatus>Completed</q2:CheckoutStatus>
                     <q2:CheckoutDateGMT>2012-03-16T05:51:00</q2:CheckoutDateGMT>
                     <q2:PaymentStatus>Submitted</q2:PaymentStatus>
                     <q2:PaymentDateGMT>2012-03-16T05:51:00</q2:PaymentDateGMT>
                     <q2:ShippingStatus>Unshipped</q2:ShippingStatus>
                     <q2:ShippingDateGMT>1900-01-01T00:00:00</q2:ShippingDateGMT>
                     <q2:OrderRefundStatus>NoRefunds</q2:OrderRefundStatus>
                  </q2:OrderStatus>
                  <q2:ResellerID/>
                  <q2:BuyerEmailAddress>johndoe@example.com</q2:BuyerEmailAddress>
                  <q2:EmailOptIn>false</q2:EmailOptIn>
                  <q2:PaymentInfo>
                     <q2:PaymentType></q2:PaymentType>
                     <q2:CreditCardLast4/>
                     <q2:PayPalID/>
                     <q2:MerchantReferenceNumber/>
                     <q2:PaymentTransactionID/>
                  </q2:PaymentInfo>
                  <q2:ShippingInfo>
                     <q2:AddressLine1>test</q2:AddressLine1>
                     <q2:AddressLine2/>
                     <q2:City>test</q2:City>
                     <q2:Region>TX</q2:Region>
                     <q2:RegionDescription>Texas</q2:RegionDescription>
                     <q2:PostalCode>11212</q2:PostalCode>
                     <q2:CountryCode>US</q2:CountryCode>
                     <q2:CompanyName/>
                     <q2:JobTitle/>
                     <q2:Title>Mr.</q2:Title>
                     <q2:FirstName>John</q2:FirstName>
                     <q2:LastName>Doe</q2:LastName>
                     <q2:Suffix/>
                     <q2:PhoneNumberDay>877-123-4567</q2:PhoneNumberDay>
                     <q2:PhoneNumberEvening/>
                     <q2:ShipmentList>
                        <q2:Shipment>
                           <q2:ShippingCarrier>UPS</q2:ShippingCarrier>
                           <q2:ShippingClass>Next Day Air</q2:ShippingClass>
                           <q2:TrackingNumber/>
                        </q2:Shipment>
                     </q2:ShipmentList>
                     <q2:ShippingInstructions/>
                     <q2:EstimatedShipDate xsi:nil="true"/>
                     <q2:DeliveryDate xsi:nil="true"/>
                  </q2:ShippingInfo>
                  <q2:BillingInfo>
                     <q2:AddressLine1/>
                     <q2:AddressLine2/>
                     <q2:City/>
                     <q2:Region/>
                     <q2:RegionDescription/>
                     <q2:PostalCode/>
                     <q2:CountryCode></q2:CountryCode>
                     <q2:CompanyName/>
                     <q2:JobTitle/>
                     <q2:Title/>
                     <q2:FirstName/>
                     <q2:LastName/>
                     <q2:Suffix/>
                     <q2:PhoneNumberDay/>
                     <q2:PhoneNumberEvening/>
                  </q2:BillingInfo>
                  <q2:FlagDescription/>
                  <q2:ShoppingCart>
                     <q2:CartID>10721628</q2:CartID>
                     <q2:CheckoutSource>Unspecified</q2:CheckoutSource>
                     <q2:VATTaxCalculationOption>Unspecified</q2:VATTaxCalculationOption>
                     <q2:VATShippingOption>Unspecified</q2:VATShippingOption>
                     <q2:VATGiftWrapOption>Unspecified</q2:VATGiftWrapOption>
                     <q2:LineItemSKUList>
                        <q2:OrderLineItemItem xsi:type="q2:OrderLineItemItemResponse">
                           <q2:LineItemType>SKU</q2:LineItemType>
                           <q2:UnitPrice>30.9000</q2:UnitPrice>
                           <q2:LineItemID>11742519</q2:LineItemID>
                           <q2:AllowNegativeQuantity>false</q2:AllowNegativeQuantity>
                           <q2:Quantity>1</q2:Quantity>
                           <q2:ItemSaleSource>CHANNELADVISOR_STORE</q2:ItemSaleSource>
                           <q2:SKU></q2:SKU>
                           <q2:Title>Title</q2:Title>
                           <q2:BuyerUserID></q2:BuyerUserID>
                           <q2:BuyerFeedbackRating>0</q2:BuyerFeedbackRating>
                           <q2:SalesSourceID>32192105</q2:SalesSourceID>
                           <q2:VATRate>0</q2:VATRate>
                           <q2:TaxCost>0.0000</q2:TaxCost>
                           <q2:ShippingCost>0.0000</q2:ShippingCost>
                           <q2:ShippingTaxCost>0.0000</q2:ShippingTaxCost>
                           <q2:GiftWrapCost>0.0000</q2:GiftWrapCost>
                           <q2:GiftWrapTaxCost>0.0000</q2:GiftWrapTaxCost>
                           <q2:GiftMessage/>
                           <q2:GiftWrapLevel/>
                           <q2:RecyclingFee>0.0000</q2:RecyclingFee>
                           <q2:UnitWeight UnitOfMeasure="LB">0</q2:UnitWeight>
                           <q2:WarehouseLocation/>
                           <q2:UserName/>
                           <q2:DistributionCenterCode>Pembroke Pines</q2:DistributionCenterCode>
                           <q2:IsFBA>false</q2:IsFBA>
                        </q2:OrderLineItemItem>
                        <q2:OrderLineItemItem xsi:type="q2:OrderLineItemItemResponse">
                           <q2:LineItemType>SKU</q2:LineItemType>
                           <q2:UnitPrice>39.9000</q2:UnitPrice>
                           <q2:LineItemID>11742520</q2:LineItemID>
                           <q2:AllowNegativeQuantity>false</q2:AllowNegativeQuantity>
                           <q2:Quantity>3</q2:Quantity>
                           <q2:ItemSaleSource>CHANNELADVISOR_STORE</q2:ItemSaleSource>
                           <q2:SKU>1000739691</q2:SKU>
                           <q2:Title>Title for ABC870</q2:Title>
                           <q2:BuyerUserID>johndoe@example.com</q2:BuyerUserID>
                           <q2:BuyerFeedbackRating>0</q2:BuyerFeedbackRating>
                           <q2:SalesSourceID>32192106</q2:SalesSourceID>
                           <q2:VATRate>0</q2:VATRate>
                           <q2:TaxCost>0.0000</q2:TaxCost>
                           <q2:ShippingCost>0.0000</q2:ShippingCost>
                           <q2:ShippingTaxCost>0.0000</q2:ShippingTaxCost>
                           <q2:GiftWrapCost>0.0000</q2:GiftWrapCost>
                           <q2:GiftWrapTaxCost>0.0000</q2:GiftWrapTaxCost>
                           <q2:GiftMessage/>
                           <q2:GiftWrapLevel/>
                           <q2:RecyclingFee>0.0000</q2:RecyclingFee>
                           <q2:UnitWeight UnitOfMeasure="LB">0</q2:UnitWeight>
                           <q2:WarehouseLocation/>
                           <q2:UserName/>
                           <q2:DistributionCenterCode>Pembroke Pines</q2:DistributionCenterCode>
                           <q2:IsFBA>false</q2:IsFBA>
                        </q2:OrderLineItemItem>
                     </q2:LineItemSKUList>
                     <q2:LineItemInvoiceList>
                        <q2:OrderLineItemInvoice>
                           <q2:LineItemType>SalesTax</q2:LineItemType>
                           <q2:UnitPrice>0.0000</q2:UnitPrice>
                        </q2:OrderLineItemInvoice>
                        <q2:OrderLineItemInvoice>
                           <q2:LineItemType>Shipping</q2:LineItemType>
                           <q2:UnitPrice>40.0000</q2:UnitPrice>
                        </q2:OrderLineItemInvoice>
                        <q2:OrderLineItemInvoice>
                           <q2:LineItemType>ShippingInsurance</q2:LineItemType>
                           <q2:UnitPrice>0.0000</q2:UnitPrice>
                        </q2:OrderLineItemInvoice>
                        <q2:OrderLineItemInvoice>
                           <q2:LineItemType>VATShipping</q2:LineItemType>
                           <q2:UnitPrice>0.0000</q2:UnitPrice>
                        </q2:OrderLineItemInvoice>
                        <q2:OrderLineItemInvoice>
                           <q2:LineItemType>GiftWrap</q2:LineItemType>
                           <q2:UnitPrice>0.0000</q2:UnitPrice>
                        </q2:OrderLineItemInvoice>
                        <q2:OrderLineItemInvoice>
                           <q2:LineItemType>VATGiftWrap</q2:LineItemType>
                           <q2:UnitPrice></q2:UnitPrice>
                        </q2:OrderLineItemInvoice>
                        <q2:OrderLineItemInvoice>
                           <q2:LineItemType></q2:LineItemType>
                           <q2:UnitPrice></q2:UnitPrice>
                        </q2:OrderLineItemInvoice>
                     </q2:LineItemInvoiceList>
                     <q2:LineItemPromoList>
                        <q2:OrderLineItemPromo>
                           <q2:LineItemType>Promotion</q2:LineItemType>
                           <q2:UnitPrice></q2:UnitPrice>
                           <q2:PromoCode/>
                        </q2:OrderLineItemPromo>
                     </q2:LineItemPromoList>
                  </q2:ShoppingCart>
                  <q2:CustomValueList>
                     <q2:CustomValue>
                        <q2:ID></q2:ID>
                        <q2:Value/>
                     </q2:CustomValue>
                     <q2:CustomValue>
                        <q2:ID></q2:ID>
                        <q2:Value/>
                     </q2:CustomValue>
                     <q2:CustomValue>
                        <q2:ID></q2:ID>
                        <q2:Value/>
                     </q2:CustomValue>
                     <q2:CustomValue>
                        <q2:ID></q2:ID>
                        <q2:Value/>
                     </q2:CustomValue>
                     <q2:CustomValue>
                        <q2:ID></q2:ID>
                        <q2:Value/>
                     </q2:CustomValue>
                  </q2:CustomValueList>
                  <q2:BuyerIpAddress></q2:BuyerIpAddress>
                  <q2:TransactionNotes/>
               </OrderResponseItem>
            </ResultData>
         </GetOrderListResult>
      </GetOrderListResponse>
   </soap:Body>
</soap:Envelope>

I used the xml extract component to read it in then generated the xsd using the button found on the component itself. I then proceed in mapping the elements. However, when I ran my graph it says successful but its not pulling any records from my xml file. I’m not sure what’s going on. Please help. Thanks.

2

Hi noob27,

on my 3.2.1, proper XSD is generated and when I prepare some mapping, it produces records on edges. So I would guess you have problem in your mapping. Please send me your graph.

3

Hi Kubusj,

Thanks for the quick response.

I’ve attached my xml data source and the sample graph I’ve made that doesn’t show records on the edge. It runs successfully but doesn’t pass any record on the output port.

4

Hi noob27,

I don’t know how you created your mapping, but from my wizard was exported:


<Mappings>
	<Mapping element="{http://api.channeladvisor.com/datacontracts/orders}ShippingInfo" outPort="0">
	</Mapping>
</Mappings>

…which works.

5

Hi kubosj,

When I created my mapping it’s almost the same as what you have but without the url. Its like this:

I copy pasted your code to my source tab in my xml extract component but it doesn’t work. When I click on OK then went back in to the component it changes it back to just:

I don’t know why its doing that. Please help.

Thanks.

6

Hi,

which version of Designer you use?

There are some issues with lost mapping reported in our jira.