Problem to parse a json

[enigma619]

Hi

I've some problem to parse my json
which is like:

{
    "Results": {
        "check1": {
            "LastResultTime": 1607002708,
            "LastResultTimeH": "2020-12-03 14:38:28 +0100 CET",
            "Status": 0,
            "StatusH": "OK",
            "Origin": "1"
        },
        "check2": {
            "LastResultTime": 1607002934,
            "LastResultTimeH": "2020-12-03 14:42:14 +0100 CET",
            "Status": 0,
            "StatusH": "KO",
            "Origin": "1"
        },
        "check3": {
            "LastResultTime": 1607002934,
            "LastResultTimeH": "2020-12-03 14:42:14 +0100 CET",
            "Status": 2,
            "StatusH": "CRITICAL",
            "Origin": "2"
        }
    },
    "Status": 2,
    "StatusH": "CRITICAL",
    "Maintenance": {
        "Reason": "Ok",
        "Status": 0,
        "StatusH": "STATE_OK",
        "When": "2020-12-03 14:42:14.377955151 +0100 CET m=+0.000776843"
    },
}

I want to parse this json with python and retrieve values like:

Check1 / StatusH / OK
Check2 / StatusH / KO
check3 / StatusH / CRITICAL
etc...

I'm trying with

data = json.loads(json_data.decode(), parse_float=float)
for i in data['Results']:
    for a, b in data.items():
        if (a == "StatusH"):
            print (i,b)

But it doesnt work:

check1 CRITICAL
check2 CRITICAL
check3 CRITICAL

If someone has an idea..
Thanks for any help

Alex

[enigma619]

I think I' ve found the solution:

for i in data['Results']:
    for a,b in data['Results'].items():
        if (a == i):
            print (i, b["StatusH"])

[Larz60+]

what you have is a dictionary, not json.
where is the data stored?
is it in a file which claims to be json? You don't show enough code to know.
at any rate, if you named the dictionary, then you could access it
example:

mydict = {
    "Results": {
        "check1": {
            "LastResultTime": 1607002708,
            "LastResultTimeH": "2020-12-03 14:38:28 +0100 CET",
            "Status": 0,
            "StatusH": "OK",
            "Origin": "1"
        },
        "check2": {
            "LastResultTime": 1607002934,
            "LastResultTimeH": "2020-12-03 14:42:14 +0100 CET",
            "Status": 0,
            "StatusH": "KO",
            "Origin": "1"
        },
        "check3": {
            "LastResultTime": 1607002934,
            "LastResultTimeH": "2020-12-03 14:42:14 +0100 CET",
            "Status": 2,
            "StatusH": "CRITICAL",
            "Origin": "2"
        }
    },
    "Status": 2,
    "StatusH": "CRITICAL",
    "Maintenance": {
        "Reason": "Ok",
        "Status": 0,
        "StatusH": "STATE_OK",
        "When": "2020-12-03 14:42:14.377955151 +0100 CET m=+0.000776843"
    },
}

def display_dict(dictname, level=0):
    indent = " " * (4 * level)
    for key, value in dictname.items():
        if isinstance(value, dict):
            print(f'\n{indent}{key}')
            level += 1
            display_dict(value, level)
        else:
            print(f'{indent}{key}: {value}')
        if level > 0:
            level -= 1

display_dict(mydict)

running produces:

Output:
Results

    check1
        LastResultTime: 1607002708
        LastResultTimeH: 2020-12-03 14:38:28 +0100 CET
        Status: 0
        StatusH: OK
        Origin: 1

    check2
        LastResultTime: 1607002934
        LastResultTimeH: 2020-12-03 14:42:14 +0100 CET
        Status: 0
        StatusH: KO
        Origin: 1

    check3
        LastResultTime: 1607002934
        LastResultTimeH: 2020-12-03 14:42:14 +0100 CET
        Status: 2
        StatusH: CRITICAL
        Origin: 2
Status: 2
StatusH: CRITICAL

Maintenance
    Reason: Ok
    Status: 0
    StatusH: STATE_OK
    When: 2020-12-03 14:42:14.377955151 +0100 CET m=+0.000776843

the code on line 37 does all of the iteration.
Note that the function display_dict is recursive, so nested dictionaries call display_dict in turn.

for key, value in dictname.items()

[enigma619]

Thanks for your detailed answer!
My dictionary is a result of a curl https://....
With your answer I will succeed to retrieve all my values.