Need to Extract all data based on condition in jmeter

Question

I got below json as response from HttpRequest of jmeter.

[
    {
        "state": {
            "data": {
                "linearId": {
                    "externalId": null,
                    "id": "1234"
                },
                "Contract": {
                    "Status": {
                        "displayName": "Accepted"
                    },
                    "contractType": "life"
                }
            }
        }
    },
    {
        "state": {
            "data": {
                "linearId": {
                    "externalId": null,
                    "id": "4567"
                },
                "Contract": {
                    "Status": {
                        "displayName": "Rejected"
                    },
                    "contractType": "life"
                }
            }
        }
    },
    {
        "state": {
            "data": {
                "linearId": {
                    "externalId": null,
                    "id": "7890"
                },
                "Contract": {
                    "Status": {
                        "displayName": "Accepted"
                    },
                    "contractType": "life"
                }
            }
        }
    }
]

I need to get all the id's as array where displayName is Accepted which needs to be passed to next threadGroup

I have tried some jsonpath expression. But, Couldn't figure out the expression.

How do I get this?

Thanks in advance.

Answer 1

I believe the following JsonPath query will do the trick for you:

$..state.data[?(@.Contract.Status.displayName == 'Accepted')].linearId.id

Demo:

More information:

• JsonPath Filter Operators
• JMeter's JSON Path Extractor Plugin - Advanced Usage Scenarios