Chilkat2-Python

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. Chilkat2-Python

import chilkat2

success = False

# Batch 1 File
a1 = "{\"payload\": {\"Orders\": [{\"AmazonOrderId\": \"1\",\"OrderStatus\": \"Unshipped\"},{\"AmazonOrderId\": \"2\",\"OrderStatus\": \"Unshipped\"}]}"

# Batch 2 File
a2 = "{\"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"}]}

success = True
json1 = chilkat2.JsonObject()
json1.Load(a1)

json2 = chilkat2.JsonObject()
json2.Load(a2)

# We're going to add the order records from json2 to json1.
# jarr1 is a CkJsonArray
jarr1 = json1.ArrayOf("payload.Orders")
# jarr2 is a CkJsonArray
jarr2 = json2.ArrayOf("payload.Orders")

i = 0
numOrders = jarr2.Size
while (i < numOrders) :
    # jOrder is a CkJsonObject
    jOrder = jarr2.ObjectAt(i)
    # Assuming non-null return...
    jarr1.AddObjectCopyAt(-1,jOrder)
    i = i + 1

# Show the merged JSON.
json1.EmitCompact = False
print(json1.Emit())

# Result:

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