Why doesn't Talend allow for JSONpath recursive descent?

mattg1221 — Mon, 13 Oct 2025 17:20:15 GMT

Talend Studio Latest Version

jars used (as seen in Modules view) - json-path:2.9.0

take a json as such:

{

"person": {"name": "bob", "id" : "100101"},

"relationList": [

{

"person":

{

"name":"Steve",

"id":"100102"

"relationList": [

{"person": {"name":"mary","id":"100104"}},

{"parentId" : "100103"}

"parentId": "100101"

{

"person":

{

"name":"Sam",

"Id":"100105"

"parentId":"100101"

}

]

}
where a person json object may have a parentId and/or relationList[] object at the same level accompanying it.

To get all parentIds in the order that they show up in a depth first manner, the query is simply "$..parentId" where '..' is the recursive descent operator.

In a TfileInputJson component, if $ is the loop query and ..parentId is the query for parentId column, it throws and error. If '$..' is the loop query and 'parentId' is the parentId column query, it also throws an error.

What gives????

@LUITS

Re: Why doesn't Talend allow for JSONpath recursive descent?

Xiaodi_Shi — Tue, 14 Oct 2025 01:11:51 GMT

Hello,

It looks like a bug on JSON parsing logic.

Could you please try to use tExtractJSONFields component to parse the data to fields, in one of the "JSON query" lines? where '..' is recursive descent or does .*. work for you?

Best regards

Sabrina

topic Re: Why doesn't Talend allow for JSONpath recursive descent? in Talend Studio

Why doesn't Talend allow for JSONpath recursive descent?

Re: Why doesn't Talend allow for JSONpath recursive descent?