Error while Reading JSON Data using tExtractJsonField

Anonymous — Thu, 19 Dec 2019 12:40:25 GMT

Hi,

I have a requirement to read below JSON message and split all the attributes and store it in a table as columns and 10th attribute "applications", it should store as one single column irrespective of it has n number of array's inside. ( Below example has single array with 2 distinct application id's ).

{
"version": "0.1",
"batchId": "abcdefghijk",
"actionType": "abcdef",
"candidateSystem": "abc",
"dispositionSystem": " AAA",
"messageNumber": 1,
"totalNumberOfMessages": 000,
"createdDateTime": "1990-01-01 00:00:00",
"createdBy": "AAA",
"applications": [{
"applicationId": "000",
"productId": "0000",
"loanPackId": null,
"loanAccountId": "",
"customerId": 000000,
"crn": "000000",
"academicYear": 1800,
"applicationSource": "AAA",
"modeOfStudy" : "",
"awardingBody" : "00000"
},
{
"applicationId": "000","productId": "000000","loanP

To see the whole post, download it here

topic Error while Reading JSON Data using tExtractJsonField in Talend Studio

Error while Reading JSON Data using tExtractJsonField