Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Planned
Workspace Jedox Platform
Categories Integrator
Created by Guest
Created on Apr 21, 2020

Parent operator in json extract

JSONPath has no parent operator (unlike XML). When getting the following json from a rest webservice:

{

"data": [

{

"id": "xxxxxxxxxx",

"pages": [

{

"id": "yyyyyy",

"questions": [

{

"id": "1234567",

"answers": [

{

"tag_data": [],

"text": "blaaaaaa"

}

],

"id": "9876543",

"answers": [

{

"tag_data": [],

"text": "blablaaaa"

}

]

}

}

}]

}

I would like to iterate over the "text" and get for each row the upper ids, like:

iterate over: $.data.pages.questions.answers

Fields:

text | value

../id | questionid

../../id | pageid

with XPath this would be possible. maybe a solution based on java/tomcat could be found ?

  • Admin
    Stefan Veličković
    Nov 17, 2025

    Hi,

    We are currently developing this feature. It should be available in 26.1 version. Would you be interested in being a beta tester?

  • Guest
    Nov 11, 2025

    Hello, Are there any plans on when to deliver this?