Postman- Retrieve specific key values from JSON object

How to get the specific key values in the form of an Array or List.

e.g.

{
    "description": "demo",
    "status": "test",
    "name": "mytest",
    "members": [
        {
            "UserId": "886af1af66",
            "Name": "u1",
            "email": "user1@test.com"
        },
        {
            "UserId": "0aa280686",
            "Name": "u2",
            "email": "user2@test.com"
        },
        {
            "UserId": "0dc888888",
            "Name": "u3",
            "email": "user3@test.com"
        }
    ]
}

Expected outcome: [‘user1@test.com’,‘user2@test.com’,‘user3@test.com’]

Postman uses JavaScript under the hood, so this is more of a JavaScript query.

This can be achieved using the JavaScript map function.

JavaScript Array map() Method (w3schools.com)

const response = pm.response.json();
let emails = response.members.map(members => members.email);
console.log(emails);

image

1 Like