C#

Find and Delete Object from JSON Array

See more JSON Examples

Demonstrates how to find an delete an object from a JSON array of objects. C#

bool success = false;

// This example will delete the "Pasta" category object from Menu B.

// {
//   "menus": [
//     {
//       "name": "Menu A",
//       "categories": [
// 			{
// 			"name": "Kebabs",
// 			"description": "blah blah blah"
// 			},
// 			{
// 			"name": "Burgers",
// 			"description": "blah blah blah"
// 			},
// 			{
// 			"name": "Pasta",
// 			"description": "blah blah blah"
// 			},
// 			{
// 			"name": "Appetizers",
// 			"description": "blah blah blah"
// 			}
// 		]
// 	},
//     {
//       "name": "Menu B",
//       "categories": [
// 			{
// 			"name": "Kebabs",
// 			"description": "blah blah blah"
// 			},
// 			{
// 			"name": "Burgers",
// 			"description": "blah blah blah"
// 			},
// 			{
// 			"name": "Pasta",
// 			"description": "blah blah blah"
// 			},
// 			{
// 			"name": "Appetizers",
// 			"description": "blah blah blah"
// 			}
// 		]
// 	  }
// 	]
// }

Chilkat.JsonObject json = new Chilkat.JsonObject();
success = json.LoadFile("qa_data/json/menus.json");
if (success == false) {
    Debug.WriteLine(json.LastErrorText);
    return;
}

// Find Menu B.
Chilkat.JsonObject menu = json.FindRecord("menus","name","Menu B",true);
// assume menu is found..

// Get the categories array, and then find the index of the "Pasta" menu category.
Chilkat.JsonArray catArr = menu.ArrayOf("categories");
// Assume it is found..

// Find the object where the name of the JSON member is "name", and the value is "Pasta"
int index = catArr.FindObject("name","Pasta",true);
if (index < 0) {
    Debug.WriteLine("Pasta not found.");
}
else {

    // Delete the "Pasta" category record from Menu B
    success = catArr.DeleteAt(index);
    // Assume OK..
}

// Examine the JSON to see if it worked as expected..
json.EmitCompact = false;
Debug.WriteLine(json.Emit());