Groovy web console

subscribe to the feed Subscribe
to this
site

ABC

Published 4 months ago by Nakul
Actions Execute script  ▶ Edit in console Back to console Show/hide line numbers View recent scripts
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)
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()