Return list of values from list inside json

Question

I have a json and I'd like to get only specific values into a list. I can do this just fine iterating through, but I'm wondering if there's an easy one-liner list comprehension method to do this. Suppose I have a json:

{
    "results": {
        "types": 
        [
            {
                "ID": 1
                "field": [
                    {
                        "type": "date",
                        "field": "PrjDate"
                    },
                    {
                        "type": "date",
                        "field": "ComplDate"
                    }
                ]
            }
        ]
    }
}

I'd like to get all of the field values into a single list:

fieldsList = ['PrjDate', 'ComplDate']

I can do this easily with

for types in myjson['results']['types']:
    fieldsList = []
    for fields in types['field']:
        fieldsList.append(fields['field'])

But that seems unnecessarily clunky, is there an easy one-liner list comprehension method I can use here?

@marekful yes there will usually be more than one element in there. See edit, there was an ID field I forgot to include. — AGH_TORN
– AGH_TORN, Commented Feb 13, 2019 at 17:38

kederrac · Accepted Answer · 2019-02-13 17:40:27Z

2

You could try

myfields = [fields['field'] for types in myjson['results']['types'] for fields in types['field']]

answered Feb 13, 2019 at 17:40

kederrac

17.4k6 gold badges36 silver badges58 bronze badges

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

Collectives™ on Stack Overflow

Return list of values from list inside json

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related