.NET Core 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. .NET Core 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"
//       }
//     ]
//   }
// }