Parse JSON response for field values

Asked Jun 07 '22 at 01:35

Active Jun 07 '22 at 01:35

Viewed 24 times

I'm using Postman to query an API for a list of users in a group. The JSON response includes a field called "created_at": "2022-05-16T18:07:09Z".

{
"user": [
    {
        "id": 12345,
        "first_name": "Sample",
        "last_name": "Person",
        "email": "users@emailaddress.com",
        "created_at": "2022-05-16T18:07:09Z",
        "locale": "en"
    }
]
}

I'm trying to have a script first check the users "created_at" date and anyone created over 30 days ago then run the next part of my script which deletes the user from the group.

I'm just having trouble grabbing the created date value so I can check if the user has been in the system for 30 days.

pm.test("Body matches string", function () {
pm.expect(pm.response.text()).to.include("created_at")
});

When I run this test I can find the field in the JSON response.

asked Jun 07 '22 at 01:35

Sean Sugden

Did you mean *can't find*? – Barmar Jun 07 '22 at 01:39
1

You need to parse the JSON, then loop over the array in the `user` property. – Barmar Jun 07 '22 at 01:41
@Barmar, I meant to say that I can at least search the JSON response for the words "created_at", so I know the data is there. – Sean Sugden Jun 07 '22 at 01:41
`pm.response.json().user.map(user => user.created_at)` will return an array of all the `created_at` values. – Barmar Jun 07 '22 at 01:42

Parse JSON response for field values

0 Answers0