Json Parse

jayeshmehta1989 — Tue, 16 Jul 2019 10:34:24 GMT

I am doing JSON parse and I suppose to get correctly extracted field.
This below gives me correct illustration number.

| makeresults
 | eval _raw="{\"pdfReports\":[{\"reportType\":\"X002\",\"productCode\":\"SPISWL16\",\"duplication\":\"nonDuplicate\",\"judgmentResult\":\"declaration\",\"receptionManagementNumber\":\"\",\"itemNameList\":[]}],\"fieldsMap\":{\"documents\":[{\"documentId\":\"\",\"policyNumber\":\"noNumber\",\"fileType\":\"pdf\",\"reportId\":\"X001\",\"printMode\":\"nonDuplicate\",\"sortOrder\":1},{\"documentId\":\"\",\"policyNumber\":\"noNumber\",\"fileType\":\"pdf\",\"reportId\":\"X002\",\"printMode\":\"nonDuplicate\",\"sortOrder\":2}],\"beneficiaries\":[],\"coverages\":[{\"productCode\":\"SPISWL16\",\"riderName\":\"NA\",\"baseCurrencyCode\":\"USD\",\"insuredTerm\":99.0,\"paymentTerm\":0.0,\"reserveInterestRate\":3.93,\"reserveInterestRateGuaranteedPeriod\":0,\"yenPaymentExchangeRate\":123.59,\"numberOfDeathBeneficiaries\":0,\"periodicPaymentRate\":0.0,\"insurance\":{\"amount\":{\"amount\":196778.44,\"currencyCode\":\"USD\"}},\"premium\":{\"amount\":{\"amount\":50000.0,\"currencyCode\":\"USD\"}},\"totalSinglePremium\":{\"amount\":{\"amount\":50000.0,\"currencyCode\":\"USD\"}},\"totalSinglePremiumForeign\":{\"amount\":{\"amount\":0.0,\"currencyCode\":\"AUD\"}},\"totalSinglePremiumYen\":{\"amount\":{\"amount\":6179500.0,\"currencyCode\":\"JPY\"}},\"commissionFirstYear\":{\"amount\":{\"amount\":237500.0,\"currencyCode\":\"USD\"}},\"commissionNextYear\":{\"amount\":{\"amount\":18500.0,\"currencyCode\":\"USD\"},\"paymentPeriod\":0},\"specialConditionPremium\":{\"amount\":{\"amount\":0.0,\"currencyCode\":\"USD\"}},\"FXRateAcquisitionDate\":\"2019-07-16T00:00:00+09:00\"},{\"productCode\":\"SPISWL16\",\"riderName\":\"SPISWL16_LivingNeedsRider\",\"insuredTerm\":0.0,\"paymentTerm\":0.0,\"reserveInterestRate\":0.0,\"reserveInterestRateGuaranteedPeriod\":0,\"yenPaymentExchangeRate\":0.0,\"numberOfDeathBeneficiaries\":0,\"periodicPaymentRate\":0.0}],\"dataTransferDatas\":[],\"accounts\":[],\"medicalExamTypes\":[{\"type\":\"健康診断書扱\"},{\"type\":\"健康診断書扱（面接士併用型）\"},{\"type\":\"面接士扱\"},{\"type\":\"人間ドック扱（12ヵ月）\"},{\"type\":\"人間ドック扱（6ヵ月）\"},{\"type\":\"診査医扱\"}],\"policyholder\":{\"giftFunds\":0,\"age\":27,\"birthDate\":\"******\",\"jobDescription\":\"******\",\"jobDescriptionDetail\":\"******\",\"businessDescription\":\"******\",\"businessDescriptionDetail\":\"******\",\"gender\":\"F\",\"relationshipToInsuredParty\":\"01\",\"workplaceLocal\":\"******\",\"personName\":{\"firstNameLocal\":\"******\",\"lastNameLocal\":\"******\",\"firstNamePhonetic\":\"******\",\"lastNamePhonetic\":\"******\",\"fullNameLocal\":\"******\",\"fullNamePhonetic\":\"******\"},\"address\":{\"addressLine1\":\"******\",\"addressLine1Local\":\"******\",\"addressLine1Phonetic\":\"******\",\"addressLine2\":\"******\",\"addressLine2Local\":\"******\",\"addressLine2Phonetic\":\"******\",\"addressLine3\":\"******\",\"addressLine3Local\":\"******\",\"addressLine3Phonetic\":\"******\",\"postalCode\":\"******\",\"addressLineFullLocal\":\"******\",\"addressLineFullPhonetic\":\"******\"},\"phoneNumber\":{\"number\":\"******\"},\"parentalAuthority\":{\"address\":{\"addressLine1\":\"******\",\"addressLine1Local\":\"******\",\"addressLine1Phonetic\":\"******\",\"addressLine2\":\"******\",\"addressLine2Local\":\"******\",\"addressLine2Phonetic\":\"******\",\"addressLine3\":\"******\",\"addressLine3Local\":\"******\",\"addressLine3Phonetic\":\"******\",\"postalCode\":\"******\",\"addressLineFullLocal\":\"******\",\"addressLineFullPhonetic\":\"******\"}}},\"insuredParty\":{\"age\":27,\"birthDate\":\"******\",\"gender\":\"F\",\"breadwinnerDeathBenefit\":0.0,\"hasOtherInsurerContracts\":false,\"hasOccupation\":true,\"occupationCode\":\"2\",\"policyholderRelationship\":\"201\",\"deathBenefit\":0.0,\"accidentDeathBenefit\":0.0,\"jobDescription\":\"******\",\"jobDescriptionDetail\":\"******\",\"workplaceLocal\":\"******\",\"businessDetail\":\"\",\"personName\":{\"firstNameLocal\":\"******\",\"lastNameLocal\":\"******\",\"firstNamePhonetic\":\"******\",\"lastNamePhonetic\":\"******\",\"fullNameLocal\":\"******\",\"fullNamePhonetic\":\"******\"},\"address\":{\"addressLine1\":\"******\",\"addressLine1Local\":\"******\",\"addressLine1Phonetic\":\"******\",\"addressLine2\":\"******\",\"addressLine2Local\":\"******\",\"addressLine2Phonetic\":\"******\",\"addressLine3\":\"******\",\"addressLine3Local\":\"******\",\"addressLine3Phonetic\":\"******\",\"postalCode\":\"******\",\"addressLineFullLocal\":\"******\",\"addressLineFullPhonetic\":\"******\"},\"phoneNumber\":{\"number\":\"******\"},\"parentalAuthority\":{\"address\":{\"addressLine1\":\"******\",\"addressLine1Local\":\"******\",\"addressLine1Phonetic\":\"******\",\"addressLine2\":\"******\",\"addressLine2Local\":\"******\",\"addressLine2Phonetic\":\"******\",\"addressLine3\":\"******\",\"addressLine3Local\":\"******\",\"addressLine3Phonetic\":\"******\",\"postalCode\":\"******\",\"addressLineFullLocal\":\"******\",\"addressLineFullPhonetic\":\"******\"}},\"breadwinner\":false,\"isBreadwinner\":false},\"application\":{\"allowedInstallmentsTurns\":0.0,\"isPolicyholderAndInsuredPartySame\":true,\"isBeneficiaryDocumentSubmitted\":false},\"illustration\":{\"courseCode\":\"31\",\"baseRate\":3.93,\"baseRateSettingDate\":\"2019-07-16\",\"crossRate\":0.0,\"reducedBenefitPeriod\":0,\"illustrationNumber\":\"R19071600071\",\"healthClass\":\"\",\"inAdvancePaymentTurns\":0.0,\"minGuaranteedBaseRate\":2.0,\"referenceAmountExchangeRate\":0.0,\"reportOutputDate\":\"2019-07-16T17:55:37+09:00\",\"policyBoundDate\":\"2019-07-16\",\"examClassification\":\"\",\"inspectionContents\":\"\",\"selectableExamClassifications\":[\"健康診断書扱\",\"健康診断書扱（面接士併用型）\",\"面接士扱\",\"人間ドック扱（12ヵ月）\",\"人間ドック扱（6ヵ月）\",\"診査医扱\"],\"selectableInspectionContents\":[\"一般検診が必要\"],\"hasHearingDisorder\":false,\"hasVisualDisorder\":false,\"selectablePaymentRider\":0,\"X001HasOptionReport\":false,\"X001HasRiderWaiverDisplayExpansion\":true,\"X001NoOfYearsSinceFullyPaid1\":0,\"X001NoOfYearsSinceFullyPaid2\":0,\"X001NoOfYearsSinceFullyPaid3\":0},\"disclosure\":{\"auraXMLData\":\"\",\"height\":0.0,\"weight\":0.0,\"hasSmokedInLastYear\":false},\"report\":{\"purposeOfInsurance\":\"\",\"hasOtherInsurance\":false,\"hasOtherJobs\":false,\"X015SuccessionCountermeasureFunds\":0.0},\"invoice\":{\"paymentRouteCode\":\"\",\"frequencyCode\":\"OneTime\"},\"agent\":{\"agentBankName\":\"******\",\"branchName\":\"******\",\"branchCode\":\"0145\",\"institutionCode\":\"0133\",\"institutionNameLocal\":\"******\",\"clerkCode\":\"12345678901\",\"representativeCode\":\"7113301\",\"representativeNameLocal\":\"******\",\"jointAgentPercentage\":0.0,\"address\":{\"addressLine1\":\"******\",\"addressLine1Local\":\"******\",\"addressLine1Phonetic\":\"******\",\"addressLine2\":\"******\",\"addressLine2Local\":\"******\",\"addressLine2Phonetic\":\"******\",\"addressLine3\":\"******\",\"addressLine3Local\":\"******\",\"addressLine3Phonetic\":\"******\",\"postalCode\":\"******\",\"addressLineFullLocal\":\"******\",\"addressLineFullPhonetic\":\"******\"},\"phoneNumber\":{\"number\":\"******\"}},\"product\":{\"petName\":\"ビー ウィズ ユー プラス\",\"officialProductName\":\"******\"},\"interview\":{\"policyholderInterviewDate\":\"\"},\"institution\":{\"offersPremiumRiderDisplayExpansion\":false,\"offersYenPaymentRider\":true,\"offersForeignCurrencyPaymentRider\":true,\"offersVariableWholeLifeRider\":true},\"intentLetter\":{\"specialConditions1\":\"\",\"X013ConfirmationDate\":\"\",\"SpecialConditions1\":\"\"},\"agentHistory\":{\"declarationAgent\":{\"representativeCode\":\"\",\"jointAgentPercentage\":0.0},\"insuredSignatureAgent\":{\"representativeCode\":\"\",\"jointAgentPercentage\":0.0},\"intentionAgent\":{\"representativeCode\":\"\",\"jointAgentPercentage\":0.0},\"policyholderSignatureAgent\":{\"representativeCode\":\"\",\"jointAgentPercentage\":0.0}}}}"  
 | spath input=_raw|table _raw, fieldsMap.illustration.illustrationNumber

