...
In the advanced mapping editor must be as follows:
Code Block | ||
---|---|---|
| ||
{ "BookingReference": "{{Dispatch.SalesOrderReference}}", "GoodsDispatchedDate": "{{Dispatch.DispatchDate}}", "GoodsDispatch": [ {{ for item in List.DispatchLineItem }} { "Sku": "{{item.ProductCode}}", "ProductColour": {{ if (item.ProductColour) }}"{{item.ProductColour}}"{{ else }}null{{end}}, "ProductDescription": {{ if (item.ProductDescription) }}"{{item.ProductDescription}}"{{ else }}null{{end}}, "ProductGrossWeight": {{ if (item.ProductGrossWeight) }}{{ item.ProductGrossWeight }}{{ else }}null{{end}}, "ProductSize": {{ if (item.ProductSize) }}"{{item.ProductSize}}"{{ else }}null{{end}}, }, {{ end }} ] } |
...
In the advanced mapping editor must be as follows:
Code Block | ||
---|---|---|
| ||
{ "BookingReference": "{{ GRN.HBRef}}", "ConfirmedDate": {{ if (GRN.ConfirmedDate) }}"{{ GRN.ConfirmedDate }}"{{ else }}null{{end}}, "Receipts": [ {{ for item in List.GRNLineItem }} { "Sku": "{{ item.ProductCode }}", "Quantity": {{ item.Quantity}} }, {{ end }} ] } |