Xbase++

Merge SP-API JSON Order Arrays

See more Amazon SP-API Examples

Demonstrates how to merge JSON arrays for the case of Amazon SP-API orders. Xbase++

LOCAL nSuccess
LOCAL cA1
LOCAL cA2
LOCAL oJson1
LOCAL oJson2
LOCAL oJarr1
LOCAL oJarr2
LOCAL i
LOCAL nNumOrders
LOCAL oJOrder

nSuccess := 0

//  Batch 1 File
cA1 := '{"payload": {"Orders": [{"AmazonOrderId": "1","OrderStatus": "Unshipped"},{"AmazonOrderId": "2","OrderStatus": "Unshipped"}]}'

//  Batch 2 File
cA2 := '{"payload": {"Orders": [{"AmazonOrderId": "3","OrderStatus": "Unshipped"},{"AmazonOrderId": "4","OrderStatus": "Unshipped"}]}'

//  Required Merged File
//  {"payload": {"Orders": [{"AmazonOrderId": "1","OrderStatus": "Unshipped"},{"AmazonOrderId": "2","OrderStatus": "Unshipped"},{"AmazonOrderId": "3","OrderStatus": "Unshipped"},{"AmazonOrderId": "4","OrderStatus": "Unshipped"}]}

nSuccess := 1
oJson1 := CreateObject("Chilkat.JsonObject")
oJson1:Load(cA1)

oJson2 := CreateObject("Chilkat.JsonObject")
oJson2:Load(cA2)

//  We're going to add the order records from json2 to json1.
oJarr1 := oJson1:ArrayOf("payload.Orders")
oJarr2 := oJson2:ArrayOf("payload.Orders")

i := 0
nNumOrders := oJarr2:Size
DO WHILE (i < nNumOrders)
    oJOrder := oJarr2:ObjectAt(i)
    //  Assuming non-null return...
    oJarr1:AddObjectCopyAt(-1, oJOrder)
    i := i + 1
ENDDO

//  Show the merged JSON.
oJson1:EmitCompact := 0
? oJson1:Emit()

//  Result:

//  {
//    "payload": {
//      "Orders": [
//        {
//          "AmazonOrderId": "1",
//          "OrderStatus": "Unshipped"
//        },
//        {
//          "AmazonOrderId": "2",
//          "OrderStatus": "Unshipped"
//        },
//        {
//          "AmazonOrderId": "3",
//          "OrderStatus": "Unshipped"
//        },
//        {
//          "AmazonOrderId": "4",
//          "OrderStatus": "Unshipped"
//        }
//      ]
//    }
//  }

oJson1:destroy()
oJson2:destroy()