Question 335933 in Json Question posted in
Our archive of expertly curated questions and answers provides insights and solutions to common problems related to this popular data interchange format. From parsing and manipulating JSON data to integrating it with various programming languages and web services, our archive has got you covered. Start exploring today and take your JSON skills to the next level

How to search JSON for data, get vlaues from that array in Python

I have the below JSON. I want to search each array, and only scrape the data from the array which has keys and values in the "source" block, ignoring arrays which have an empty "source" block.
Here is the JSON:

{
    "L": [
        {
            "operation_no": 123456,
            "key1": "value1",
            "keys": {
                "no_seq": "1234",
                "external_key": null
            },
            "key2": 10234,
            "territory": {
                "territory_no": 1
            },
            "key3": "value",
            "source": []
        },
        {
            "operation_no": 123458,
            "key1": "value3",
            "keys": {
                "no_seq": "1237",
                "external_key": null
            },
            "key2": 10237,
            "territory": {
                "territory_no": 1
            },
            "key3": "value",
            "source": [
                {
                    "source1": "fhry4645fsgaa1",
                    "source2": "123egst36535a1"
                },
                {
                    "source1": "fhry4645fsgaa2",
                    "source2": "123egst36535a2"
                }
            ]
        }
    ]
}

So, for example, the lower array which has "source" keys and values, I want to get the "operation_no" value (123458), but ignore the "operation_no" value thats has an empty "source" block (the first array).
How would I go about this using Python?

Tags:

2

Answers


  1. 0

    You can check for the length of "source", if it’s not equal to 0, add it to a new list (here "usable_data) to work with it later. You can also add it to a new dictionary, of course.

    my_dict = {
    "L": [
        {
            "operation_no": 123456,
            "key1": "value1",
            "keys": {
                "no_seq": "1234",
                "external_key": None
            },
            "key2": 10234,
            "territory": {
                "territory_no": 1
            },
            "key3": "value",
            "source": []
        },
        {
            "operation_no": 123458,
            "key1": "value3",
            "keys": {
                "no_seq": "1237",
                "external_key": None
            },
            "key2": 10237,
            "territory": {
                "territory_no": 1
            },
            "key3": "value",
            "source": [
                {
                    "source1": "fhry4645fsgaa1",
                    "source2": "123egst36535a1"
                },
                {
                    "source1": "fhry4645fsgaa2",
                    "source2": "123egst36535a2"
                }
            ]
        }
    ]
}

usable_data = []
for element in my_dict["L"]:
    if len(element["source"]) != 0:
        usable_data.append(element)
    Login or Signup to reply.
  2. 0

    The JSON data is presumably available as a string (perhaps from a file). Once you have the JSON as a string then:

    import json

JSTR = '''{
    "L": [
        {
            "operation_no": 123456,
            "key1": "value1",
            "keys": {
                "no_seq": "1234",
                "external_key": null
            },
            "key2": 10234,
            "territory": {
                "territory_no": 1
            },
            "key3": "value",
            "source": []
        },
        {
            "operation_no": 123458,
            "key1": "value3",
            "keys": {
                "no_seq": "1237",
                "external_key": null
            },
            "key2": 10237,
            "territory": {
                "territory_no": 1
            },
            "key3": "value",
            "source": [
                {
                    "source1": "fhry4645fsgaa1",
                    "source2": "123egst36535a1"
                },
                {
                    "source1": "fhry4645fsgaa2",
                    "source2": "123egst36535a2"
                }
            ]
        }
    ]
}'''

data = json.loads(JSTR)

for d in data.get("L", []):
    if d.get("source") and (operation_no := d.get("operation_no")):
        print(f"{operation_no=}")

    Output:

    operation_no=123458
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search