Parsing JSON data

[sbhadra]

{
"ticket": {

"id": 1111,
"external_value": null,
"ticket_data": {
"channel": "Online"

},
"created_at": "2020-01-16",
"updated_at": "2020-01-16"


"ticket_fields": [
{
"id": 12345678,
"value": Hello
},
{
"id": 245789345,
"value": Hi
},
{
"id": 23145678,
"value": Need more info
},

],



This is the json data. I got the resolution to capture the data for id and channel through xpath using textractjsonfields however, I was unable to capture the data for ticket field id and values. I want to capture a specific id like "23145678" whose value is  "Need more info". Please suggest  on the same.

[Anonymous]

Hi
Set the loop Jsonpath query as “/ticket/ticket_fields”, you should be able to extract the expected data.

Regards
Shong