how we can write a table mapping rule for this kind of JSON? any suggestion
{
"_id" : ObjectId("6274105feb404050c7300005"),
"ADDITIONALINFO" : {
"PASSPORTISSUEDATE" : "01/04/2018 12:00:00 AM",
"PASSPORTEXPIRYDATE" : "12/18/2024 12:00:00 AM",
"IACOUNTRY" : "puk",
"IACOUNTRYID" : "5"
},
"CDETAILS" : [
{
"CHECKID" : "1",
"CHECKSTATUS" : "WIP",
"REVERIFICATION" : {
"REVERIFICATIONCOUNT" : null,
"OLDCHECKID" : null,
"OLDDFREFNUMBER" : null
},
"CHECKSTATUSID" : "1",
"ISSUINGAUTHORITYCOUNTRY" : "",
"ISSUEDATE" : "02/16/2022 12:00:00 AM"
}
],
"CSTAGE" : {
"STAGEID" : "2",
"STAGE" : "New"
},
"CSTATUS" : {
"STATUSID" : "1",
"STATUS" : "WIP",
}
}