Problem to parse a json

[enigma619]

Hi

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33

{     "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:

1 2 3 4

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

I'm trying with

1 2 3 4 5

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:

1 2 3

check1 CRITICAL check2 CRITICAL check3 CRITICAL

If someone has an idea..
Thanks for any help

Alex

[enigma619]

I think I' ve found the solution:

1 2 3 4

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:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47

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.

1	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.