Parsing JSON data

sbhadra — Sat, 16 Nov 2024 03:21:40 GMT

{
"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.

Re: Parsing JSON data

Anonymous — Wed, 05 Feb 2020 07:07:18 GMT

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

Regards
Shong

topic Parsing JSON data in Talend Studio

Parsing JSON data

Re: Parsing JSON data