C#

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. C#

bool success = false;

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

//  Batch 2 File
string 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;
Chilkat.JsonObject json1 = new Chilkat.JsonObject();
json1.Load(a1);

Chilkat.JsonObject json2 = new Chilkat.JsonObject();
json2.Load(a2);

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

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

//  Show the merged JSON.
json1.EmitCompact = false;
Debug.WriteLine(json1.Emit());

//  Result:

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