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:
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.
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.
-
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. -
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. -
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. -
Hi kubosj,
When I created my mapping it's almost the same as what you have but without the url. Its like this:
<Mappings>
<Mapping element="ShippingInfo" outPort="0">
</Mapping>
</Mappings>
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:
<Mappings>
</Mappings>
I don't know why its doing that. Please help.
Thanks. -
Hi,
which version of Designer you use?
There are some issues with lost mapping reported in our jira.
Please sign in to leave a comment.
Comments 5