(PHP ActiveX) 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.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows Note: The php_com_dotnet.dll may need to be enabled inside of php.ini.

<?php

// 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 = 1;
// For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.JsonObject')
$json1 = new COM("Chilkat.JsonObject");
$json1->Load($a1);

// For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.JsonObject')
$json2 = new COM("Chilkat.JsonObject");
$json2->Load($a2);

// We're going to add the order records from json2 to json1.
// jarr1 is a Chilkat.JsonArray
$jarr1 = $json1->ArrayOf('payload.Orders');
// jarr2 is a Chilkat.JsonArray
$jarr2 = $json2->ArrayOf('payload.Orders');

$i = 0;
$numOrders = $jarr2->Size;
while (($i < $numOrders)) {
    // jOrder is a Chilkat.JsonObject
    $jOrder = $jarr2->ObjectAt($i);
    // Assuming non-null return...
    $jarr1->AddObjectCopyAt(-1,$jOrder);
    $i = $i + 1;
}

// Show the merged JSON.
$json1->EmitCompact = 0;
print $json1->emit() . "\n";

// Result:

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

?>