 |
Subscribe
to this
site |
|
MapRecord Cleaning
Published 4 months ago
by
Nakul
def contentJson = """
{
"PlanID" : "9734955",
"MemberType" : "D",
"RelationshipCode" : "S",
"MemberID" : "420A6958701",
"sbscrbrId" : "0002H33ZN",
"firstNm" : "HWX4O",
"middleNm" : "V",
"lastNm" : "N0A3Q5 8GH",
"Gender" : "M",
"SocialSecurityNumber" : "193945649",
"BenefitOption" : "0104",
"EnrollDate" : {
"date" : ""
},
"dob" : "1990-09-04",
"EffectiveDate" : {
"date" : 1012017
},
"TerminationDate" : {
"date" : 6302022
},
"Tier" : "04",
"NumberofDependents" : "",
"UpdateAction" : "",
"AddressLine1" : "PO BOX 50282",
"AddressLine2" : "",
"City" : "CLAYTON",
"State" : "MO",
"Zip" : "63105",
"Filler1" : "",
"Filler2" : "",
"Filler3" : "Y",
"TelephoneNumber" : "",
"DivisionCode" : "002178020000",
"LocationCode" : "ESFM0360",
"CompanyCode" : "CNR",
"ClientGroupNumber" : "",
"ReportingField1" : "Plan 71",
"ReportingField2" : "489881803",
"ReportingField3" : "1 ",
"srcSysId" : "FCTS",
"Lookuprecord" : "MapRecord[Document{{_id=0002H33ZN1100249076FCTS, grpId=[00249076], lastMdfdDt=Thu Aug 18 08:59:17 UTC 2022, docCreatdDt=Thu Aug 18 08:59:17 UTC 2022, docUpdatdDt=Thu Aug 18 08:59:17 UTC 2022, hcId=[0002H33ZN], mbrUid=0002H33ZN1100249076FCTS, rltnshpCd=1, ssn=o6AudGgub, mbrCd=40, docUpdatdUsrId=NIFI_ADMIN, middleNm=V, mbrLkupId=0002H33ZN1100249076FCTS, mbrSqncNbr=1, docCreatdUsrId=NIFI_ADMIN, mcId=321606354, srcSysId=FCTS, firstNm=HWX4O, srcMdfdDt=Mon May 06 05:05:22 UTC 2019, lastNm=N0A3Q5 8GH, mbrUniqId=D77E9D575A55A1F01198092A41A2D879, delInd=N, dob=1990-09-04, gndrCd=F, subMbrUid=0002H33ZN01900249076FCTS, ethnctyCd=888889, sbscrbrId=0002H33ZN}}]"
}"""
def slurper = new groovy.json.JsonSlurper();
def slurpedJson = slurper.parseText(contentJson) as Map
def lookuprecord = slurpedJson.Lookuprecord
def lookupRecordString = lookuprecord.substring(20)
lookupRecordString = lookupRecordString.replaceAll("}}]","")
def lookupRecordMap = [:]
lookupRecordString.split(",").each {param ->
def nameAndValue = param.split("=")
lookupRecordMap[nameAndValue[0]] = nameAndValue[1]
}
//println lookupRecordMap
def json = new groovy.json.JsonBuilder()
json Lookuprecord: lookupRecordMap
println json.toString()