Skip to main content

Success Path in XML Lookups

Comments

9 comments

  • Anirudh Sundaram Senior Integration Engineer
    Engaged
    Great Answer

    Hi Hristina,

    You will need to account for the namespaces.

    Resource path -
    /*[local-name()='OrderDto']

    Success path -
    /*[local-name()='OrderDto']/*[name()='diffgr:diffgram']/*[local-name()='OrderDto']/*[local-name()='Order']/*[local-name()='OrderId']

     

    Thanks,

    Anirudh

    2
  • Stephen Brandt Documentation Manager Community moderator
    Engaged
    Great Answer
    Top Contributor
    Celigo University Level 3: Master

    Hi, Hristina Bendeva.

    Could you try using a virgule (/) to build the path instead of JSON dot (.) notation?

    /OrderDto/diffgr:diffgram/OrderDto/Order/OrderId

    Please see the XPATH examples in HTTP exports > Non-standard API response patterns.

     

    0
  • Hristina Bendeva NetSuite Integration Whiz
    Awesome Follow-up
    Engaged
    Celigo University Level 4: Legendary

    Hi Stephen Brandt ,

    I have tried using a virgule (/) instead of a JSON dot (.) but it still doesn't work. I'm not sure if I should base the path on the XML structure that the API is returning or the parsed JSON that I get in the integrator.io? Also I'm not sure if the diffgr:diffgram element is making a problem because of the : in the name. And I don't know if I'm getting the same XML structure here that I get from the API in postman, or if the integrator.io changes it in some way? 

    Thanks,

    0
  • Matt Graney VP of Product Management
    Answer Pro
    Top Contributor

    Hi Hristina Bendeva,

    Can you show us the full content of the "HTTP response | Body" and "Parsed output" panels, please? Please redact/mask any sensitive fields.

    Thanks,
    Matt

     

    0
  • Hristina Bendeva NetSuite Integration Whiz
    Awesome Follow-up
    Engaged
    Celigo University Level 4: Legendary

    Hello Matt Graney,

    Here is the "HTTP response | Body" panel.

    <?xml version="1.0" encoding="utf-8"?>
    <OrderDto xmlns="http://www.apidomain.com/ECFServices/">
    <xs:schema id="OrderDto" targetNamespace="http://tempuri.org/OrderDto.xsd" xmlns:mstns="http://tempuri.org/OrderDto.xsd" xmlns="http://tempuri.org/OrderDto.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified">
    <xs:element name="OrderDto" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
    <xs:complexType>
    <xs:choice minOccurs="0" maxOccurs="unbounded">
    <xs:element name="Order">
    <xs:complexType>
    <xs:sequence>
    <xs:element name="OrderId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementStep="-1" type="xs:int" />
    <xs:element name="Email">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="255" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="SubTotal" type="xs:decimal" />
    <xs:element name="PaymentType" type="xs:int" minOccurs="0" />
    <xs:element name="CreditCardType" type="xs:int" minOccurs="0" />
    <xs:element name="CreditCardName" type="xs:string" minOccurs="0" />
    <xs:element name="CreditCardNumber" type="xs:string" minOccurs="0" />
    <xs:element name="CreditCardExpired" type="xs:string" minOccurs="0" />
    <xs:element name="CustomerDiscount" type="xs:decimal" />
    <xs:element name="Processed" type="xs:boolean" />
    <xs:element name="BillingAddressId" type="xs:int" minOccurs="0" />
    <xs:element name="CustomerId" type="xs:int" minOccurs="0" />
    <xs:element name="Created" type="xs:dateTime" />
    <xs:element name="Completed" type="xs:dateTime" minOccurs="0" />
    <xs:element name="ShippingCost" type="xs:decimal" />
    <xs:element name="CurrencyId">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="3" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="CreditCardCSC" type="xs:string" minOccurs="0" />
    <xs:element name="AffiliateId" type="xs:int" minOccurs="0" />
    <xs:element name="AffiliatePercent" type="xs:int" minOccurs="0" />
    <xs:element name="BankAccountNumber" type="xs:string" minOccurs="0" />
    <xs:element name="BankRoutingNumber" type="xs:string" minOccurs="0" />
    <xs:element name="BankAccountType" type="xs:string" minOccurs="0" />
    <xs:element name="BankName" type="xs:string" minOccurs="0" />
    <xs:element name="BankAccountName" type="xs:string" minOccurs="0" />
    <xs:element name="LicenseNumber" type="xs:string" minOccurs="0" />
    <xs:element name="LicenseDOB" type="xs:dateTime" minOccurs="0" />
    <xs:element name="LicenseState" type="xs:string" minOccurs="0" />
    <xs:element name="CheckNumber" type="xs:string" minOccurs="0" />
    <xs:element name="Tax" type="xs:decimal" minOccurs="0" />
    <xs:element name="TextResponse" type="xs:string" minOccurs="0" />
    <xs:element name="AuthorizationCode" type="xs:string" minOccurs="0" />
    <xs:element name="ConfirmationCode" type="xs:string" minOccurs="0" />
    <xs:element name="OrderStatusId" type="xs:int" />
    <xs:element name="Charge" type="xs:decimal" minOccurs="0" />
    <xs:element name="OrderAuthorizationCode" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:string" />
    <xs:element name="LastEditDate" type="xs:dateTime" />
    <xs:element name="ExpirationDate" type="xs:dateTime" minOccurs="0" />
    <xs:element name="SMSAddress" type="xs:string" minOccurs="0" />
    <xs:element name="ShippingMethodId" type="xs:int" minOccurs="0" />
    <xs:element name="ShippingAddressId" type="xs:int" minOccurs="0" />
    <xs:element name="BeeBusinessGuid" type="xs:string" minOccurs="0" />
    <xs:element name="SerialNumber" type="xs:string" minOccurs="0" />
    <xs:element name="UpdateShipping" type="xs:boolean" minOccurs="0" />
    <xs:element name="UpdateBilling" type="xs:boolean" minOccurs="0" />
    <xs:element name="FinalTax" type="xs:decimal" minOccurs="0" />
    <xs:element name="TaxesPaidBy" type="xs:int" minOccurs="0" />
    <xs:element name="CmmAdjustmentTypeGuid" type="xs:string" minOccurs="0" />
    <xs:element name="IsShippingTaxed" type="xs:string" minOccurs="0" />
    <xs:element name="ShippingTax" type="xs:string" minOccurs="0" />
    <xs:element name="FinalShippingTax" type="xs:string" minOccurs="0" />
    <xs:element name="ShippingTaxPercentage" type="xs:string" minOccurs="0" />
    <xs:element name="IsShipToHost" type="xs:string" minOccurs="0" />
    <xs:element name="IsShipToConsultant" type="xs:string" minOccurs="0" />
    <xs:element name="MasterOrderId" type="xs:int" minOccurs="0" />
    <xs:element name="BeeNumber" type="xs:decimal" minOccurs="0" />
    <xs:element name="EventId" type="xs:int" minOccurs="0" />
    <xs:element name="OrderTotal" type="xs:decimal" minOccurs="0" />
    <xs:element name="OrderTypeId" type="xs:string" minOccurs="0" />
    <xs:element name="TaxTransactionId" type="xs:string" minOccurs="0" />
    <xs:element name="PrimaryHostCustomerId" type="xs:string" minOccurs="0" />
    <xs:element name="IsHostOrder" type="xs:boolean" minOccurs="0" />
    <xs:element name="MOHostIDPrimary" type="xs:int" minOccurs="0" />
    <xs:element name="IsHostShipToConsultant" type="xs:boolean" minOccurs="0" />
    <xs:element name="IsHostShipToHost" type="xs:boolean" minOccurs="0" />
    <xs:element name="IsConsultantShipToConsultant" type="xs:boolean" minOccurs="0" />
    <xs:element name="IsConsultantShipToHost" type="xs:boolean" minOccurs="0" />
    </xs:sequence>
    </xs:complexType>
    </xs:element>
    <xs:element name="OrderAttribute">
    <xs:complexType>
    <xs:sequence>
    <xs:element name="OrderAttributeId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementStep="-1" type="xs:int" />
    <xs:element name="OrderId" type="xs:int" />
    <xs:element name="Key">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="100" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="Value">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="1073741823" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    </xs:sequence>
    </xs:complexType>
    </xs:element>
    <xs:element name="OrderSku">
    <xs:complexType>
    <xs:sequence>
    <xs:element name="OrderSkuId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementStep="-1" type="xs:int" />
    <xs:element name="OrderId" type="xs:int" minOccurs="0" />
    <xs:element name="SkuId" type="xs:int" minOccurs="0" />
    <xs:element name="Quantity" type="xs:int" minOccurs="0" />
    <xs:element name="Price" type="xs:decimal" minOccurs="0" />
    <xs:element name="Discount" type="xs:decimal" minOccurs="0" />
    <xs:element name="Shipped" type="xs:boolean" minOccurs="0" />
    <xs:element name="BuyingDiscount" type="xs:string" minOccurs="0" />
    <xs:element name="DiscountName" type="xs:string" minOccurs="0" />
    <xs:element name="TaxAmount" type="xs:string" minOccurs="0" />
    <xs:element name="POEPriceID" type="xs:string" minOccurs="0" />
    <xs:element name="PoeDiscountId" type="xs:int" minOccurs="0" />
    <xs:element name="Conversion" type="xs:int" minOccurs="0" />
    <xs:element name="CategoryID" type="xs:int" minOccurs="0" />
    <xs:element name="BackorderQuantity" type="xs:int" minOccurs="0" />
    <xs:element name="FinalTax" type="xs:decimal" minOccurs="0" />
    <xs:element name="TaxPercentage" type="xs:decimal" minOccurs="0" />
    <xs:element name="PriceCharged" type="xs:decimal" minOccurs="0" />
    <xs:element name="UOM" type="xs:string" minOccurs="0" />
    <xs:element name="Code" type="xs:string" minOccurs="0" />
    <xs:element name="POEPriceID1" type="xs:int" minOccurs="0" />
    </xs:sequence>
    </xs:complexType>
    </xs:element>
    <xs:element name="OrderSkuSN">
    <xs:complexType>
    <xs:sequence>
    <xs:element name="OrderSkuSNId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementStep="-1" type="xs:int" />
    <xs:element name="SN">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="255" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="OrderSkuId" type="xs:int" minOccurs="0" />
    </xs:sequence>
    </xs:complexType>
    </xs:element>
    <xs:element name="OrderSkuShipment">
    <xs:complexType>
    <xs:sequence>
    <xs:element name="OrderSkuShipmentId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementStep="-1" type="xs:int" />
    <xs:element name="OrderShipmentId" type="xs:int" />
    <xs:element name="OrderSkuId" type="xs:int" />
    <xs:element name="Quantity" type="xs:int" />
    <xs:element name="Tax" type="xs:decimal" minOccurs="0" />
    <xs:element name="QuantityPicked" type="xs:int" minOccurs="0" />
    </xs:sequence>
    </xs:complexType>
    </xs:element>
    <xs:element name="OrderSkuShipmentCharge">
    <xs:complexType>
    <xs:sequence>
    <xs:element name="OrderSkuShipmentChargeId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementStep="-1" type="xs:int" />
    <xs:element name="ChargeId" type="xs:int" />
    <xs:element name="OrderSkuShipmentId" type="xs:int" />
    <xs:element name="Charge" type="xs:decimal" minOccurs="0" />
    </xs:sequence>
    </xs:complexType>
    </xs:element>
    <xs:element name="OrderSkuShipmentChargeAttribute">
    <xs:complexType>
    <xs:sequence>
    <xs:element name="OrderSkuShipmentChargeAttributeId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementStep="-1" type="xs:int" />
    <xs:element name="OrderSkuShipmentChargeId" type="xs:int" />
    <xs:element name="Key">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="100" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="Value">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="1073741823" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    </xs:sequence>
    </xs:complexType>
    </xs:element>
    <xs:element name="OrderShipment">
    <xs:complexType>
    <xs:sequence>
    <xs:element name="OrderShipmentId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementStep="-1" type="xs:int" />
    <xs:element name="TrackingNumber" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="50" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="ShipmentDate" type="xs:dateTime" minOccurs="0" />
    <xs:element name="ShipmentDetails" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="1073741823" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="OrderId" type="xs:int" />
    <xs:element name="ShipmentStatusId" type="xs:int" />
    <xs:element name="ShippingMethod">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="100" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="ShippingSpeed">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="50" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="ShippingCost" type="xs:decimal" />
    <xs:element name="AddressId" type="xs:int" />
    <xs:element name="Tax" type="xs:decimal" />
    <xs:element name="Charge" type="xs:decimal" minOccurs="0" />
    <xs:element name="CustomerDiscount" type="xs:decimal" />
    <xs:element name="ActualShippingFee" type="xs:decimal" minOccurs="0" />
    </xs:sequence>
    </xs:complexType>
    </xs:element>
    <xs:element name="OrderPayment">
    <xs:complexType>
    <xs:sequence>
    <xs:element name="OrderPaymentID" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" />
    <xs:element name="OrderID" type="xs:int" />
    <xs:element name="PaymentTypeID" type="xs:int" />
    <xs:element name="PaymentName" type="xs:string" minOccurs="0" />
    <xs:element name="CreditCardType" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="50" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="CreditCardName" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="200" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="CreditCardNumber" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="100" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="CreditCardExpired" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="10" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="CustomerDiscount" type="xs:decimal" minOccurs="0" />
    <xs:element name="AuthorizationCode" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="50" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="BankAccountNumber" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="100" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="BankRoutingNumber" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="100" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="BankAccountType" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="50" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="BankName" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="100" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="BankAccountName" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="100" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="LicenseNumber" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="100" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="LicenseDOB" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="100" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="LicenseState" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="8" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="CheckNumber" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="50" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="SavingsClubGUID" type="xs:decimal" minOccurs="0" />
    <xs:element name="Charge" type="xs:decimal" />
    <xs:element name="TextResponse" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="300" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="Processed" type="xs:boolean" minOccurs="0" />
    <xs:element name="ConfirmationCode" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="50" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="AuthTime" type="xs:dateTime" minOccurs="0" />
    <xs:element name="AddressID" type="xs:int" minOccurs="0" />
    <xs:element name="TransactionId" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="50" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="AVS" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="50" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="BalancingPayment" type="xs:boolean" minOccurs="0" />
    <xs:element name="SerialNumber" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="50" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="BeeBusinessGuid" type="xs:string" minOccurs="0" />
    </xs:sequence>
    </xs:complexType>
    </xs:element>
    <xs:element name="MasterOrderPayment">
    <xs:complexType>
    <xs:sequence>
    <xs:element name="MasterOrderPaymentID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:Caption="POEMasterOrderPaymentID" type="xs:int" />
    <xs:element name="MasterOrderID" msdata:Caption="POEMasterOrderID" type="xs:int" />
    <xs:element name="PaymentTypeID" type="xs:int" />
    <xs:element name="PaymentName" type="xs:string" minOccurs="0" />
    <xs:element name="CreditCardType" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="50" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="CreditCardName" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="200" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="CreditCardNumber" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="100" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="CreditCardExpired" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="10" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="CustomerDiscount" type="xs:decimal" minOccurs="0" />
    <xs:element name="AuthorizationCode" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="50" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="BankAccountNumber" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="100" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="BankRoutingNumber" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="100" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="BankAccountType" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="50" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="BankName" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="100" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="BankAccountName" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="100" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="LicenseNumber" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="100" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="LicenseDOB" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="100" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="LicenseState" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="8" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="CheckNumber" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="50" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="SavingsClubGUID" type="xs:decimal" minOccurs="0" />
    <xs:element name="Charge" type="xs:decimal" />
    <xs:element name="TextResponse" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="300" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="IsAuthorized" type="xs:boolean" />
    <xs:element name="ConfirmationCode" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="50" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="AuthTime" type="xs:dateTime" minOccurs="0" />
    <xs:element name="AddressID" type="xs:int" minOccurs="0" />
    <xs:element name="TransactionId" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="50" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="AVS" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="50" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="IsPreAuthorized" type="xs:boolean" />
    <xs:element name="PreProcess" type="xs:boolean" minOccurs="0" />
    <xs:element name="BeeBusinessGuid" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="50" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="SerialNumber" minOccurs="0">
    <xs:simpleType>
    <xs:restriction base="xs:string">
    <xs:maxLength value="50" />
    </xs:restriction>
    </xs:simpleType>
    </xs:element>
    <xs:element name="IsBooked" type="xs:boolean" />
    </xs:sequence>
    </xs:complexType>
    </xs:element>
    <xs:element name="Sku">
    <xs:complexType>
    <xs:sequence>
    <xs:element name="SkuId" type="xs:int" />
    <xs:element name="IsAutoShip" type="xs:boolean" minOccurs="0" />
    <xs:element name="CddCodeGuidProductType" type="xs:decimal" minOccurs="0" />
    <xs:element name="CddCodeGuidSubscriptionType" type="xs:decimal" minOccurs="0" />
    <xs:element name="ProductType" type="xs:string" minOccurs="0" />
    <xs:element name="SubscriptionPayment" type="xs:string" minOccurs="0" />
    </xs:sequence>
    </xs:complexType>
    </xs:element>
    <xs:element name="PoeOrderDisc">
    <xs:complexType>
    <xs:sequence>
    <xs:element name="PoeOrderDiscId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" type="xs:int" />
    <xs:element name="OrderId" type="xs:int" minOccurs="0" />
    <xs:element name="AppliedAmount" type="xs:decimal" minOccurs="0" />
    <xs:element name="SystemKeyword" type="xs:string" minOccurs="0" />
    <xs:element name="PlanName" type="xs:string" minOccurs="0" />
    <xs:element name="PlanDescription" type="xs:string" minOccurs="0" />
    </xs:sequence>
    </xs:complexType>
    </xs:element>
    <xs:element name="PoeOrderItemDisc">
    <xs:complexType>
    <xs:sequence>
    <xs:element name="PoeOrderItemDiscId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" type="xs:int" />
    <xs:element name="OrderSkuId" type="xs:int" minOccurs="0" />
    <xs:element name="AppliedAmount" type="xs:decimal" minOccurs="0" />
    <xs:element name="SystemKeyword" type="xs:string" minOccurs="0" />
    <xs:element name="PlanName" type="xs:string" minOccurs="0" />
    <xs:element name="PlanDescription" type="xs:string" minOccurs="0" />
    </xs:sequence>
    </xs:complexType>
    </xs:element>
    <xs:element name="OrderSkuComponent">
    <xs:complexType>
    <xs:sequence>
    <xs:element name="OrderSkuComponentId" type="xs:int" />
    <xs:element name="OrderSkuId" type="xs:int" minOccurs="0" />
    <xs:element name="Code" type="xs:string" minOccurs="0" />
    <xs:element name="UOM" type="xs:string" minOccurs="0" />
    <xs:element name="Quantity" type="xs:unsignedInt" minOccurs="0" />
    </xs:sequence>
    </xs:complexType>
    </xs:element>
    </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1">
    <xs:selector xpath=".//mstns:Order" />
    <xs:field xpath="mstns:OrderId" />
    </xs:unique>
    <xs:unique name="OrderKey1" msdata:PrimaryKey="true">
    <xs:selector xpath=".//mstns:Order" />
    <xs:field xpath="mstns:OrderId" />
    <xs:field xpath="mstns:LastEditDate" />
    </xs:unique>
    <xs:unique name="OrderAttribute_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
    <xs:selector xpath=".//mstns:OrderAttribute" />
    <xs:field xpath="mstns:OrderAttributeId" />
    </xs:unique>
    <xs:unique name="OrderSku_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
    <xs:selector xpath=".//mstns:OrderSku" />
    <xs:field xpath="mstns:OrderSkuId" />
    </xs:unique>
    <xs:unique name="OrderSkuSN_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
    <xs:selector xpath=".//mstns:OrderSkuSN" />
    <xs:field xpath="mstns:OrderSkuSNId" />
    </xs:unique>
    <xs:unique name="OrderSkuShipment_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
    <xs:selector xpath=".//mstns:OrderSkuShipment" />
    <xs:field xpath="mstns:OrderSkuShipmentId" />
    </xs:unique>
    <xs:unique name="OrderSkuShipmentCharge_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
    <xs:selector xpath=".//mstns:OrderSkuShipmentCharge" />
    <xs:field xpath="mstns:OrderSkuShipmentChargeId" />
    </xs:unique>
    <xs:unique name="OrderSkuShipmentChargeAttribute_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
    <xs:selector xpath=".//mstns:OrderSkuShipmentChargeAttribute" />
    <xs:field xpath="mstns:OrderSkuShipmentChargeAttributeId" />
    </xs:unique>
    <xs:unique name="OrderShipment_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
    <xs:selector xpath=".//mstns:OrderShipment" />
    <xs:field xpath="mstns:OrderShipmentId" />
    </xs:unique>
    <xs:unique name="OrderPayment_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
    <xs:selector xpath=".//mstns:OrderPayment" />
    <xs:field xpath="mstns:OrderPaymentID" />
    </xs:unique>
    <xs:unique name="MasterOrderPayment_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
    <xs:selector xpath=".//mstns:MasterOrderPayment" />
    <xs:field xpath="mstns:MasterOrderPaymentID" />
    </xs:unique>
    <xs:unique name="SkuKey1" msdata:PrimaryKey="true">
    <xs:selector xpath=".//mstns:Sku" />
    <xs:field xpath="mstns:SkuId" />
    </xs:unique>
    <xs:unique name="PoeOrderDisc_Constraint1" msdata:ConstraintName="Constraint1">
    <xs:selector xpath=".//mstns:PoeOrderDisc" />
    <xs:field xpath="mstns:PoeOrderDiscId" />
    </xs:unique>
    <xs:unique name="PoeOrderItemDisc_Constraint1" msdata:ConstraintName="Constraint1">
    <xs:selector xpath=".//mstns:PoeOrderItemDisc" />
    <xs:field xpath="mstns:PoeOrderItemDiscId" />
    </xs:unique>
    <xs:unique name="OrderSkuComponent_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
    <xs:selector xpath=".//mstns:OrderSkuComponent" />
    <xs:field xpath="mstns:OrderSkuComponentId" />
    </xs:unique>
    <xs:keyref name="FK_Order_OrderShipment" refer="Constraint1">
    <xs:selector xpath=".//mstns:OrderShipment" />
    <xs:field xpath="mstns:OrderId" />
    </xs:keyref>
    <xs:keyref name="FK_OrderSkuShipmentCharge_OrderSkuShipmentChargeAttribute" refer="OrderSkuShipmentCharge_Constraint1">
    <xs:selector xpath=".//mstns:OrderSkuShipmentChargeAttribute" />
    <xs:field xpath="mstns:OrderSkuShipmentChargeId" />
    </xs:keyref>
    <xs:keyref name="FK_OrderSkuShipment_OrderSkuShipmentCharge" refer="OrderSkuShipment_Constraint1">
    <xs:selector xpath=".//mstns:OrderSkuShipmentCharge" />
    <xs:field xpath="mstns:OrderSkuShipmentId" />
    </xs:keyref>
    <xs:keyref name="OrderSku_OrderSkuShipment" refer="OrderSku_Constraint1">
    <xs:selector xpath=".//mstns:OrderSkuShipment" />
    <xs:field xpath="mstns:OrderSkuId" />
    </xs:keyref>
    <xs:keyref name="FK_OrderShipment_OrderSkuShipment" refer="OrderShipment_Constraint1">
    <xs:selector xpath=".//mstns:OrderSkuShipment" />
    <xs:field xpath="mstns:OrderShipmentId" />
    </xs:keyref>
    <xs:keyref name="OrderSku_OrderSkuSN" refer="OrderSku_Constraint1">
    <xs:selector xpath=".//mstns:OrderSkuSN" />
    <xs:field xpath="mstns:OrderSkuSNId" />
    </xs:keyref>
    <xs:keyref name="Order_OrderSku" refer="Constraint1">
    <xs:selector xpath=".//mstns:OrderSku" />
    <xs:field xpath="mstns:OrderId" />
    </xs:keyref>
    <xs:keyref name="Order_OrderAttribute" refer="Constraint1">
    <xs:selector xpath=".//mstns:OrderAttribute" />
    <xs:field xpath="mstns:OrderId" />
    </xs:keyref>
    </xs:element>
    <xs:annotation>
    <xs:appinfo>
    <msdata:Relationship name="Order_POEOrderPayment" msdata:parent="Order" msdata:child="OrderPayment" msdata:parentkey="OrderId" msdata:childkey="OrderID" />
    <msdata:Relationship name="Order_POEMasterOrderPayment" msdata:parent="Order" msdata:child="MasterOrderPayment" msdata:parentkey="MasterOrderId" msdata:childkey="MasterOrderID" />
    <msdata:Relationship name="OrderSku_Sku" msdata:parent="OrderSku" msdata:child="Sku" msdata:parentkey="SkuId" msdata:childkey="SkuId" />
    <msdata:Relationship name="Order_PoeOrderDisc" msdata:parent="Order" msdata:child="PoeOrderDisc" msdata:parentkey="OrderId" msdata:childkey="OrderId" />
    <msdata:Relationship name="OrderSku_PoeOrderItemDisc" msdata:parent="OrderSku" msdata:child="PoeOrderItemDisc" msdata:parentkey="OrderSkuId" msdata:childkey="OrderSkuId" />
    <msdata:Relationship name="OrderSkuComponent_OrderSku" msdata:parent="OrderSkuComponent" msdata:child="OrderSku" msdata:parentkey="OrderSkuId" msdata:childkey="OrderSkuId" />
    </xs:appinfo>
    </xs:annotation>
    </xs:schema>
    <diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
    <OrderDto xmlns="http://tempuri.org/OrderDto.xsd">
    <Order diffgr:id="Order1" msdata:rowOrder="0">
    <OrderId>33333</OrderId>
    <Email>janedoe@yahoo.com</Email>
    <SubTotal>404.0000</SubTotal>
    <PaymentType>55</PaymentType>
    <CreditCardType>2</CreditCardType>
    <CreditCardName>Jane Doe</CreditCardName>
    <CreditCardNumber>545554545</CreditCardNumber>
    <CreditCardExpired>000021</CreditCardExpired>
    <CustomerDiscount>0.0000</CustomerDiscount>
    <Processed>true</Processed>
    <BillingAddressId>11111</BillingAddressId>
    <CustomerId>111111</CustomerId>
    <Created>2018-02-09T09:10:04.123-06:00</Created>
    <Completed>2018-02-09T09:10:12.92-06:00</Completed>
    <ShippingCost>0.0000</ShippingCost>
    <CurrencyId>USD</CurrencyId>
    <CreditCardCSC />
    <Tax>22.5500</Tax>
    <AuthorizationCode>11111</AuthorizationCode>
    <OrderStatusId>111</OrderStatusId>
    <Charge>344.8500</Charge>
    <OrderAuthorizationCode>code</OrderAuthorizationCode>
    <LastEditDate>2018-02-09T09:10:12.92-06:00</LastEditDate>
    <ExpirationDate>2018-02-09T09:10:12.92-06:00</ExpirationDate>
    <SMSAddress>1</SMSAddress>
    <ShippingMethodId>24</ShippingMethodId>
    <ShippingAddressId>11111</ShippingAddressId>
    <UpdateShipping>false</UpdateShipping>
    <UpdateBilling>false</UpdateBilling>
    <FinalTax>22.5500</FinalTax>
    <TaxesPaidBy>1</TaxesPaidBy>
    <IsShippingTaxed>False</IsShippingTaxed>
    <ShippingTax>0.0000</ShippingTax>
    <FinalShippingTax>0.0000</FinalShippingTax>
    <IsShipToConsultant>False</IsShipToConsultant>
    <MasterOrderId>11111</MasterOrderId>
    <BeeNumber>1111</BeeNumber>
    <EventId>111222</EventId>
    <OrderTotal>344.8500</OrderTotal>
    <OrderTypeId>PS</OrderTypeId>
    <TaxTransactionId>1233131312313</TaxTransactionId>
    <IsHostOrder>true</IsHostOrder>
    <MOHostIDPrimary>284591</MOHostIDPrimary>
    <IsHostShipToConsultant>false</IsHostShipToConsultant>
    <IsHostShipToHost>false</IsHostShipToHost>
    <IsConsultantShipToConsultant>false</IsConsultantShipToConsultant>
    <IsConsultantShipToHost>false</IsConsultantShipToHost>
    </Order>
    <OrderSku diffgr:id="OrderSku1" msdata:rowOrder="0">
    <OrderSkuId>11111</OrderSkuId>
    <OrderId>11111</OrderId>
    <SkuId>1111</SkuId>
    <Quantity>1</Quantity>
    <Price>74.0000</Price>
    <Shipped>true</Shipped>
    <BuyingDiscount>0.0000</BuyingDiscount>
    <TaxAmount>5.1800</TaxAmount>
    <POEPriceID>5341</POEPriceID>
    <Conversion>1</Conversion>
    <CategoryID>216</CategoryID>
    <BackorderQuantity>0</BackorderQuantity>
    <FinalTax>5.1800</FinalTax>
    <TaxPercentage>0.0700</TaxPercentage>
    <PriceCharged>74.0000</PriceCharged>
    <UOM>Each</UOM>
    <Code>3022046042</Code>
    <POEPriceID1>5341</POEPriceID1>
    </OrderSku>
    <OrderSku diffgr:id="OrderSku2" msdata:rowOrder="1">
    <OrderSkuId>11111</OrderSkuId>
    <OrderId>1111</OrderId>
    <SkuId>11111</SkuId>
    <Quantity>1</Quantity>
    <Price>74.0000</Price>
    <Shipped>true</Shipped>
    <BuyingDiscount>0.0000</BuyingDiscount>
    <TaxAmount>5.1800</TaxAmount>
    <POEPriceID>5348</POEPriceID>
    <Conversion>1</Conversion>
    <CategoryID>216</CategoryID>
    <BackorderQuantity>0</BackorderQuantity>
    <FinalTax>5.1800</FinalTax>
    <TaxPercentage>0.0700</TaxPercentage>
    <PriceCharged>74.0000</PriceCharged>
    <UOM>Each</UOM>
    <Code>3022001042</Code>
    <POEPriceID1>5348</POEPriceID1>
    </OrderSku>
    <OrderSkuShipment diffgr:id="OrderSkuShipment1" msdata:rowOrder="0">
    <OrderSkuShipmentId>111111</OrderSkuShipmentId>
    <OrderShipmentId>111111</OrderShipmentId>
    <OrderSkuId>111111</OrderSkuId>
    <Quantity>1</Quantity>
    <Tax>1.7100</Tax>
    </OrderSkuShipment>
    <OrderSkuShipment diffgr:id="OrderSkuShipment2" msdata:rowOrder="1">
    <OrderSkuShipmentId>11111</OrderSkuShipmentId>
    <OrderShipmentId>11111</OrderShipmentId>
    <OrderSkuId>11111</OrderSkuId>
    <Quantity>1</Quantity>
    <Tax>5.1800</Tax>
    </OrderSkuShipment>
    <OrderPayment diffgr:id="OrderPayment1" msdata:rowOrder="0">
    <OrderPaymentID>11111</OrderPaymentID>
    <OrderID>11111</OrderID>
    <PaymentTypeID>55</PaymentTypeID>
    <PaymentName>Credit Card Name</PaymentName>
    <CreditCardType>Type</CreditCardType>
    <CreditCardName>Jane Doe</CreditCardName>
    <CreditCardNumber>11111111</CreditCardNumber>
    <CreditCardExpired>000021</CreditCardExpired>
    <AuthorizationCode>111111</AuthorizationCode>
    <BankAccountNumber />
    <BankRoutingNumber />
    <BankAccountType />
    <BankName />
    <BankAccountName />
    <LicenseNumber />
    <LicenseDOB />
    <LicenseState />
    <CheckNumber />
    <Charge>344.8500</Charge>
    <TextResponse>This transaction has been approved.</TextResponse>
    <Processed>true</Processed>
    <ConfirmationCode>1</ConfirmationCode>
    <AuthTime>2018-02-09T09:10:04.123-06:00</AuthTime>
    <AddressID>1722990</AddressID>
    <TransactionId>60933700614</TransactionId>
    <AVS>P</AVS>
    <BalancingPayment>false</BalancingPayment>
    <SerialNumber />
    <BeeBusinessGuid />
    </OrderPayment>
    <Sku diffgr:id="Sku1" msdata:rowOrder="0">
    <SkuId>1111</SkuId>
    <IsAutoShip>false</IsAutoShip>
    </Sku>
    <Sku diffgr:id="Sku2" msdata:rowOrder="1">
    <SkuId>1111</SkuId>
    <IsAutoShip>false</IsAutoShip>
    </Sku>
    <PoeOrderDisc diffgr:id="PoeOrderDisc1" msdata:rowOrder="0">
    <PoeOrderDiscId>111111</PoeOrderDiscId>
    <OrderId>111111</OrderId>
    <AppliedAmount>0.0000</AppliedAmount>
    <SystemKeyword>FreeShipping</SystemKeyword>
    <PlanName>Hostess Free Shipping v3</PlanName>
    <PlanDescription>Hostess Free Shipping</PlanDescription>
    </PoeOrderDisc>
    <PoeOrderDisc diffgr:id="PoeOrderDisc2" msdata:rowOrder="1">
    <PoeOrderDiscId>111111</PoeOrderDiscId>
    <OrderId>111111</OrderId>
    <AppliedAmount>1.0000</AppliedAmount>
    <SystemKeyword>LimitedEditionCategory</SystemKeyword>
    <PlanName>Cami Club - party host - spring 2018</PlanName>
    <PlanDescription>Cami Club - Party host</PlanDescription>
    </PoeOrderDisc>
    </OrderDto>
    </diffgr:diffgram>
    </OrderDto>
    0
  • Hristina Bendeva NetSuite Integration Whiz
    Awesome Follow-up
    Engaged
    Celigo University Level 4: Legendary

    And this is the "Parsed Output" panel. 

    {
    "page_of_records": [
    {
    "record": {
    "$": {
    "xmlns": "http://www.domain.com/ECFServices/"
    },
    "xs:schema": [
    {
    "$": {
    "id": "OrderDto",
    "targetNamespace": "http://tempuri.org/OrderDto.xsd",
    "xmlns:mstns": "http://tempuri.org/OrderDto.xsd",
    "xmlns": "http://tempuri.org/OrderDto.xsd",
    "xmlns:xs": "http://www.w3.org/2001/XMLSchema",
    "xmlns:msdata": "urn:schemas-microsoft-com:xml-msdata",
    "attributeFormDefault": "qualified",
    "elementFormDefault": "qualified"
    },
    "xs:element": [
    {
    "$": {
    "name": "OrderDto",
    "msdata:IsDataSet": "true",
    "msdata:UseCurrentLocale": "true"
    },
    "xs:complexType": [
    {
    "xs:choice": [
    {
    "$": {
    "minOccurs": "0",
    "maxOccurs": "unbounded"
    },
    "xs:element": [
    {
    "$": {
    "name": "Order"
    },
    "xs:complexType": [
    {
    "xs:sequence": [
    {
    "xs:element": [
    {
    "$": {
    "name": "OrderId",
    "msdata:ReadOnly": "true",
    "msdata:AutoIncrement": "true",
    "msdata:AutoIncrementStep": "-1",
    "type": "xs:int"
    }
    },
    {
    "$": {
    "name": "Email"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "255"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "SubTotal",
    "type": "xs:decimal"
    }
    },
    {
    "$": {
    "name": "PaymentType",
    "type": "xs:int",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "CreditCardType",
    "type": "xs:int",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "CreditCardName",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "CreditCardNumber",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "CreditCardExpired",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "CustomerDiscount",
    "type": "xs:decimal"
    }
    },
    {
    "$": {
    "name": "Processed",
    "type": "xs:boolean"
    }
    },
    {
    "$": {
    "name": "BillingAddressId",
    "type": "xs:int",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "CustomerId",
    "type": "xs:int",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "Created",
    "type": "xs:dateTime"
    }
    },
    {
    "$": {
    "name": "Completed",
    "type": "xs:dateTime",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "ShippingCost",
    "type": "xs:decimal"
    }
    },
    {
    "$": {
    "name": "CurrencyId"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "3"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "CreditCardCSC",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "AffiliateId",
    "type": "xs:int",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "AffiliatePercent",
    "type": "xs:int",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "BankAccountNumber",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "BankRoutingNumber",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "BankAccountType",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "BankName",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "BankAccountName",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "LicenseNumber",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "LicenseDOB",
    "type": "xs:dateTime",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "LicenseState",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "CheckNumber",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "Tax",
    "type": "xs:decimal",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "TextResponse",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "AuthorizationCode",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "ConfirmationCode",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "OrderStatusId",
    "type": "xs:int"
    }
    },
    {
    "$": {
    "name": "Charge",
    "type": "xs:decimal",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "OrderAuthorizationCode",
    "msdata:DataType": "System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089",
    "type": "xs:string"
    }
    },
    {
    "$": {
    "name": "LastEditDate",
    "type": "xs:dateTime"
    }
    },
    {
    "$": {
    "name": "ExpirationDate",
    "type": "xs:dateTime",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "SMSAddress",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "ShippingMethodId",
    "type": "xs:int",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "ShippingAddressId",
    "type": "xs:int",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "BeeBusinessGuid",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "SerialNumber",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "UpdateShipping",
    "type": "xs:boolean",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "UpdateBilling",
    "type": "xs:boolean",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "FinalTax",
    "type": "xs:decimal",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "TaxesPaidBy",
    "type": "xs:int",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "CmmAdjustmentTypeGuid",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "IsShippingTaxed",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "ShippingTax",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "FinalShippingTax",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "ShippingTaxPercentage",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "IsShipToHost",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "IsShipToConsultant",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "MasterOrderId",
    "type": "xs:int",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "BeeNumber",
    "type": "xs:decimal",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "EventId",
    "type": "xs:int",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "OrderTotal",
    "type": "xs:decimal",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "OrderTypeId",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "TaxTransactionId",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "PrimaryHostCustomerId",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "IsHostOrder",
    "type": "xs:boolean",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "MOHostIDPrimary",
    "type": "xs:int",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "IsHostShipToConsultant",
    "type": "xs:boolean",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "IsHostShipToHost",
    "type": "xs:boolean",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "IsConsultantShipToConsultant",
    "type": "xs:boolean",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "IsConsultantShipToHost",
    "type": "xs:boolean",
    "minOccurs": "0"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "OrderAttribute"
    },
    "xs:complexType": [
    {
    "xs:sequence": [
    {
    "xs:element": [
    {
    "$": {
    "name": "OrderAttributeId",
    "msdata:ReadOnly": "true",
    "msdata:AutoIncrement": "true",
    "msdata:AutoIncrementStep": "-1",
    "type": "xs:int"
    }
    },
    {
    "$": {
    "name": "OrderId",
    "type": "xs:int"
    }
    },
    {
    "$": {
    "name": "Key"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "100"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "Value"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "1073741823"
    }
    }
    ]
    }
    ]
    }
    ]
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "OrderSku"
    },
    "xs:complexType": [
    {
    "xs:sequence": [
    {
    "xs:element": [
    {
    "$": {
    "name": "OrderSkuId",
    "msdata:ReadOnly": "true",
    "msdata:AutoIncrement": "true",
    "msdata:AutoIncrementStep": "-1",
    "type": "xs:int"
    }
    },
    {
    "$": {
    "name": "OrderId",
    "type": "xs:int",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "SkuId",
    "type": "xs:int",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "Quantity",
    "type": "xs:int",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "Price",
    "type": "xs:decimal",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "Discount",
    "type": "xs:decimal",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "Shipped",
    "type": "xs:boolean",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "BuyingDiscount",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "DiscountName",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "TaxAmount",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "POEPriceID",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "PoeDiscountId",
    "type": "xs:int",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "Conversion",
    "type": "xs:int",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "CategoryID",
    "type": "xs:int",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "BackorderQuantity",
    "type": "xs:int",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "FinalTax",
    "type": "xs:decimal",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "TaxPercentage",
    "type": "xs:decimal",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "PriceCharged",
    "type": "xs:decimal",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "UOM",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "Code",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "POEPriceID1",
    "type": "xs:int",
    "minOccurs": "0"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "OrderSkuSN"
    },
    "xs:complexType": [
    {
    "xs:sequence": [
    {
    "xs:element": [
    {
    "$": {
    "name": "OrderSkuSNId",
    "msdata:ReadOnly": "true",
    "msdata:AutoIncrement": "true",
    "msdata:AutoIncrementStep": "-1",
    "type": "xs:int"
    }
    },
    {
    "$": {
    "name": "SN"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "255"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "OrderSkuId",
    "type": "xs:int",
    "minOccurs": "0"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "OrderSkuShipment"
    },
    "xs:complexType": [
    {
    "xs:sequence": [
    {
    "xs:element": [
    {
    "$": {
    "name": "OrderSkuShipmentId",
    "msdata:ReadOnly": "true",
    "msdata:AutoIncrement": "true",
    "msdata:AutoIncrementStep": "-1",
    "type": "xs:int"
    }
    },
    {
    "$": {
    "name": "OrderShipmentId",
    "type": "xs:int"
    }
    },
    {
    "$": {
    "name": "OrderSkuId",
    "type": "xs:int"
    }
    },
    {
    "$": {
    "name": "Quantity",
    "type": "xs:int"
    }
    },
    {
    "$": {
    "name": "Tax",
    "type": "xs:decimal",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "QuantityPicked",
    "type": "xs:int",
    "minOccurs": "0"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "OrderSkuShipmentCharge"
    },
    "xs:complexType": [
    {
    "xs:sequence": [
    {
    "xs:element": [
    {
    "$": {
    "name": "OrderSkuShipmentChargeId",
    "msdata:ReadOnly": "true",
    "msdata:AutoIncrement": "true",
    "msdata:AutoIncrementStep": "-1",
    "type": "xs:int"
    }
    },
    {
    "$": {
    "name": "ChargeId",
    "type": "xs:int"
    }
    },
    {
    "$": {
    "name": "OrderSkuShipmentId",
    "type": "xs:int"
    }
    },
    {
    "$": {
    "name": "Charge",
    "type": "xs:decimal",
    "minOccurs": "0"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "OrderSkuShipmentChargeAttribute"
    },
    "xs:complexType": [
    {
    "xs:sequence": [
    {
    "xs:element": [
    {
    "$": {
    "name": "OrderSkuShipmentChargeAttributeId",
    "msdata:ReadOnly": "true",
    "msdata:AutoIncrement": "true",
    "msdata:AutoIncrementStep": "-1",
    "type": "xs:int"
    }
    },
    {
    "$": {
    "name": "OrderSkuShipmentChargeId",
    "type": "xs:int"
    }
    },
    {
    "$": {
    "name": "Key"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "100"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "Value"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "1073741823"
    }
    }
    ]
    }
    ]
    }
    ]
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "OrderShipment"
    },
    "xs:complexType": [
    {
    "xs:sequence": [
    {
    "xs:element": [
    {
    "$": {
    "name": "OrderShipmentId",
    "msdata:ReadOnly": "true",
    "msdata:AutoIncrement": "true",
    "msdata:AutoIncrementStep": "-1",
    "type": "xs:int"
    }
    },
    {
    "$": {
    "name": "TrackingNumber",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "50"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "ShipmentDate",
    "type": "xs:dateTime",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "ShipmentDetails",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "1073741823"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "OrderId",
    "type": "xs:int"
    }
    },
    {
    "$": {
    "name": "ShipmentStatusId",
    "type": "xs:int"
    }
    },
    {
    "$": {
    "name": "ShippingMethod"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "100"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "ShippingSpeed"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "50"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "ShippingCost",
    "type": "xs:decimal"
    }
    },
    {
    "$": {
    "name": "AddressId",
    "type": "xs:int"
    }
    },
    {
    "$": {
    "name": "Tax",
    "type": "xs:decimal"
    }
    },
    {
    "$": {
    "name": "Charge",
    "type": "xs:decimal",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "CustomerDiscount",
    "type": "xs:decimal"
    }
    },
    {
    "$": {
    "name": "ActualShippingFee",
    "type": "xs:decimal",
    "minOccurs": "0"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "OrderPayment"
    },
    "xs:complexType": [
    {
    "xs:sequence": [
    {
    "xs:element": [
    {
    "$": {
    "name": "OrderPaymentID",
    "msdata:ReadOnly": "true",
    "msdata:AutoIncrement": "true",
    "type": "xs:int"
    }
    },
    {
    "$": {
    "name": "OrderID",
    "type": "xs:int"
    }
    },
    {
    "$": {
    "name": "PaymentTypeID",
    "type": "xs:int"
    }
    },
    {
    "$": {
    "name": "PaymentName",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "CreditCardType",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "50"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "CreditCardName",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "200"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "CreditCardNumber",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "100"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "CreditCardExpired",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "10"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "CustomerDiscount",
    "type": "xs:decimal",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "AuthorizationCode",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "50"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "BankAccountNumber",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "100"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "BankRoutingNumber",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "100"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "BankAccountType",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "50"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "BankName",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "100"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "BankAccountName",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "100"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "LicenseNumber",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "100"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "LicenseDOB",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "100"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "LicenseState",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "8"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "CheckNumber",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "50"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "SavingsClubGUID",
    "type": "xs:decimal",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "Charge",
    "type": "xs:decimal"
    }
    },
    {
    "$": {
    "name": "TextResponse",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "300"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "Processed",
    "type": "xs:boolean",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "ConfirmationCode",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "50"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "AuthTime",
    "type": "xs:dateTime",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "AddressID",
    "type": "xs:int",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "TransactionId",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "50"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "AVS",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "50"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "BalancingPayment",
    "type": "xs:boolean",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "SerialNumber",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "50"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "BeeBusinessGuid",
    "type": "xs:string",
    "minOccurs": "0"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "MasterOrderPayment"
    },
    "xs:complexType": [
    {
    "xs:sequence": [
    {
    "xs:element": [
    {
    "$": {
    "name": "MasterOrderPaymentID",
    "msdata:ReadOnly": "true",
    "msdata:AutoIncrement": "true",
    "msdata:Caption": "POEMasterOrderPaymentID",
    "type": "xs:int"
    }
    },
    {
    "$": {
    "name": "MasterOrderID",
    "msdata:Caption": "POEMasterOrderID",
    "type": "xs:int"
    }
    },
    {
    "$": {
    "name": "PaymentTypeID",
    "type": "xs:int"
    }
    },
    {
    "$": {
    "name": "PaymentName",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "CreditCardType",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "50"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "CreditCardName",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "200"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "CreditCardNumber",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "100"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "CreditCardExpired",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "10"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "CustomerDiscount",
    "type": "xs:decimal",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "AuthorizationCode",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "50"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "BankAccountNumber",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "100"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "BankRoutingNumber",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "100"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "BankAccountType",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "50"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "BankName",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "100"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "BankAccountName",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "100"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "LicenseNumber",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "100"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "LicenseDOB",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "100"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "LicenseState",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "8"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "CheckNumber",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "50"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "SavingsClubGUID",
    "type": "xs:decimal",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "Charge",
    "type": "xs:decimal"
    }
    },
    {
    "$": {
    "name": "TextResponse",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "300"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "IsAuthorized",
    "type": "xs:boolean"
    }
    },
    {
    "$": {
    "name": "ConfirmationCode",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "50"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "AuthTime",
    "type": "xs:dateTime",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "AddressID",
    "type": "xs:int",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "TransactionId",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "50"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "AVS",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "50"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "IsPreAuthorized",
    "type": "xs:boolean"
    }
    },
    {
    "$": {
    "name": "PreProcess",
    "type": "xs:boolean",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "BeeBusinessGuid",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "50"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "SerialNumber",
    "minOccurs": "0"
    },
    "xs:simpleType": [
    {
    "xs:restriction": [
    {
    "$": {
    "base": "xs:string"
    },
    "xs:maxLength": [
    {
    "$": {
    "value": "50"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "IsBooked",
    "type": "xs:boolean"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "Sku"
    },
    "xs:complexType": [
    {
    "xs:sequence": [
    {
    "xs:element": [
    {
    "$": {
    "name": "SkuId",
    "type": "xs:int"
    }
    },
    {
    "$": {
    "name": "IsAutoShip",
    "type": "xs:boolean",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "CddCodeGuidProductType",
    "type": "xs:decimal",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "CddCodeGuidSubscriptionType",
    "type": "xs:decimal",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "ProductType",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "SubscriptionPayment",
    "type": "xs:string",
    "minOccurs": "0"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "PoeOrderDisc"
    },
    "xs:complexType": [
    {
    "xs:sequence": [
    {
    "xs:element": [
    {
    "$": {
    "name": "PoeOrderDiscId",
    "msdata:ReadOnly": "true",
    "msdata:AutoIncrement": "true",
    "msdata:AutoIncrementSeed": "-1",
    "msdata:AutoIncrementStep": "-1",
    "type": "xs:int"
    }
    },
    {
    "$": {
    "name": "OrderId",
    "type": "xs:int",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "AppliedAmount",
    "type": "xs:decimal",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "SystemKeyword",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "PlanName",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "PlanDescription",
    "type": "xs:string",
    "minOccurs": "0"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "PoeOrderItemDisc"
    },
    "xs:complexType": [
    {
    "xs:sequence": [
    {
    "xs:element": [
    {
    "$": {
    "name": "PoeOrderItemDiscId",
    "msdata:ReadOnly": "true",
    "msdata:AutoIncrement": "true",
    "msdata:AutoIncrementSeed": "-1",
    "msdata:AutoIncrementStep": "-1",
    "type": "xs:int"
    }
    },
    {
    "$": {
    "name": "OrderSkuId",
    "type": "xs:int",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "AppliedAmount",
    "type": "xs:decimal",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "SystemKeyword",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "PlanName",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "PlanDescription",
    "type": "xs:string",
    "minOccurs": "0"
    }
    }
    ]
    }
    ]
    }
    ]
    },
    {
    "$": {
    "name": "OrderSkuComponent"
    },
    "xs:complexType": [
    {
    "xs:sequence": [
    {
    "xs:element": [
    {
    "$": {
    "name": "OrderSkuComponentId",
    "type": "xs:int"
    }
    },
    {
    "$": {
    "name": "OrderSkuId",
    "type": "xs:int",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "Code",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "UOM",
    "type": "xs:string",
    "minOccurs": "0"
    }
    },
    {
    "$": {
    "name": "Quantity",
    "type": "xs:unsignedInt",
    "minOccurs": "0"
    }
    }
    ]
    }
    ]
    }
    ]
    }
    ]
    }
    ]
    }
    ],
    "xs:unique": [
    {
    "$": {
    "name": "Constraint1"
    },
    "xs:selector": [
    {
    "$": {
    "xpath": ".//mstns:Order"
    }
    }
    ],
    "xs:field": [
    {
    "$": {
    "xpath": "mstns:OrderId"
    }
    }
    ]
    },
    {
    "$": {
    "name": "OrderKey1",
    "msdata:PrimaryKey": "true"
    },
    "xs:selector": [
    {
    "$": {
    "xpath": ".//mstns:Order"
    }
    }
    ],
    "xs:field": [
    {
    "$": {
    "xpath": "mstns:OrderId"
    }
    },
    {
    "$": {
    "xpath": "mstns:LastEditDate"
    }
    }
    ]
    },
    {
    "$": {
    "name": "OrderAttribute_Constraint1",
    "msdata:ConstraintName": "Constraint1",
    "msdata:PrimaryKey": "true"
    },
    "xs:selector": [
    {
    "$": {
    "xpath": ".//mstns:OrderAttribute"
    }
    }
    ],
    "xs:field": [
    {
    "$": {
    "xpath": "mstns:OrderAttributeId"
    }
    }
    ]
    },
    {
    "$": {
    "name": "OrderSku_Constraint1",
    "msdata:ConstraintName": "Constraint1",
    "msdata:PrimaryKey": "true"
    },
    "xs:selector": [
    {
    "$": {
    "xpath": ".//mstns:OrderSku"
    }
    }
    ],
    "xs:field": [
    {
    "$": {
    "xpath": "mstns:OrderSkuId"
    }
    }
    ]
    },
    {
    "$": {
    "name": "OrderSkuSN_Constraint1",
    "msdata:ConstraintName": "Constraint1",
    "msdata:PrimaryKey": "true"
    },
    "xs:selector": [
    {
    "$": {
    "xpath": ".//mstns:OrderSkuSN"
    }
    }
    ],
    "xs:field": [
    {
    "$": {
    "xpath": "mstns:OrderSkuSNId"
    }
    }
    ]
    },
    {
    "$": {
    "name": "OrderSkuShipment_Constraint1",
    "msdata:ConstraintName": "Constraint1",
    "msdata:PrimaryKey": "true"
    },
    "xs:selector": [
    {
    "$": {
    "xpath": ".//mstns:OrderSkuShipment"
    }
    }
    ],
    "xs:field": [
    {
    "$": {
    "xpath": "mstns:OrderSkuShipmentId"
    }
    }
    ]
    },
    {
    "$": {
    "name": "OrderSkuShipmentCharge_Constraint1",
    "msdata:ConstraintName": "Constraint1",
    "msdata:PrimaryKey": "true"
    },
    "xs:selector": [
    {
    "$": {
    "xpath": ".//mstns:OrderSkuShipmentCharge"
    }
    }
    ],
    "xs:field": [
    {
    "$": {
    "xpath": "mstns:OrderSkuShipmentChargeId"
    }
    }
    ]
    },
    {
    "$": {
    "name": "OrderSkuShipmentChargeAttribute_Constraint1",
    "msdata:ConstraintName": "Constraint1",
    "msdata:PrimaryKey": "true"
    },
    "xs:selector": [
    {
    "$": {
    "xpath": ".//mstns:OrderSkuShipmentChargeAttribute"
    }
    }
    ],
    "xs:field": [
    {
    "$": {
    "xpath": "mstns:OrderSkuShipmentChargeAttributeId"
    }
    }
    ]
    },
    {
    "$": {
    "name": "OrderShipment_Constraint1",
    "msdata:ConstraintName": "Constraint1",
    "msdata:PrimaryKey": "true"
    },
    "xs:selector": [
    {
    "$": {
    "xpath": ".//mstns:OrderShipment"
    }
    }
    ],
    "xs:field": [
    {
    "$": {
    "xpath": "mstns:OrderShipmentId"
    }
    }
    ]
    },
    {
    "$": {
    "name": "OrderPayment_Constraint1",
    "msdata:ConstraintName": "Constraint1",
    "msdata:PrimaryKey": "true"
    },
    "xs:selector": [
    {
    "$": {
    "xpath": ".//mstns:OrderPayment"
    }
    }
    ],
    "xs:field": [
    {
    "$": {
    "xpath": "mstns:OrderPaymentID"
    }
    }
    ]
    },
    {
    "$": {
    "name": "MasterOrderPayment_Constraint1",
    "msdata:ConstraintName": "Constraint1",
    "msdata:PrimaryKey": "true"
    },
    "xs:selector": [
    {
    "$": {
    "xpath": ".//mstns:MasterOrderPayment"
    }
    }
    ],
    "xs:field": [
    {
    "$": {
    "xpath": "mstns:MasterOrderPaymentID"
    }
    }
    ]
    },
    {
    "$": {
    "name": "SkuKey1",
    "msdata:PrimaryKey": "true"
    },
    "xs:selector": [
    {
    "$": {
    "xpath": ".//mstns:Sku"
    }
    }
    ],
    "xs:field": [
    {
    "$": {
    "xpath": "mstns:SkuId"
    }
    }
    ]
    },
    {
    "$": {
    "name": "PoeOrderDisc_Constraint1",
    "msdata:ConstraintName": "Constraint1"
    },
    "xs:selector": [
    {
    "$": {
    "xpath": ".//mstns:PoeOrderDisc"
    }
    }
    ],
    "xs:field": [
    {
    "$": {
    "xpath": "mstns:PoeOrderDiscId"
    }
    }
    ]
    },
    {
    "$": {
    "name": "PoeOrderItemDisc_Constraint1",
    "msdata:ConstraintName": "Constraint1"
    },
    "xs:selector": [
    {
    "$": {
    "xpath": ".//mstns:PoeOrderItemDisc"
    }
    }
    ],
    "xs:field": [
    {
    "$": {
    "xpath": "mstns:PoeOrderItemDiscId"
    }
    }
    ]
    },
    {
    "$": {
    "name": "OrderSkuComponent_Constraint1",
    "msdata:ConstraintName": "Constraint1",
    "msdata:PrimaryKey": "true"
    },
    "xs:selector": [
    {
    "$": {
    "xpath": ".//mstns:OrderSkuComponent"
    }
    }
    ],
    "xs:field": [
    {
    "$": {
    "xpath": "mstns:OrderSkuComponentId"
    }
    }
    ]
    }
    ],
    "xs:keyref": [
    {
    "$": {
    "name": "FK_Order_OrderShipment",
    "refer": "Constraint1"
    },
    "xs:selector": [
    {
    "$": {
    "xpath": ".//mstns:OrderShipment"
    }
    }
    ],
    "xs:field": [
    {
    "$": {
    "xpath": "mstns:OrderId"
    }
    }
    ]
    },
    {
    "$": {
    "name": "FK_OrderSkuShipmentCharge_OrderSkuShipmentChargeAttribute",
    "refer": "OrderSkuShipmentCharge_Constraint1"
    },
    "xs:selector": [
    {
    "$": {
    "xpath": ".//mstns:OrderSkuShipmentChargeAttribute"
    }
    }
    ],
    "xs:field": [
    {
    "$": {
    "xpath": "mstns:OrderSkuShipmentChargeId"
    }
    }
    ]
    },
    {
    "$": {
    "name": "FK_OrderSkuShipment_OrderSkuShipmentCharge",
    "refer": "OrderSkuShipment_Constraint1"
    },
    "xs:selector": [
    {
    "$": {
    "xpath": ".//mstns:OrderSkuShipmentCharge"
    }
    }
    ],
    "xs:field": [
    {
    "$": {
    "xpath": "mstns:OrderSkuShipmentId"
    }
    }
    ]
    },
    {
    "$": {
    "name": "OrderSku_OrderSkuShipment",
    "refer": "OrderSku_Constraint1"
    },
    "xs:selector": [
    {
    "$": {
    "xpath": ".//mstns:OrderSkuShipment"
    }
    }
    ],
    "xs:field": [
    {
    "$": {
    "xpath": "mstns:OrderSkuId"
    }
    }
    ]
    },
    {
    "$": {
    "name": "FK_OrderShipment_OrderSkuShipment",
    "refer": "OrderShipment_Constraint1"
    },
    "xs:selector": [
    {
    "$": {
    "xpath": ".//mstns:OrderSkuShipment"
    }
    }
    ],
    "xs:field": [
    {
    "$": {
    "xpath": "mstns:OrderShipmentId"
    }
    }
    ]
    },
    {
    "$": {
    "name": "OrderSku_OrderSkuSN",
    "refer": "OrderSku_Constraint1"
    },
    "xs:selector": [
    {
    "$": {
    "xpath": ".//mstns:OrderSkuSN"
    }
    }
    ],
    "xs:field": [
    {
    "$": {
    "xpath": "mstns:OrderSkuSNId"
    }
    }
    ]
    },
    {
    "$": {
    "name": "Order_OrderSku",
    "refer": "Constraint1"
    },
    "xs:selector": [
    {
    "$": {
    "xpath": ".//mstns:OrderSku"
    }
    }
    ],
    "xs:field": [
    {
    "$": {
    "xpath": "mstns:OrderId"
    }
    }
    ]
    },
    {
    "$": {
    "name": "Order_OrderAttribute",
    "refer": "Constraint1"
    },
    "xs:selector": [
    {
    "$": {
    "xpath": ".//mstns:OrderAttribute"
    }
    }
    ],
    "xs:field": [
    {
    "$": {
    "xpath": "mstns:OrderId"
    }
    }
    ]
    }
    ]
    }
    ],
    "xs:annotation": [
    {
    "xs:appinfo": [
    {
    "msdata:Relationship": [
    {
    "$": {
    "name": "Order_POEOrderPayment",
    "msdata:parent": "Order",
    "msdata:child": "OrderPayment",
    "msdata:parentkey": "OrderId",
    "msdata:childkey": "OrderID"
    }
    },
    {
    "$": {
    "name": "Order_POEMasterOrderPayment",
    "msdata:parent": "Order",
    "msdata:child": "MasterOrderPayment",
    "msdata:parentkey": "MasterOrderId",
    "msdata:childkey": "MasterOrderID"
    }
    },
    {
    "$": {
    "name": "OrderSku_Sku",
    "msdata:parent": "OrderSku",
    "msdata:child": "Sku",
    "msdata:parentkey": "SkuId",
    "msdata:childkey": "SkuId"
    }
    },
    {
    "$": {
    "name": "Order_PoeOrderDisc",
    "msdata:parent": "Order",
    "msdata:child": "PoeOrderDisc",
    "msdata:parentkey": "OrderId",
    "msdata:childkey": "OrderId"
    }
    },
    {
    "$": {
    "name": "OrderSku_PoeOrderItemDisc",
    "msdata:parent": "OrderSku",
    "msdata:child": "PoeOrderItemDisc",
    "msdata:parentkey": "OrderSkuId",
    "msdata:childkey": "OrderSkuId"
    }
    },
    {
    "$": {
    "name": "OrderSkuComponent_OrderSku",
    "msdata:parent": "OrderSkuComponent",
    "msdata:child": "OrderSku",
    "msdata:parentkey": "OrderSkuId",
    "msdata:childkey": "OrderSkuId"
    }
    }
    ]
    }
    ]
    }
    ]
    }
    ],
    "diffgr:diffgram": [
    {
    "$": {
    "xmlns:msdata": "urn:schemas-microsoft-com:xml-msdata",
    "xmlns:diffgr": "urn:schemas-microsoft-com:xml-diffgram-v1"
    },
    "OrderDto": [
    {
    "$": {
    "xmlns": "http://tempuri.org/OrderDto.xsd"
    },
    "Order": [
    {
    "$": {
    "diffgr:id": "Order1",
    "msdata:rowOrder": "0"
    },
    "OrderId": [
    {
    "_": "1111111"
    }
    ],
    "Email": [
    {
    "_": "janedoe@yahoo.com"
    }
    ],
    "SubTotal": [
    {
    "_": "74.0000"
    }
    ],
    "PaymentType": [
    {
    "_": "11111"
    }
    ],
    "CreditCardType": [
    {
    "_": "1"
    }
    ],
    "CreditCardName": [
    {
    "_": "Jane Doe"
    }
    ],
    "CreditCardNumber": [
    {
    "_": "111111111"
    }
    ],
    "CreditCardExpired": [
    {
    "_": "000000"
    }
    ],
    "CustomerDiscount": [
    {
    "_": "0.0000"
    }
    ],
    "Processed": [
    {
    "_": "true"
    }
    ],
    "BillingAddressId": [
    {
    "_": "11111111"
    }
    ],
    "CustomerId": [
    {
    "_": "111111"
    }
    ],
    "Created": [
    {
    "_": "2020-05-25T07:45:04.603-05:00"
    }
    ],
    "Completed": [
    {
    "_": "2020-05-25T07:45:04.62-05:00"
    }
    ],
    "ShippingCost": [
    {
    "_": "7.9500"
    }
    ],
    "CurrencyId": [
    {
    "_": "USD"
    }
    ],
    "CreditCardCSC": [
    {}
    ],
    "Tax": [
    {
    "_": "5.7400"
    }
    ],
    "AuthorizationCode": [
    {
    "_": "000000"
    }
    ],
    "OrderStatusId": [
    {
    "_": "1"
    }
    ],
    "Charge": [
    {
    "_": "87.6900"
    }
    ],
    "OrderAuthorizationCode": [
    {
    "_": "code"
    }
    ],
    "LastEditDate": [
    {
    "_": "2020-05-25T07:45:04.62-05:00"
    }
    ],
    "ExpirationDate": [
    {
    "_": "2020-05-25T07:45:04.62-05:00"
    }
    ],
    "SMSAddress": [
    {
    "_": "1"
    }
    ],
    "ShippingMethodId": [
    {
    "_": "11"
    }
    ],
    "ShippingAddressId": [
    {
    "_": "1111111"
    }
    ],
    "UpdateShipping": [
    {
    "_": "false"
    }
    ],
    "UpdateBilling": [
    {
    "_": "false"
    }
    ],
    "FinalTax": [
    {
    "_": "5.7400"
    }
    ],
    "TaxesPaidBy": [
    {
    "_": "1"
    }
    ],
    "IsShippingTaxed": [
    {
    "_": "True"
    }
    ],
    "ShippingTax": [
    {
    "_": "0.5600"
    }
    ],
    "FinalShippingTax": [
    {
    "_": "0.5600"
    }
    ],
    "IsShipToConsultant": [
    {
    "_": "False"
    }
    ],
    "MasterOrderId": [
    {
    "_": "1111111"
    }
    ],
    "BeeNumber": [
    {
    "_": "111111"
    }
    ],
    "EventId": [
    {
    "_": "111111"
    }
    ],
    "OrderTotal": [
    {
    "_": "87.6900"
    }
    ],
    "OrderTypeId": [
    {
    "_": "AM"
    }
    ],
    "TaxTransactionId": [
    {
    "_": "111111111"
    }
    ],
    "IsHostOrder": [
    {
    "_": "false"
    }
    ],
    "MOHostIDPrimary": [
    {
    "_": "529177"
    }
    ],
    "IsHostShipToConsultant": [
    {
    "_": "false"
    }
    ],
    "IsHostShipToHost": [
    {
    "_": "false"
    }
    ],
    "IsConsultantShipToConsultant": [
    {
    "_": "false"
    }
    ],
    "IsConsultantShipToHost": [
    {
    "_": "false"
    }
    ]
    }
    ],
    "OrderSku": [
    {
    "$": {
    "diffgr:id": "OrderSku1",
    "msdata:rowOrder": "0"
    },
    "OrderSkuId": [
    {
    "_": "11111111"
    }
    ],
    "OrderId": [
    {
    "_": "11111111"
    }
    ],
    "SkuId": [
    {
    "_": "1111"
    }
    ],
    "Quantity": [
    {
    "_": "1"
    }
    ],
    "Price": [
    {
    "_": "15.0000"
    }
    ],
    "Discount": [
    {
    "_": "0.0000"
    }
    ],
    "Shipped": [
    {
    "_": "true"
    }
    ],
    "BuyingDiscount": [
    {
    "_": "0.0000"
    }
    ],
    "TaxAmount": [
    {
    "_": "1.0500"
    }
    ],
    "POEPriceID": [
    {
    "_": "1111"
    }
    ],
    "Conversion": [
    {
    "_": "1"
    }
    ],
    "CategoryID": [
    {
    "_": "111"
    }
    ],
    "BackorderQuantity": [
    {
    "_": "0"
    }
    ],
    "FinalTax": [
    {
    "_": "1.0500"
    }
    ],
    "TaxPercentage": [
    {
    "_": "0.0700"
    }
    ],
    "PriceCharged": [
    {
    "_": "15.0000"
    }
    ],
    "UOM": [
    {
    "_": "Each"
    }
    ],
    "Code": [
    {
    "_": "1111111111"
    }
    ],
    "POEPriceID1": [
    {
    "_": "1111"
    }
    ]
    },
    {
    "$": {
    "diffgr:id": "OrderSku2",
    "msdata:rowOrder": "1"
    },
    "OrderSkuId": [
    {
    "_": "1111111111"
    }
    ],
    "OrderId": [
    {
    "_": "1111111"
    }
    ],
    "SkuId": [
    {
    "_": "11111"
    }
    ],
    "Quantity": [
    {
    "_": "1"
    }
    ],
    "Price": [
    {
    "_": "59.0000"
    }
    ],
    "Discount": [
    {
    "_": "0.0000"
    }
    ],
    "Shipped": [
    {
    "_": "true"
    }
    ],
    "BuyingDiscount": [
    {
    "_": "0.0000"
    }
    ],
    "TaxAmount": [
    {
    "_": "4.1300"
    }
    ],
    "POEPriceID": [
    {
    "_": "11111"
    }
    ],
    "Conversion": [
    {
    "_": "1"
    }
    ],
    "CategoryID": [
    {
    "_": "111"
    }
    ],
    "BackorderQuantity": [
    {
    "_": "0"
    }
    ],
    "FinalTax": [
    {
    "_": "4.1300"
    }
    ],
    "TaxPercentage": [
    {
    "_": "0.0700"
    }
    ],
    "PriceCharged": [
    {
    "_": "59.0000"
    }
    ],
    "UOM": [
    {
    "_": "Each"
    }
    ],
    "Code": [
    {
    "_": "11111111"
    }
    ],
    "POEPriceID1": [
    {
    "_": "11111"
    }
    ]
    }
    ],
    "OrderSkuShipment": [
    {
    "$": {
    "diffgr:id": "OrderSkuShipment1",
    "msdata:rowOrder": "0"
    },
    "OrderSkuShipmentId": [
    {
    "_": "111111"
    }
    ],
    "OrderShipmentId": [
    {
    "_": "111111"
    }
    ],
    "OrderSkuId": [
    {
    "_": "1111111"
    }
    ],
    "Quantity": [
    {
    "_": "1"
    }
    ],
    "Tax": [
    {
    "_": "1.0500"
    }
    ]
    },
    {
    "$": {
    "diffgr:id": "OrderSkuShipment2",
    "msdata:rowOrder": "1"
    },
    "OrderSkuShipmentId": [
    {
    "_": "1111111"
    }
    ],
    "OrderShipmentId": [
    {
    "_": "111111"
    }
    ],
    "OrderSkuId": [
    {
    "_": "1111111"
    }
    ],
    "Quantity": [
    {
    "_": "1"
    }
    ],
    "Tax": [
    {
    "_": "4.1300"
    }
    ]
    }
    ],
    "OrderShipment": [
    {
    "$": {
    "diffgr:id": "OrderShipment1",
    "msdata:rowOrder": "0"
    },
    "OrderShipmentId": [
    {
    "_": "111111"
    }
    ],
    "TrackingNumber": [
    {
    "_": "1111111111111111"
    }
    ],
    "ShipmentDate": [
    {
    "_": "2020-05-27T00:00:00-05:00"
    }
    ],
    "OrderId": [
    {
    "_": "111111"
    }
    ],
    "ShipmentStatusId": [
    {
    "_": "1"
    }
    ],
    "ShippingMethod": [
    {
    "_": "USPSPriorityDIRECT795"
    }
    ],
    "ShippingSpeed": [
    {
    "_": "Standard"
    }
    ],
    "ShippingCost": [
    {
    "_": "7.9500"
    }
    ],
    "AddressId": [
    {
    "_": "111111"
    }
    ],
    "Tax": [
    {
    "_": "5.7400"
    }
    ],
    "Charge": [
    {
    "_": "87.6900"
    }
    ],
    "CustomerDiscount": [
    {
    "_": "0.0000"
    }
    ]
    }
    ],
    "OrderPayment": [
    {
    "$": {
    "diffgr:id": "OrderPayment1",
    "msdata:rowOrder": "0"
    },
    "OrderPaymentID": [
    {
    "_": "111111"
    }
    ],
    "OrderID": [
    {
    "_": "11111"
    }
    ],
    "PaymentTypeID": [
    {
    "_": "111111"
    }
    ],
    "PaymentName": [
    {
    "_": "Credit Card"
    }
    ],
    "CreditCardType": [
    {
    "_": "type"
    }
    ],
    "CreditCardName": [
    {
    "_": "Jane Doe"
    }
    ],
    "CreditCardNumber": [
    {
    "_": "44444444"
    }
    ],
    "CreditCardExpired": [
    {
    "_": "000000"
    }
    ],
    "AuthorizationCode": [
    {
    "_": "000000"
    }
    ],
    "BankAccountNumber": [
    {}
    ],
    "BankRoutingNumber": [
    {}
    ],
    "BankAccountType": [
    {}
    ],
    "BankName": [
    {}
    ],
    "BankAccountName": [
    {}
    ],
    "LicenseNumber": [
    {}
    ],
    "LicenseDOB": [
    {}
    ],
    "LicenseState": [
    {}
    ],
    "CheckNumber": [
    {}
    ],
    "Charge": [
    {
    "_": "87.6900"
    }
    ],
    "TextResponse": [
    {
    "_": "Approved"
    }
    ],
    "Processed": [
    {
    "_": "true"
    }
    ],
    "ConfirmationCode": [
    {}
    ],
    "AuthTime": [
    {
    "_": "2020-05-25T07:44:18-05:00"
    }
    ],
    "AddressID": [
    {
    "_": "6530500"
    }
    ],
    "TransactionId": [
    {
    "_": "11111111"
    }
    ],
    "AVS": [
    {}
    ],
    "BalancingPayment": [
    {
    "_": "false"
    }
    ],
    "SerialNumber": [
    {}
    ],
    "BeeBusinessGuid": [
    {}
    ]
    }
    ],
    "Sku": [
    {
    "$": {
    "diffgr:id": "Sku1",
    "msdata:rowOrder": "0"
    },
    "SkuId": [
    {
    "_": "1111"
    }
    ],
    "IsAutoShip": [
    {
    "_": "false"
    }
    ]
    },
    {
    "$": {
    "diffgr:id": "Sku2",
    "msdata:rowOrder": "1"
    },
    "SkuId": [
    {
    "_": "111111"
    }
    ],
    "IsAutoShip": [
    {
    "_": "false"
    }
    ]
    }
    ]
    }
    ]
    }
    ]
    }
    }
    ]
    }
    0
  • David Gollom Strategic Partner
    Top Contributor
    Celigo University Level 4: Legendary
    Answer Pro
    Great Answer
    Engaged

    Hey Guys,

    I've been working on a lookup that also returns XML data.  I'm assuming based on this thread that XPath is the language to use specifying the paths to the data?? Can all the xpath functions be used?? 

    Thanks! 

    0
  • Courtney Jordan Experience Strategy & Design Director Community moderator
    Celigo University Level 4: Legendary
    Awesome Follow-up
    Top Contributor

    Hi David Gollom,

    I'm looking into this for you and will get back to you as soon as I have an answer.

    0
  • Courtney Jordan Experience Strategy & Design Director Community moderator
    Celigo University Level 4: Legendary
    Awesome Follow-up
    Top Contributor

    Hi David Gollom,

    Yes, XPath is the language to use to specify the paths to the data. And yes, we support the full xPath for XML responses. With that said, we have the limit of 5MB on the XML response on which the xPath is to be applied. Good luck and let us know if you have more questions we can help with!

    0

Please sign in to leave a comment.