Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
sbhadra
Contributor II
Contributor II

Parsing JSON data

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

Labels (3)
1 Reply
Anonymous
Not applicable

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

Regards
Shong