how to Parse json file

[Anonymous]

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:

campaign|channel_id|real_end_date|channel_label|real_start_date|label
11|1|null|Display|2019-11-09 21:40:48|00034_Weborama
32|1|null|Display|2020-02-17 21:38:10|10016