B4X

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. B4X

Dim success As Boolean = False

'  Batch 1 File
Dim a1 As String = "{" & Chr(34) & "payload" & Chr(34) & ": {" & Chr(34) & "Orders" & Chr(34) & ": [{" & Chr(34) & "AmazonOrderId" & Chr(34) & ": " & Chr(34) & "1" & Chr(34) & "," & Chr(34) & "OrderStatus" & Chr(34) & ": " & Chr(34) & "Unshipped" & Chr(34) & "},{" & Chr(34) & "AmazonOrderId" & Chr(34) & ": " & Chr(34) & "2" & Chr(34) & "," & Chr(34) & "OrderStatus" & Chr(34) & ": " & Chr(34) & "Unshipped" & Chr(34) & "}]}"

'  Batch 2 File
Dim a2 As String = "{" & Chr(34) & "payload" & Chr(34) & ": {" & Chr(34) & "Orders" & Chr(34) & ": [{" & Chr(34) & "AmazonOrderId" & Chr(34) & ": " & Chr(34) & "3" & Chr(34) & "," & Chr(34) & "OrderStatus" & Chr(34) & ": " & Chr(34) & "Unshipped" & Chr(34) & "},{" & Chr(34) & "AmazonOrderId" & Chr(34) & ": " & Chr(34) & "4" & Chr(34) & "," & Chr(34) & "OrderStatus" & Chr(34) & ": " & Chr(34) & "Unshipped" & Chr(34) & "}]}"

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

success = True
Dim json1 As ChilkatJsonObject
json1.Initialize
json1.Load(a1)

Dim json2 As ChilkatJsonObject
json2.Initialize
json2.Load(a2)

'  We're going to add the order records from json2 to json1.
Dim jarr1 As ChilkatJsonArray = json1.ArrayOf("payload.Orders")
Dim jarr2 As ChilkatJsonArray = json2.ArrayOf("payload.Orders")

Dim i As Int = 0
Dim numOrders As Int = jarr2.Size
Do While (i < numOrders)
    Dim jOrder As ChilkatJsonObject = jarr2.ObjectAt(i)
    '  Assuming non-null return...
    jarr1.AddObjectCopyAt(-1, jOrder)
    i = i + 1
Loop

'  Show the merged JSON.
json1.EmitCompact = False
Log(json1.Emit)

'  Result:

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