Get property in nested JSON Python

Question

I am trying to get the values of the properties in JSON but I'm having a hard time fetching the ones inside an object array.

I have a function that gets a test JSON which has these lines of code:

def get_test_body() -> str:
    directory = str(pathlib.Path(__file__).parent.parent.as_posix())
    f = open(directory + '/tests/json/test.json', "r")
    body = json.loads(f.read())
    f.close()  
    return body

This is the first half of the JSON file (modified the names):

"id": "112358",
"name": "test",
"source_type": "SqlServer",
"connection_string_name": "123134-SQLTest-ConnectionString",
"omg_test": "12312435-123123-41232b5-asd123-1232145",
"triggers": [
    {
        "frequency": "Day",
        "interval": 1,
        "start_time": "2019-06-17T21:37:00",
        "end_time": "2019-06-18T21:37:00",
        "schedule": [
            {
                "hours": [
                    2
                ],
                "minutes": [
                    0
                ],
                "week_days": [],
                "month_days": [],
                "monthly_occurrences": []
            }
        ]
    }
]

The triggers has more objects within it I couldn't figure out the syntax for it.

I am then able to fetch the some of the data using: name = body['name']

But I couldn't fetch anything under the triggers Array. I tried using body['triggers']['frequency'] and even ['triggers'][0] (lol) but I couldn't get it to work. I'm fairly new to Python any help would be appreciated!

Alexander Riedel · Accepted Answer · 2020-12-01 14:31:07Z

1

I getting the right output, even with bwhat you did?

import json
string = """
{
"id": "112358",
"name": "test",
"source_type": "SqlServer",
"connection_string_name": "123134-SQLTest-ConnectionString",
"omg_test": "12312435-123123-41232b5-asd123-1232145",
"triggers": [
    {
        "frequency": "Day",
        "interval": 1,
        "start_time": "2019-06-17T21:37:00",
        "end_time": "2019-06-18T21:37:00",
        "schedule": [
            {
                "hours": [
                    2
                ],
                "minutes": [
                    0
                ],
                "week_days": [],
                "month_days": [],
                "monthly_occurrences": []
            }
        ]
    }
]
}
"""
str_dict = json.loads(string)

print(str_dict["triggers"][0]["frequency"])

Giving me Day

answered Dec 1, 2020 at 14:31

Alexander Riedel

1,3591 gold badge10 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Alexander Espiritu Over a year ago

Oh man I didn't even think of combining what I did. Thank you!

Collectives™ on Stack Overflow

Get property in nested JSON Python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related