Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an input json like this
{
"id": "c064e784-5d3b-4d78-9451-eae608ad66a9",
"format": "AVRO",
"EventMessage": {
"EventAttributes": {
"id": "522533ce-fe82-4e73-bfbc-52cacb2c7903",
"msgType": "Raw",
"DataElements": {
"LOB": "F",
"TimeStamp": "2019-10-03T21:12:17.637",
"PayLoad": {
"TrxHdrDisburse": {
"TrxHdrDisburseDisbHdr": {
"DisbHdr": {
"TaxDtl": [{
"TaxDtlData": {
"TaxAllocation": "0",
"DeductionType": "FederalTax",
"TaxDedPct": "0",
"TaxDedAmt": "0",
"TaxDedDefault": "False",
"TaxableGain": "0",
"WithholdAmt": "0",
"TaxableState": "",
"TaxDedYTD": "0",
"Exemptions": "0",
"TimeStamp": "2019-10-08T16:12:30.493"
},
"TaxDtlParty": {
"TaxDtlPartyData": {
"UserID": "D004950",
"TimeStamp": "2019-10-08T16:12:30.493"
},
"Party": {
"PartyData": {
"ID": "260bebec-d70f-4d69-b702-817e12acffbe",
"WithholdingRequiredInd": "False",
"EmailAddress": "",
"PreferredLanguage": "",
"GroupNum": "0",
"Electronic1099": "False",
"Electronic1099Date": "1900-01-01T00:00:00",
"TaxDtlID": "ffffffff-ffff-ffff-ffff-ffffffffffff",
"DoNotCall": "False",
"TimeStamp": "2019-10-03T05:29:16.963"
},
"PartyAddress": {
"PartyAddressData": {
"PartyID": "260bebec-d70f-4d69-b702-817e12acffbe",
"AddressID": "34ae70a7-85e7-4aec-8445-46add144e441",
"StartDate": "2019-10-04T00:00:00",
"EndDate": "2999-12-31T00:00:00",
"UserID": "x224601",
"TimeStamp": "2019-10-04T06:07:37.11"
},
"Address": {
"AddressData": {
"TimeStamp": "2019-10-04T06:07:37.11"
}
}
}
}
}
},
{
"TaxDtlData": {
"TaxAllocation": "0",
"DeductionType": "StateTax",
"TaxDedPct": "0",
"TaxDedAmt": "0",
"TaxDedDefault": "False",
"TaxableGain": "0",
"WithholdAmt": "0",
"TaxableState": "",
"TaxDedYTD": "0",
"Exemptions": "0",
"TimeStamp": "2019-10-08T16:12:30.51"
},
"TaxDtlParty": {
"TaxDtlPartyData": {
"UserID": "D004950",
"TimeStamp": "2019-10-08T16:12:30.51"
},
"Party": {
"PartyData": {
"ID": "260bebec-d70f-4d69-b702-817e12acffde",
"WithholdingRequiredInd": "False",
"EmailAddress": "",
"PreferredLanguage": "",
"GroupNum": "0",
"Electronic1099": "False",
"Electronic1099Date": "1900-01-01T00:00:00",
"TaxDtlID": "ffffffff-ffff-ffff-ffff-ffffffffffff",
"DoNotCall": "False",
"TimeStamp": "2019-10-03T05:29:16.963"
},
"PartyAddress": {
"PartyAddressData": {
"PartyID": "260bebec-d70f-4d69-b702-817e12acffbe",
"AddressID": "34ae70a7-85e7-4aec-8445-46add144e441",
"StartDate": "2019-10-04T00:00:00",
"EndDate": "2999-12-31T00:00:00",
"UserID": "x224601",
"TimeStamp": "2019-10-04T06:07:37.11"
},
"Address": {
"AddressData": {
"TimeStamp": "2019-10-04T06:07:37.11"
}
}
}
}
}
}
],
"TaxForm": [{
"TaxFormData": {
"ID": "53c2d9a8-8c67-4a9c-a8dd-e23ea89afa43",
"TaxFormType": "1099R",
"GrossDistrib": "201322.4",
"TaxableAmt": "0",
"FederalTax": "0",
"EmployeeContrib": "0",
"DistribCode": "4D",
"StateTax": "0",
"DisbHdrID": "f3b1ee06-fe01-470d-ae59-e1372788d11b",
"Status": "PENDING",
"UserID": "WebServices",
"TimeStamp": "2019-10-09T00:17:41.343"
}
},
{
"TaxFormData": {
"ID": "5b523a85-7f55-4552-bd3e-0d8750e51674",
"TaxFormType": "1099INT",
"GrossDistrib": "201322.4",
"TaxableAmt": "0",
"FederalTax": "0",
"EmployeeContrib": "0",
"DistribCode": "4D",
"StateTax": "0",
"DisbHdrID": "f3b1ee06-fe01-470d-ae59-e1372788d11b",
"Status": "PENDING",
"UserID": "WebServices",
"TimeStamp": "2019-10-09T00:17:41.343"
}
}
]
}
}
}
}
}
}
}
}
And I need output like this
[
{
"TaxAllocation": "0",
"DeductionType": "FederalTax",
"TaxDedPct": "0",
"TaxDedAmt": "0",
"TaxDedDefault": "False",
"TaxableGain": "0",
"WithholdAmt": "0",
"TaxableState": "",
"TaxDedYTD": "0",
"Exemptions": "0",
"TimeStamp": "2019-10-08T16:12:30.493"
},
{
"TaxAllocation": "0",
"DeductionType": "StateTax",
"TaxDedPct": "0",
"TaxDedAmt": "0",
"TaxDedDefault": "False",
"TaxableGain": "0",
"WithholdAmt": "0",
"TaxableState": "",
"TaxDedYTD": "0",
"Exemptions": "0",
"TimeStamp": "2019-10-08T16:12:30.51"
}
]
When I use the below JSONPath and test it with http://jsonpath.com/
I get the expected output, but I am not able to define it in a Talend job.
$.EventMessage.EventAttributes.DataElements.PayLoad.TrxHdrDisburse.TrxHdrDisburseDisbHdr.DisbHdr.TaxDtl[*].TaxDtlData
I tried different approaches, but all of them return "TaxDtl" : [ ],
These is my last experiment. How can I define the job stream to get the desired output in Talend?
Thanks
