how to Parse json file

Anonymous — Sun, 08 Mar 2020 11:06:39 GMT

Hi,

Any one can help me how to parse below json file in Talend? I have tried using textractjsonfile component but it is not giving me exact output because json file is different.

Input file:

"metadata": {
"project": {
"4": {
"label": "LYFT"
},
"3": {
"label": "Mediaplus"
},
"2": {
"label": "Glo"
}
},
"campaign": {
"11": {
"channel_id": "1",
"real_end_date": null,
"channel_label": "Display",
"real_start_date": "2019-11-09 21:40:48",
"label": "00034_Weborama"
},
"32": {
"channel_id": "1",
"real_end_date": null,
"channel_label": "Display",
"real_start_date": "2020-02-17 21:38:10",
"label": "10016"
}
}
}

expected output:

Project file output:

project|label
4|LYFT
3|Mediaplus
2|Glo

campaign file output:

topic how to Parse json file in Talend Studio

how to Parse json file