But below one does not extract properly. Will someone help me.

| makeresults
 | eval _raw="{\"pdfReports\":[{\"reportType\":\"X002\",\"productCode\":\"SPISWL16\",\"duplication\":\"nonDuplicate\",\"judgmentResult\":\"declaration\",\"receptionManagementNumber\":\"\",\"itemNameList\":[]}],\"fieldsMap\":{\"documents\":[{\"documentId\":\"\",\"policyNumber\":\"noNumber\",\"fileType\":\"pdf\",\"reportId\":\"X001\",\"printMode\":\"nonDuplicate\",\"sortOrder\":1},{\"documentId\":\"\",\"policyNumber\":\"noNumber\",\"fileType\":\"pdf\",\"reportId\":\"X002\",\"printMode\":\"nonDuplicate\",\"sortOrder\":2}],\"beneficiaries\":[],\"coverages\":[{\"productCode\":\"SPISWL16\",\"riderName\":\"NA\",\"baseCurrencyCode\":\"USD\",\"insuredTerm\":99.0,\"paymentTerm\":0.0,\"reserveInterestRate\":3.93,\"reserveInterestRateGuaranteedPeriod\":0,\"yenPaymentExchangeRate\":110.11,\"numberOfDeathBeneficiaries\":0,\"periodicPaymentRate\":0.0,\"insurance\":{\"amount\":{\"amount\":130656.77,\"currencyCode\":\"USD\"}},\"premium\":{\"amount\":{\"amount\":30000.0,\"currencyCode\":\"USD\"}},\"totalSinglePremium\":{\"amount\":{\"amount\":30000.0,\"currencyCode\":\"USD\"}},\"totalSinglePremiumForeign\":{\"amount\":{\"amount\":0.0,\"currencyCode\":\"AUD\"}},\"totalSinglePremiumYen\":{\"amount\":{\"amount\":3303300.0,\"currencyCode\":\"JPY\"}},\"commissionFirstYear\":{\"amount\":{\"amount\":237500.0,\"currencyCode\":\"USD\"}},\"commissionNextYear\":{\"amount\":{\"amount\":18500.0,\"currencyCode\":\"USD\"},\"paymentPeriod\":0},\"specialConditionPremium\":{\"amount\":{\"amount\":0.0,\"currencyCode\":\"USD\"}},\"FXRateAcquisitionDate\":\"2019-07-16T00:00:00+09:00\"},{\"productCode\":\"SPISWL16\",\"riderName\":\"SPISWL16_YenPremiumPaymentRider\",\"insuredTerm\":0.0,\"paymentTerm\":0.0,\"reserveInterestRate\":0.0,\"reserveInterestRateGuaranteedPeriod\":0,\"yenPaymentExchangeRate\":0.0,\"numberOfDeathBeneficiaries\":0,\"yenPremiumPaymentClassification\":\"0\",\"periodicPaymentRate\":0.0},{\"productCode\":\"SPISWL16\",\"riderName\":\"SPISWL16_LivingNeedsRider\",\"insuredTerm\":0.0,\"paymentTerm\":0.0,\"reserveInterestRate\":0.0,\"reserveInterestRateGuaranteedPeriod\":0,\"yenPaymentExchangeRate\":0.0,\"numberOfDeathBeneficiaries\":0,\"periodicPaymentRate\":0.0}],\"dataTransferDatas\":[],\"accounts\":[],\"medicalExamTypes\":[{\"type\":\"健康診断書扱\"},{\"type\":\"健康診断書扱（面接士併用型）\"},{\"type\":\"面接士扱\"},{\"type\":\"人間ドック扱（12ヵ月）\"},{\"type\":\"人間ドック扱（6ヵ月）\"},{\"type\":\"診査医扱\"}],\"policyholder\":{\"giftFunds\":0,\"age\":20,\"birthDate\":\"******\",\"jobDescription\":\"******\",\"jobDescriptionDetail\":\"******\",\"businessDescription\":\"******\",\"businessDescriptionDetail\":\"******\",\"gender\":\"M\",\"relationshipToInsuredParty\":\"06\",\"workplaceLocal\":\"******\",\"personName\":{\"firstNameLocal\":\"******\",\"lastNameLocal\":\"******\",\"firstNamePhonetic\":\"******\",\"lastNamePhonetic\":\"******\",\"fullNameLocal\":\"******\",\"fullNamePhonetic\":\"******\"},\"address\":{\"addressLine1\":\"******\",\"addressLine1Local\":\"******\",\"addressLine1Phonetic\":\"******\",\"addressLine2\":\"******\",\"addressLine2Local\":\"******\",\"addressLine2Phonetic\":\"******\",\"addressLine3\":\"******\",\"addressLine3Local\":\"******\",\"addressLine3Phonetic\":\"******\",\"postalCode\":\"******\",\"addressLineFullLocal\":\"******\",\"addressLineFullPhonetic\":\"******\"},\"phoneNumber\":{\"number\":\"******\"},\"parentalAuthority\":{\"address\":{\"addressLine1\":\"******\",\"addressLine1Local\":\"******\",\"addressLine1Phonetic\":\"******\",\"addressLine2\":\"******\",\"addressLine2Local\":\"******\",\"addressLine2Phonetic\":\"******\",\"addressLine3\":\"******\",\"addressLine3Local\":\"******\",\"addressLine3Phonetic\":\"******\",\"postalCode\":\"******\",\"addressLineFullLocal\":\"******\",\"addressLineFullPhonetic\":\"******\"}}},\"insuredParty\":{\"age\":20,\"birthDate\":\"******\",\"gender\":\"F\",\"breadwinnerDeathBenefit\":0.0,\"hasOtherInsurerContracts\":false,\"hasOccupation\":true,\"occupationCode\":\"4\",\"policyholderRelationship\":\"205\",\"deathBenefit\":0.0,\"accidentDeathBenefit\":0.0,\"jobDescription\":\"******\",\"jobDescriptionDetail\":\"******\",\"workplaceLocal\":\"******\",\"businessDetail\":\"\",\"personName\":{\"firstNameLocal\":\"******\",\"lastNameLocal\":\"******\",\"firstNamePhonetic\":\"******\",\"lastNamePhonetic\":\"******\",\"fullNameLocal\":\"******\",\"fullNamePhonetic\":\"******\"},\"address\":{\"addressLine1\":\"******\",\"addressLine1Local\":\"******\",\"addressLine1Phonetic\":\"******\",\"addressLine2\":\"******\",\"addressLine2Local\":\"******\",\"addressLine2Phonetic\":\"******\",\"addressLine3\":\"******\",\"addressLine3Local\":\"******\",\"addressLine3Phonetic\":\"******\",\"postalCode\":\"******\",\"addressLineFullLocal\":\"******\",\"addressLineFullPhonetic\":\"******\"},\"phoneNumber\":{\"number\":\"******\"},\"parentalAuthority\":{\"address\":{\"addressLine1\":\"******\",\"addressLine1Local\":\"******\",\"addressLine1Phonetic\":\"******\",\"addressLine2\":\"******\",\"addressLine2Local\":\"******\",\"addressLine2Phonetic\":\"******\",\"addressLine3\":\"******\",\"addressLine3Local\":\"******\",\"addressLine3Phonetic\":\"******\",\"postalCode\":\"******\",\"addressLineFullLocal\":\"******\",\"addressLineFullPhonetic\":\"******\"}},\"breadwinner\":false,\"isBreadwinner\":false},\"application\":{\"allowedInstallmentsTurns\":0.0,\"isPolicyholderAndInsuredPartySame\":false,\"isBeneficiaryDocumentSubmitted\":false},\"illustration\":{\"courseCode\":\"31\",\"baseRate\":3.93,\"baseRateSettingDate\":\"2019-07-16\",\"crossRate\":0.0,\"reducedBenefitPeriod\":0,\"illustrationNumber\":\"R19071600400\",\"healthClass\":\"\",\"inAdvancePaymentTurns\":0.0,\"minGuaranteedBaseRate\":2.0,\"referenceAmountExchangeRate\":0.0,\"reportOutputDate\":\"2019-07-16T17:40:46+09:00\",\"policyBoundDate\":\"2019-07-16\",\"examClassification\":\"\",\"inspectionContents\":\"\",\"selectableExamClassifications\":[\"健康診断書扱\",\"健康診断書扱（面接士併用型）\",\"面接士扱\",\"人間ドック扱（12ヵ月）\",\"人間ドック扱（6ヵ月）\",\"診査医扱\"],\"selectableInspectionContents\":[\"一般検診が必要\"],\"hasHearingDisorder\":false,\"hasVisualDisorder\":false,\"selectablePaymentRider\":0,\"X001HasOptionReport\":false,\"X001HasRiderWaiverDisplayExpansion\":true,\"X001NoOfYearsSinceFullyPaid1\":0,\"X001NoOfYearsSinceFullyPaid2\":0,\"X001NoOfYearsSinceFullyPaid3\":0},\"disclosure\":{\"auraXMLData\":\"\",\"height\":0.0,\"weight\":0.0,\"hasSmokedInLastYear\":false},\"report\":{\"purposeOfInsurance\":\"\",\"hasOtherInsurance\":false,\"hasOtherJobs\":false,\"X015SuccessionCountermeasureFunds\":0.0},\"invoice\":{\"paymentRouteCode\":\"\",\"frequencyCode\":\"OneTime\"},\"agent\":{\"agentBankName\":\"******\",\"branchName\":\"******\",\"branchCode\":\"0005\",\"institutionCode\":\"0161\",\"institutionNameLocal\":\"******\",\"clerkCode\":\"123456789\",\"representativeCode\":\"8977464\",\"representativeNameLocal\":\"******\",\"jointAgentPercentage\":0.0,\"address\":{\"addressLine1\":\"******\",\"addressLine1Local\":\"******\",\"addressLine1Phonetic\":\"******\",\"addressLine2\":\"******\",\"addressLine2Local\":\"******\",\"addressLine2Phonetic\":\"******\",\"addressLine3\":\"******\",\"addressLine3Local\":\"******\",\"addressLine3Phonetic\":\"******\",\"postalCode\":\"******\",\"addressLineFullLocal\":\"******\",\"addressLineFullPhonetic\":\"******\"},\"phoneNumber\":{\"number\":\"******\"}},\"product\":{\"petName\":\"ビー ウィズ ユー プラス\",\"officialProductName\":\"******\"},\"interview\":{\"policyholderInterviewDate\":\"\"},\"institution\":{\"offersPremiumRiderDisplayExpansion\":false,\"offersYenPaymentRider\":true,\"offersForeignCurrencyPaymentRider\":true,\"offersVariableWholeLifeRider\":true},\"intentLetter\":{\"specialConditions1\":\"\",\"X013ConfirmationDate\":\"\",\"SpecialConditions1\":\"\"},\"agentHistory\":{\"declarationAgent\":{\"representativeCode\":\"\",\"jointAgentPercentage\":0.0},\"insuredSignatureAgent\":{\"representativeCode\":\"\",\"jointAgentPercentage\":0.0},\"intentionAgent\":{\"representativeCode\":\"\",\"jointAgentPercentage\":0.0},\"policyholderSignatureAgent\":{\"representativeCode\":\"\",\"jointAgentPercentage\":0.0}}}}"  
 | spath input=_raw|table _raw, fieldsMap.illustration.illustrationNumber

topic Json Parse in Getting Data In

Json Parse