AutoIt

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

Local $bSuccess = False

;  Batch 1 File
Local $sA1 = "{""payload"": {""Orders"": [{""AmazonOrderId"": ""1"",""OrderStatus"": ""Unshipped""},{""AmazonOrderId"": ""2"",""OrderStatus"": ""Unshipped""}]}"

;  Batch 2 File
Local $sA2 = "{""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"}]}

$bSuccess = True
$oJson1 = ObjCreate("Chilkat.JsonObject")
$oJson1.Load($sA1)

$oJson2 = ObjCreate("Chilkat.JsonObject")
$oJson2.Load($sA2)

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

Local $i = 0
Local $iNumOrders = $oJarr2.Size
While ($i < $iNumOrders)
Local $oJOrder = $oJarr2.ObjectAt($i)
    ;  Assuming non-null return...
    $oJarr1.AddObjectCopyAt(-1,$oJOrder)
    $i = $i + 1
Wend

;  Show the merged JSON.
$oJson1.EmitCompact = False
ConsoleWrite($oJson1.Emit() & @CRLF)

;  Result:

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