Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
adbdkb
Creator
Creator
‎2019-12-15 10:30 PM

Need help with defining a job using tJSONDoc to output array

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?

 

 

0683p000009M8M7.png

 

Thanks

 

Labels (2)
Labels
190 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2019-12-19 04:04 AM

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

190 Views
0 Likes