(Node.js) 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.

Install Chilkat for Node.js and Electron using npm at Chilkat npm packages for Node.js Chilkat npm packages for Electron on Windows, Linux, MacOSX, and ARM

var os = require('os');
if (os.platform() == 'win32') {  
    if (os.arch() == 'ia32') {
        var chilkat = require('@chilkat/ck-node21-win-ia32');
    } else {
        var chilkat = require('@chilkat/ck-node21-win64'); 
    }
} else if (os.platform() == 'linux') {
    if (os.arch() == 'arm') {
        var chilkat = require('@chilkat/ck-node21-arm');
    } else if (os.arch() == 'x86') {
        var chilkat = require('@chilkat/ck-node21-linux32');
    } else {
        var chilkat = require('@chilkat/ck-node21-linux64');
    }
} else if (os.platform() == 'darwin') {
    if (os.arch() == 'arm64') {
        var chilkat = require('@chilkat/ck-node21-mac-m1');
    } else {
        var chilkat = require('@chilkat/ck-node21-macosx');
    }
}

function chilkatExample() {

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

    // Batch 2 File
    var 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"}]}

    var success = true;
    var json1 = new chilkat.JsonObject();
    json1.Load(a1);

    var json2 = new chilkat.JsonObject();
    json2.Load(a2);

    // We're going to add the order records from json2 to json1.
    // jarr1: JsonArray
    var jarr1 = json1.ArrayOf("payload.Orders");
    // jarr2: JsonArray
    var jarr2 = json2.ArrayOf("payload.Orders");

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

    // Show the merged JSON.
    json1.EmitCompact = false;
    console.log(json1.Emit());

    // Result:

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

}

chilkatExample();