tFileInputJSON Path

[Tim_Ouimet]

I have the following JSON data being loaded in - and I'm trying to figure out why I'm getting nulls for the "parent" ID field.

{
"ticket_field": {
"url": "https://thefullurlhere.169074.json",
"id": 360018169074,
"type": "tagger",
"title": "Category",
"created_at": "2019-04-17T19:48:20Z",
"updated_at": "2024-10-10T13:13:22Z",
"removable": true,
"key": null,
"agent_description": null,
"custom_field_options": [
{
"id": 360021686734,
"name": "Zero Service ",
"raw_name": "Zero Service Complaint",
"value": "zero_service_complaint",
"default": false
},{
"id": 360021686735,
"name": "Zero Service",
"raw_name": "Zero Service",
"value": "zero_service",
"default": false
}
]
}
}

My desired output is to have 5 columns.

Parent ID, ID, name, value and default.

I have tried a few iterations of JsonPath 2.x, JsonPath without Loop.

Looping on "$" - with "$.['ticket_field'].id" I only get the value once, and the children in an array.

Without Loop - I only get the parent value once - and then the rows for all the other items as expected.

What would you do here?

[Dave_Simo · Accepted solution]

Hello @Tim_Ouimet 

You need to set the tExtractJSonFields as below

Best Regards

[Tim_Ouimet]

Merci beaucoup!