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
@lli ,can you take a look at this topic? Thanks!