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.
Hi, @hristinabendeva615.
Could you try using a virgule (/) to build the path instead of JSON dot (.) notation?
/OrderDto/diffgr:diffgram/OrderDto/Order/OrderIdPlease see the XPATH examples in HTTP exports > Non-standard API response patterns.
Hi @stephenbrandt-Stephen-Brandt" rel="nofollow noreferrer">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,
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
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
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!
Hi @davidgollom,
I'm looking into this for you and will get back to you as soon as I have an answer.
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!
Hello @mattgraney-Matt-Graney" rel="nofollow noreferrer">Matt Graney,
Here is the "HTTP response | Body" panel.
<?xml version="1.0" encoding="utf-8"?>
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
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"
}
]
}
]
}
]
}
]
}
}
]
}