(Chilkat2-Python) Find and Delete Object from JSON Array

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

Chilkat2 Python Downloads install with pip pip3 install chilkat2 or download... Python Module for Windows, Linux, Alpine Linux, MacOS, Solaris

import sys
import chilkat2

# 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"
# 			}
# 		]
# 	  }
# 	]
# }

json = chilkat2.JsonObject()
success = json.LoadFile("qa_data/json/menus.json")
if (success == False):
    print(json.LastErrorText)
    sys.exit()

# Find Menu B.
# menu is a CkJsonObject
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.
# catArr is a CkJsonArray
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"
index = catArr.FindObject("name","Pasta",True)
if (index < 0):
    print("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
print(json.Emit())