Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Future consideration
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 ?