Need help with defining a job using tJSONDoc to output array

adbdkb — Mon, 16 Dec 2019 03:30:12 GMT

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

Re: Need help with defining a job using tJSONDoc to output array

Anonymous — Thu, 19 Dec 2019 09:04:09 GMT

@lli ,can you take a look at this topic? Thanks!

topic Need help with defining a job using tJSONDoc to output array in Talend Studio

Need help with defining a job using tJSONDoc to output array

Re: Need help with defining a job using tJSONDoc to output array