json data source on ireport designer how to read nested fields

0

i have tried with a simple json and followed a tutorial on how to setup the xml and everything works fine,but i'm stuck into reading this json file

this is a example of my json file

{"_id":{"$oid":"5d62c1e0d809d70e43a8daf4"},"role":"client","status":"active","isPhoneVerified":false,"personalDocuments":[{"$oid":"5d62de7b512cf6107b621766"},{"$oid":"5d62de7b512cf6107b621764"},{"$oid":"5d62de7b512cf6107b621765"},{"$oid":"5d62de8a512cf6107b62176c"},{"$oid":"5d62de8a512cf6107b62176a"},{"$oid":"5d62dea3512cf6107b62176e"},{"$oid":"5d62dea3512cf6107b62176f"},{"$oid":"5d62debd512cf6107b621770"},{"$oid":"5d62debd512cf6107b621772"},{"$oid":"5d6d5771d344983ada16d07b"},{"$oid":"5d948c0abd82e46dd3f0c48b"},{"$oid":"5d948e17bd82e46dd3f0c48c"},{"$oid":"5d948e17bd82e46dd3f0c48d"},{"$oid":"5d948e17bd82e46dd3f0c48e"},{"$oid":"5d9b3cea53bea5732551eac7"},{"$oid":"5dac69171136fb23e2a22a21"},{"$oid":"5dac69171136fb23e2a22a20"}],"kycLevel":[{"$numberInt":"1"},{"$numberInt":"1"},{"$numberInt":"1"},{"$numberInt":"3"}],"email":"email@email.com","firstName":"Demo","lastName":"User","phoneNumber":"+330077524","password":"$0$sCc6rCiSHqFbiuaXErwIUu0DdxwRCgNHn3iG5lzcvT5DItwxwlmau","pushToken":"frCo4A0IeKI:APA91bG0rzFLGj51Z4_cU4u-anaFXRYPDgaihFuEcb2EArQcukZUiAkTlSzSiJlx3L3bo3V6qYBfh-W5JbI_KR7efqBrj-DsJ0KimywwY3Mq43E5q6Jq3K3Ap2GJaXUizN4lNh","created_at":{"$date":{"$numberLong":"1566753248772"}},"updated_at":{"$date":{"$numberLong":"1571908830957"}},"__v":{"$numberInt":"48"},"verifyPhoneCode":"8975","blockingReason":"","reasonForRejection":[[null],["try again"],[""],[""]],"language":"fr"}

mohamedaymen.benmoussa's picture
Joined: Oct 8 2019 - 4:23am
Last seen: 1 year 3 weeks ago

0 Answers:

No answers yet
Feedback
randomness