I think I have got it working outside of that, the app didn't like switch adding [X] inside variables to separate data under similar headings from the XML.
Any reason why it reverses the JSON?
e.g.
Code: Select all
{
"Orders": [{
"UniqueSubmitOrderID": "string",
"Status": {
"Value": 0,
"EnumType": "string"
},
"InvoiceCustomer": {
"Code": "LEXNEX",
"Contact": "API Invoice Contact",
"ContactEmail": "nz.api@printing.com"
},
"DeliveryCustomer": {
"Name": "[Metadata.Text:Path="/cXML/Request/OrderRequest/OrderRequestHeader/ShipTo/Address/Name",Dataset="Xml",Model="XML"]",
"Address": {
"AddressLines": ["[Metadata.Text:Path="/cXML/Request/OrderRequest/OrderRequestHeader/ShipTo/Address/PostalAddress/Street1",Dataset="Xml",Model="XML"]", "[Metadata.Text:Path="/cXML/Request/OrderRequest/OrderRequestHeader/ShipTo/Address/PostalAddress/Street2",Dataset="Xml",Model="XML"]", "[Metadata.Text:Path="/cXML/Request/OrderRequest/OrderRequestHeader/ShipTo/Address/PostalAddress/Street3",Dataset="Xml",Model="XML"]", "[Metadata.Text:Path="/cXML/Request/OrderRequest/OrderRequestHeader/ShipTo/Address/PostalAddress/Street4",Dataset="Xml",Model="XML"]"],
"City": "[Metadata.Text:Path="/cXML/Request/OrderRequest/OrderRequestHeader/ShipTo/Address/PostalAddress/City",Dataset="Xml",Model="XML"]",
"Region": "[Metadata.Text:Path="/cXML/Request/OrderRequest/OrderRequestHeader/ShipTo/Address/PostalAddress/City",Dataset="Xml",Model="XML"]",
"Country": "[Metadata.Text:Path="/cXML/Request/OrderRequest/OrderRequestHeader/ShipTo/Address/PostalAddress/Country",Dataset="Xml",Model="XML"]",
"Postcode": "[Metadata.Text:Path="/cXML/Request/OrderRequest/OrderRequestHeader/ShipTo/Address/PostalAddress/PostalCode",Dataset="Xml",Model="XML"]"
},
"Contact": "API Delivery Contact",
"ContactEmail": "nz.api@printing.com"
},
"Ref1": "[Metadata.Text:Path="/cXML/Request/OrderRequest/OrderRequestHeader/@orderID",Dataset="Xml",Model="XML"]",
"Items": {
"StockItemID": "13185",
"Quantity": "[Metadata.Text:Path="/cXML/Request/OrderRequest/ItemOut/@quantity",Dataset="Xml",Model="XML"]",
"Ref1": "[Metadata.Text:Path="/cXML/Request/OrderRequest/ItemOut/ItemDetail/Description",Dataset="Xml",Model="XML"]"
}
}]
}
is coming out as
Code: Select all
{"Orders":[{"DeliveryCustomer":{"Address":{"AddressLines":["Auckland District Law Society","Attn: Richard Ormiston","2 Chancery St","undefined"],"City":"Auckland","Country":"NEW ZEALAND","Postcode":"1140","Region":"Auckland"},"Contact":"API Delivery Contact","ContactEmail":"nz.api@printing.com","Name":"The Law Society Store"},"InvoiceCustomer":{"Code":"LEXNEX","Contact":"API Invoice Contact","ContactEmail":"nz.api@printing.com"},"Items":{"Quantity":"000000005","Ref1":"Dobbie's 6th ed","StockItemID":"13185"},"Ref1":"D00645022","Status":{"EnumType":"string","Value":0},"UniqueSubmitOrderID":"string"}]}