Extract data from json response in jmeter

[nehabansal14]

I have this json response: { "total":1, "page":1, "records":23, "rows": [ { "id":409587, "from_status":"[Default Status]", "to_status":"New", "transition_name":"", "assign_id":"7", "exclude_groups_value":"" }, { "id":409582, "from_status":"Approved", "to_status":"Done", "transition_name":"", "assign_id":"7", "exclude_groups_value":"" }, { "id":409583, "from_status":"Approved", "to_status":"In Process", "transition_name":"", "assign_id":"7", "exclude_groups_value":"" }, { "id":409584, "from_status":"Closed", "to_status":"Done", "transition_name":"", "assign_id":"7", "exclude_groups_value":"" }, { "id":409585, "from_status":"Closed", "to_status":"Rejected", "transition_name":"", "assign_id":"7", "exclude_groups_value":"" }, { "id":409586, "from_status":"Closed", "to_status":"Reopen", "transition_name":"", "assign_id":"7", "exclude_groups_value":"" }, { "id":409588, "from_status":"Deferred", "to_status":"Rejected", "transition_name":"", "assign_id":"7", "exclude_groups_value":"" }, { "id":409589, "from_status":"Deferred", "to_status":"Reopen", "transition_name":"", "assign_id":"7", "exclude_groups_value":"" }, { "id":409590, "from_status":"Done", "to_status":"Closed", "transition_name":"", "assign_id":"7", "exclude_groups_value":"" }, { "id":409591, "from_status":"Done", "to_status":"Rejected", "transition_name":"", "assign_id":"7", "exclude_groups_value":"" }, { "id":409592, "from_status":"Done", "to_status":"Reopen", "transition_name":"", "assign_id":"7", "exclude_groups_value":"" }, { "id":409593, "from_status":"In Process", "to_status":"Done", "transition_name":"", "assign_id":"7", "exclude_groups_value":"" }, { "id":409594, "from_status":"In Process", "to_status":"Wait for Review", "transition_name":"", "assign_id":"7", "exclude_groups_value":"" }, { "id":409595, "from_status":"New", "to_status":"Approved", "transition_name":"", "assign_id":"7", "exclude_groups_value":"" }, { "id":409596, "from_status":"New", "to_status":"Deferred", "transition_name":"", "assign_id":"7", "exclude_groups_value":"" }, { "id":409597, "from_status":"New", "to_status":"Done", "transition_name":"", "assign_id":"7", "exclude_groups_value":"" }, { "id":409598, "from_status":"New", "to_status":"In Process", "transition_name":"", "assign_id":"7", "exclude_groups_value":"" }, { "id":409599, "from_status":"New", "to_status":"Rejected", "transition_name":"", "assign_id":"7", "exclude_groups_value":"" }, { "id":409600, "from_status":"Rejected", "to_status":"Reopen", "transition_name":"", "assign_id":"7", "exclude_groups_value":"" }, { "id":409601, "from_status":"Reopen", "to_status":"Done", "transition_name":"", "assign_id":"7", "exclude_groups_value":"" }, { "id":409602, "from_status":"Reopen", "to_status":"In Process", "transition_name":"", "assign_id":"7", "exclude_groups_value":"" }, { "id":409603, "from_status":"Wait for Review", "to_status":"Approved", "transition_name":"", "assign_id":"7", "exclude_groups_value":"" }, { "id":409604, "from_status":"Wait for Review", "to_status":"Reopen", "transition_name":"", "assign_id":"7", "exclude_groups_value":"" } ] }

and i Want to extract id where from_status=new and to_status=in process. I have tried this $..[?(@.from_status == 'New')] its giving me: CreatorData_1={id=409595, from_status=New, to_status=Approved, transition_name=, assign_id=7, exclude_groups_value=} CreatorData_2={id=409596, from_status=New, to_status=Deferred, transition_name=, assign_id=7, exclude_groups_value=} CreatorData_3={id=409597, from_status=New, to_status=Done, transition_name=, assign_id=7, exclude_groups_value=} CreatorData_4={id=409598, from_status=New, to_status=In Process, transition_name=, assign_id=7, exclude_groups_value=} CreatorData_5={id=409599, from_status=New, to_status=Rejected, transition_name=, assign_id=7, exclude_groups_value=} these values.

now i need to extract id where to status is in process.

I have used this http://screencast.com/t/hk0Zzj0fHLQ used regular expression and select jmeter variable.

now its taking value but its a dynamic json and it can change anytime. for now CreatorData_4 having my value but in future may be it will not display. then for this what shall i do?

[harikiranvankayala]

Try regular expression as below to fetch "In Process" {id=(.+?), from_status=New, to_status=In Process}