# Success Path in XML Lookups **URL:** \ **Category:** Integrator.io\ **Tags:** xml, json, lookup, flow-builder\ **Created:** [January 28, 2021, 8:33am UTC](https://connective.celigo.com/t/success-path-in-xml-lookups/1272 "2021-01-28T08:33:31Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![hristinabendeva](https://avatars.discourse-cdn.com/v4/letter/h/97f17d/32.png) [@hristinabendeva](https://connective.celigo.com/u/hristinabendeva)\ **Post date:** [January 28, 2021, 8:33am UTC](https://connective.celigo.com/t/success-path-in-xml-lookups/1272/1 "2021-01-28T08:33:31Z")
Hello, I have a flow where I have a Lookup that returns a XML response and another one that returns a JSON response. I set the success path in the JSON Lookup and it works but the one in the XML Lookup doesn't. I tried using XPath as well as JSON Path but it doesn't work. Here are photos from both Lookups and a photo of the XML response in postman where I marked the element I'm trying to use as a success path. ![5301043caa20740200000001-9eab078ced4b48f78e55c608db1a1a58.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/c/c3fc7bd8a74383c8426c00edd89284fd350f39c4.png) ![5301043caa20740200000001-2361f7abf6c6446baf93bcdb152a95a0.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/1/15586b219da7343d66261b67fe5e08213b3ccf58.png) ![5301043caa20740200000001-c37544ec9baa414db70630b2b3f6ec5a.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/3/303fb564618a9a0dca9c5fd9a63691b0bba4d6e8.png) ---
**Author:** ![stephenbrandt](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/stephenbrandt/32/6891_2.png) [@stephenbrandt](https://connective.celigo.com/u/stephenbrandt)\ **Post date:** [January 28, 2021, 4:36pm UTC](https://connective.celigo.com/t/success-path-in-xml-lookups/1272/2 "2021-01-28T16:36:03Z")
Hi, @hristinabendeva615. 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](https://docs.celigo.com/hc/en-us/articles/360044407971-Export-data-from-an-HTTP-connection#NonstandardAPIresponsepatterns). ---
**Author:** ![hristinabendeva](https://avatars.discourse-cdn.com/v4/letter/h/97f17d/32.png) [@hristinabendeva](https://connective.celigo.com/u/hristinabendeva)\ **Post date:** [January 30, 2021, 11:48am UTC](https://connective.celigo.com/t/success-path-in-xml-lookups/1272/3 "2021-01-30T11:48:00Z")
Hi [@stephenbrandt](https://connective.celigo.com/hc/en-us/profiles/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, ---
**Author:** ![mattgraney](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/mattgraney/32/6606_2.png) [@mattgraney](https://connective.celigo.com/u/mattgraney)\ **Post date:** [January 31, 2021, 8:43pm UTC](https://connective.celigo.com/t/success-path-in-xml-lookups/1272/4 "2021-01-31T20:43:23Z")
Hi @hristinabendeva615, 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 ---
**Author:** ![anirudhsundaram54](https://avatars.discourse-cdn.com/v4/letter/a/13edae/32.png) [@anirudhsundaram54](https://connective.celigo.com/u/anirudhsundaram54)\ **Post date:** [February 1, 2021, 10:42pm UTC](https://connective.celigo.com/t/success-path-in-xml-lookups/1272/5 "2021-02-01T22:42:01Z")
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']` `` ![5301043caa20740200000001-307ffbe9ccde4a8aae6caecf167cd746.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/3/319cdf2a1d097a4440bd3fa6baef517c6b8bda11.png) Thanks, Anirudh ---
**Author:** ![davidgollom](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/davidgollom/32/6605_2.png) [@davidgollom](https://connective.celigo.com/u/davidgollom)\ **Post date:** [February 11, 2021, 3:07am UTC](https://connective.celigo.com/t/success-path-in-xml-lookups/1272/6 "2021-02-11T03:07:33Z")
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! ---
**Author:** ![courtneyjordan](https://avatars.discourse-cdn.com/v4/letter/c/b2d939/32.png) [@courtneyjordan](https://connective.celigo.com/u/courtneyjordan)\ **Post date:** [February 19, 2021, 5:00pm UTC](https://connective.celigo.com/t/success-path-in-xml-lookups/1272/7 "2021-02-19T17:00:03Z")
Hi @davidgollom, I'm looking into this for you and will get back to you as soon as I have an answer. ---
**Author:** ![courtneyjordan](https://avatars.discourse-cdn.com/v4/letter/c/b2d939/32.png) [@courtneyjordan](https://connective.celigo.com/u/courtneyjordan)\ **Post date:** [February 19, 2021, 6:10pm UTC](https://connective.celigo.com/t/success-path-in-xml-lookups/1272/8 "2021-02-19T18:10:25Z")
Hi @davidgollom, 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! ---
**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\ **Post date:** [February 1, 2021, 8:35am UTC](https://connective.celigo.com/t/success-path-in-xml-lookups/1272/9 "2021-02-01T08:35:17Z")
Hello [@mattgraney](https://connective.celigo.com/hc/en-us/profiles/Matt Graney, Here is the "HTTP response | Body" panel. ``` 33333 janedoe@yahoo.com 404.0000 55 2 Jane Doe 545554545 000021 0.0000 true 11111 111111 2018-02-09T09:10:04.123-06:00 2018-02-09T09:10:12.92-06:00 0.0000 USD 22.5500 11111 111 344.8500 code 2018-02-09T09:10:12.92-06:00 2018-02-09T09:10:12.92-06:00 1 24 11111 false false 22.5500 1 False 0.0000 0.0000 False 11111 1111 111222 344.8500 PS 1233131312313 true 284591 false false false false 11111 11111 1111 1 74.0000 true 0.0000 5.1800 5341 1 216 0 5.1800 0.0700 74.0000 Each 3022046042 5341 11111 1111 11111 1 74.0000 true 0.0000 5.1800 5348 1 216 0 5.1800 0.0700 74.0000 Each 3022001042 5348 111111 111111 111111 1 1.7100 11111 11111 11111 1 5.1800 11111 11111 55 Credit Card Name Type Jane Doe 11111111 000021 111111 344.8500 This transaction has been approved. true 1 2018-02-09T09:10:04.123-06:00 1722990 60933700614 P false 1111 false 1111 false 111111 111111 0.0000 FreeShipping Hostess Free Shipping v3 Hostess Free Shipping 111111 111111 1.0000 LimitedEditionCategory Cami Club - party host - spring 2018 Cami Club - Party host ``` ---
**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\ **Post date:** [February 1, 2021, 8:37am UTC](https://connective.celigo.com/t/success-path-in-xml-lookups/1272/10 "2021-02-01T08:37:55Z")
Andthisisthe"ParsedOutput"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":[{"_":"JaneDoe"}],"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":[{"_":"CreditCard"}],"CreditCardType":[{"_":"type"}],"CreditCardName":[{"_":"JaneDoe"}],"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"}]}]}]}]}}]} ```