I have been messing around with the JSONPath expressions but have not been able to get it to work.
JSON structure sample:
{
"type": "Actors",
"detail":
},
{
"firstname": "Jason",
"lastname": "Mewes",
"movies":
}
]
}
I want my output to look like:
Actors|Kevin Smith | Clerks | 1994 |8| Silent Bob
Actors|Kevin Smith | Jay and Silent Strike Back |2001 | 7|Silent Bob
Actors|Jason Mewes | Clerks | 1994 |8| Jay
Actors|Jason Mewes | Jay and Silent Strike Back | 2001 |7| Jay
But right now I get an output more like this:
Actors|Kevin Smith | Clerks | 1994 |8| Silent Bob
|| Jay and Silent Strike Back | 2001 |7| Silent Bob
|| Clerks | 1994 |8| Jay
|| Jay and Silent Strike Back | 2001 |7| Jay
Also, even though my JSON is valid per lint, I sometimes get an error message: "The Json resource datas maybe have some problems, please make sure the data structure with the same fields."
Thanks,
Ben
Image attached. I have tried a few different path notations. ex $.detail. vs $..
Output
The Json resource datas maybe have some problems, please make sure the data structure with the same fields.
The Json resource datas maybe have some problems, please make sure the data structure with the same fields.
Actors|Kevin|Smith|Clerks|1994|8|Silent Bob
|Jason|Mewes|Jay and Silent Strike Back|2001|7|Silent Bob
|||Clerks|1994|8|Jay
|||Jay and Silent Strike Back|2001|7|Jay
BTW, I had to fix the moviename field in the JSON file, and I am open to restructuring the JSON if that is required.
Hi Ben
I got the same problem with many examples and confirmed that the component can't cascading the header to next level element if there are many rows.
Can you please report a bug on our bugtracker? Our developer will investigate it further and see if it is possible.
Best regards
Shong
Hello, I have the same problem with this JSON data:
{ "championships":
}, { "name": "Premier League", "teams":
} ] }
I would like to have a result like: Serie A | Milan AC Serie A | Juventus Turin Premier League | Liverpool FC Is there any workaround to resolve it? Many thanks in advance!