Read JSON file

[saranoofa2]

Hello,

My JSON file as below

[{
  "_id": {
    "$oid": "69bbf760482a1b6d87e43df3"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-02-11T10:55:00.000Z"
  },
  "calorie": 2898,
  "weight": 93.1,
  "etc": 12.5
},
{
  "_id": {
    "$oid": "69bbf80bb2e94ea5ed35433b"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-02-12T06:04:00.000Z"
  },
  "calorie": 2919,
  "weight": 94.1,
  "etc": 12.4
},
{
  "_id": {
    "$oid": "69bbf88af38deca207fc8714" 
.....
.....

I tried to using tFileInputJSON to reading the value. Unfortunately, the JSON structure from MongoDB I never face before 

Below is the full JSON

[{
  "_id": {
    "$oid": "69bbf760482a1b6d87e43df3"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-02-11T10:55:00.000Z"
  },
  "calorie": 2898,
  "weight": 93.1,
  "etc": 12.5
},
{
  "_id": {
    "$oid": "69bbf80bb2e94ea5ed35433b"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-02-12T06:04:00.000Z"
  },
  "calorie": 2919,
  "weight": 94.1,
  "etc": 12.4
},
{
  "_id": {
    "$oid": "69bbf88af38deca207fc8714"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-02-12T11:02:00.000Z"
  },
  "calorie": 2913,
  "weight": 93.8,
  "etc": 12.5
}, ................................

How my tLogRow can display as below. I need some guide

id                                                      | name                          | crtdate                                      | calorie        | ...... 

69bbf760482a1b6d87e43df3             franky                           11-02-2026                                 2898

....

Or I need to read this JSON and modify the JSON to simple and readable format ?

Please help

[marksouzacosta]

Hi @saranoofa2 ,

Are you saying that the "dots" are inside the JSON file?

................................

Regards,

Mark Costa

[saranoofa2]

Hi Mark,

Yes. This is the full file ,

[{
  "_id": {
    "$oid": "69bbf760482a1b6d87e43df3"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-02-11T10:55:00.000Z"
  },
  "calorie": 2898,
  "weight": 93.1,
  "etc": 12.5
},
{
  "_id": {
    "$oid": "69bbf80bb2e94ea5ed35433b"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-02-12T06:04:00.000Z"
  },
  "calorie": 2919,
  "weight": 94.1,
  "etc": 12.4
},
{
  "_id": {
    "$oid": "69bbf88af38deca207fc8714"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-02-12T11:02:00.000Z"
  },
  "calorie": 2913,
  "weight": 93.8,
  "etc": 12.5
},
{
  "_id": {
    "$oid": "69bbf8cec1b7606627cdf7c3"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-02-13T08:44:00.000Z"
  },
  "calorie": 2910,
  "weight": 93.6,
  "etc": 12.5
},
{
  "_id": {
    "$oid": "69bc034203957addf3492f55"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-02-14T05:48:00.000Z"
  },
  "calorie": 2905,
  "weight": 93.4,
  "etc": 12.5
},
{
  "_id": {
    "$oid": "69bc03d903957addf3492f56"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-02-14T08:25:00.000Z"
  },
  "calorie": 2901,
  "weight": 93.2,
  "etc": 12.5
},
{
  "_id": {
    "$oid": "69bc05a903957addf3492f57"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-02-17T02:40:00.000Z"
  },
  "calorie": 2920,
  "weight": 94.1,
  "etc": 12.4
},
{
  "_id": {
    "$oid": "69bc05f803957addf3492f58"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-02-17T08:10:00.000Z"
  },
  "calorie": 2911,
  "weight": 93.7,
  "etc": 12.5
},
{
  "_id": {
    "$oid": "69bc062203957addf3492f59"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-02-17T09:37:00.000Z"
  },
  "calorie": 2909,
  "weight": 93.6,
  "etc": 12.5
},
{
  "_id": {
    "$oid": "69bc065b03957addf3492f5a"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-02-17T11:12:00.000Z"
  },
  "calorie": 2906,
  "weight": 93.5,
  "etc": 12.5
},
{
  "_id": {
    "$oid": "69bc07bb03957addf3492f5b"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-02-18T09:23:00.000Z"
  },
  "calorie": 2905,
  "weight": 93.4,
  "etc": 12.5
},
{
  "_id": {
    "$oid": "69bcaf457594aa47a1ffcf6d"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-02-21T05:54:00.000Z"
  },
  "calorie": 2890,
  "weight": 92.7,
  "etc": 12.5
},
{
  "_id": {
    "$oid": "69bcaf767594aa47a1ffcf6e"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-02-22T04:40:00.000Z"
  },
  "calorie": 2882,
  "weight": 92.3,
  "etc": 12.5
},
{
  "_id": {
    "$oid": "69bcafa07594aa47a1ffcf6f"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-02-22T08:49:00.000Z"
  },
  "calorie": 2882,
  "weight": 92.3,
  "etc": 12.5
},
{
  "_id": {
    "$oid": "69bcb0037594aa47a1ffcf70"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-02-23T05:00:00.000Z"
  },
  "calorie": 2896,
  "weight": 92.9,
  "etc": 12.5
},
{
  "_id": {
    "$oid": "69bcb0557594aa47a1ffcf71"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-02-24T05:29:00.000Z"
  },
  "calorie": 2882,
  "weight": 92.3,
  "etc": 12.5
},
{
  "_id": {
    "$oid": "69bcb0997594aa47a1ffcf72"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-02-25T06:55:00.000Z"
  },
  "calorie": 2877,
  "weight": 92.1,
  "etc": 12.5
},
{
  "_id": {
    "$oid": "69bcb0fb7594aa47a1ffcf73"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-02-26T02:34:00.000Z"
  },
  "calorie": 2871,
  "weight": 91.8,
  "etc": 12.5
},
{
  "_id": {
    "$oid": "69bcb15c7594aa47a1ffcf74"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-02-26T06:30:00.000Z"
  },
  "calorie": 2866,
  "weight": 91.6,
  "etc": 12.5
},
{
  "_id": {
    "$oid": "69bcb19e7594aa47a1ffcf75"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-02-27T03:27:00.000Z"
  },
  "calorie": 2895,
  "weight": 92.9,
  "etc": 12.5
},
{
  "_id": {
    "$oid": "69bcb1c87594aa47a1ffcf76"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-02-27T07:05:00.000Z"
  },
  "calorie": 2885,
  "weight": 92.5,
  "etc": 12.5
},
{
  "_id": {
    "$oid": "69bcb1ee7594aa47a1ffcf77"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-02-27T05:18:00.000Z"
  },
  "calorie": 2882,
  "weight": 92.3,
  "etc": 12.5
},
{
  "_id": {
    "$oid": "69bcb2197594aa47a1ffcf78"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-02-28T07:05:00.000Z"
  },
  "calorie": 2878,
  "weight": 92.2,
  "etc": 12.5
},
{
  "_id": {
    "$oid": "69bf4d7fb45f760424238770"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-01T04:30:00.000Z"
  },
  "calorie": 2881,
  "weight": 92.3,
  "etc": 12.5
},
{
  "_id": {
    "$oid": "69bf4db3b45f760424238771"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-01T05:33:00.000Z"
  },
  "calorie": 2880,
  "weight": 92.2,
  "etc": 12.5
},
{
  "_id": {
    "$oid": "69bf4ddcb45f760424238772"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-01T09:13:00.000Z"
  },
  "calorie": 2871,
  "weight": 91.8,
  "etc": 12.5
},
{
  "_id": {
    "$oid": "69bf4e01b45f760424238773"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-02T04:55:00.000Z"
  },
  "calorie": 2870,
  "weight": 91.8,
  "etc": 12.5
},
{
  "_id": {
    "$oid": "69bf4e24b45f760424238774"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-02T06:38:00.000Z"
  },
  "calorie": 2869,
  "weight": 91.7,
  "etc": 12.5
},
{
  "_id": {
    "$oid": "69bf4e46b45f760424238775"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-02T07:54:00.000Z"
  },
  "calorie": 2864,
  "weight": 91.5,
  "etc": 12.5
},
{
  "_id": {
    "$oid": "69bf4e61b45f760424238776"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-02T08:21:00.000Z"
  },
  "calorie": 2863,
  "weight": 91.4,
  "etc": 12.5
},
{
  "_id": {
    "$oid": "69bf4e8ab45f760424238777"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-03T05:40:00.000Z"
  },
  "calorie": 2865,
  "weight": 91.5,
  "etc": 12.5
},
{
  "_id": {
    "$oid": "69bf4eadb45f760424238778"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-03T08:51:00.000Z"
  },
  "calorie": 2860,
  "weight": 91.3,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69bf4f1eb45f760424238779"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-04T05:03:00.000Z"
  },
  "calorie": 2861,
  "weight": 91.4,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69bf4f3fb45f76042423877a"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-04T07:34:00.000Z"
  },
  "calorie": 2858,
  "weight": 91.2,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69bf51b7b45f76042423877b"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-05T05:22:00.000Z"
  },
  "calorie": 2858,
  "weight": 91.2,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69bf51d9b45f76042423877c"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-05T07:34:00.000Z"
  },
  "calorie": 2854,
  "weight": 91,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69bf6560b45f76042423877d"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-06T06:50:00.000Z"
  },
  "calorie": 2850,
  "weight": 90.9,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69bf6589b45f76042423877e"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-06T05:10:00.000Z"
  },
  "calorie": 2861,
  "weight": 91.3,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69bf65b6b45f76042423877f"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-06T06:37:00.000Z"
  },
  "calorie": 2857,
  "weight": 91.2,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69bf65cfb45f760424238780"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-06T07:37:00.000Z"
  },
  "calorie": 2857,
  "weight": 91.1,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69bf6608b45f760424238781"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-08T05:01:00.000Z"
  },
  "calorie": 2854,
  "weight": 91,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69bf6628b45f760424238782"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-08T06:38:00.000Z"
  },
  "calorie": 2852,
  "weight": 90.9,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69bf664eb45f760424238783"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-09T04:42:00.000Z"
  },
  "calorie": 2844,
  "weight": 90.6,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69bf6669b45f760424238784"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-09T07:23:00.000Z"
  },
  "calorie": 2842,
  "weight": 90.5,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69bf6688b45f760424238785"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-10T04:25:00.000Z"
  },
  "calorie": 2839,
  "weight": 90.3,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69bf66cfb45f760424238786"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-13T03:09:00.000Z"
  },
  "calorie": 2839,
  "weight": 90.3,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69bf66feb45f760424238787"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-14T04:48:00.000Z"
  },
  "calorie": 2830,
  "weight": 89.9,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69bf671eb45f760424238788"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-15T03:28:00.000Z"
  },
  "calorie": 2840,
  "weight": 90.4,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69bf6743b45f760424238789"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-15T07:31:00.000Z"
  },
  "calorie": 2828,
  "weight": 89.8,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69bf6ae7b45f76042423878a"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-16T05:09:00.000Z"
  },
  "calorie": 2847,
  "weight": 90.7,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69bf6b04b45f76042423878b"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-17T06:30:00.000Z"
  },
  "calorie": 2830,
  "weight": 89.9,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69bf6b20b45f76042423878c"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-18T02:59:00.000Z"
  },
  "calorie": 2830,
  "weight": 89.9,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69bf6b3fb45f76042423878d"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-18T06:46:00.000Z"
  },
  "calorie": 2822,
  "weight": 89.5,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69bf6b60b45f76042423878e"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-19T06:08:00.000Z"
  },
  "calorie": 2817,
  "weight": 89.3,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69bf6b82b45f76042423878f"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-22T09:21:00.000Z"
  },
  "calorie": 2826,
  "weight": 89.7,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69c1bcc75ef2c33e8dd1a423"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-24T05:55:00.000Z"
  },
  "calorie": 2824,
  "weight": 89.6,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69c1cd361337d04634c24f0d"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-24T07:30:00.000Z"
  },
  "calorie": 2821,
  "weight": 89.5,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69c493903ce92fedd49b7cbc"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-25T04:31:00.000Z"
  },
  "calorie": 2833,
  "weight": 90.1,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69c493b13ce92fedd49b7cbd"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-25T07:19:00.000Z"
  },
  "calorie": 2824,
  "weight": 89.6,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69c493e73ce92fedd49b7cbe"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-26T05:03:00.000Z"
  },
  "calorie": 2833,
  "weight": 90.1,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69c4940b3ce92fedd49b7cbf"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-26T09:41:00.000Z"
  },
  "calorie": 2824,
  "weight": 89.6,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69c5d3e5aa8604e9b36307e4"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-27T06:00:00.000Z"
  },
  "calorie": 2828,
  "weight": 89.8,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69c5d406aa8604e9b36307e5"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-27T06:53:00.000Z"
  },
  "calorie": 2823,
  "weight": 89.6,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69c5d422aa8604e9b36307e6"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-27T08:40:00.000Z"
  },
  "calorie": 2820,
  "weight": 89.4,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69c7265b7667ed5d8359218a"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-28T04:33:00.000Z"
  },
  "calorie": 2817,
  "weight": 89.3,
  "etc": 12.6
},
{
  "_id": {
    "$oid": "69c7267c7667ed5d8359218b"
  },
  "name": "franky",
  "crtdte": {
    "$date": "2026-03-28T08:18:00.000Z"
  },
  "calorie": 2813,
  "weight": 89.1,
  "etc": 12.6
}]

[marksouzacosta]

Hi @saranoofa2 ,

Thank you for the file.

The first step is to create the JSON Metadata file. I copied the content you sent, created a JSON file in a Windows folder in my desktop and mapped this JSON file using Talend:

Change the Date Pattern for the Date/Time field:

Below the tFileInputJSON configuration and the Job run output:

You can find attached the full project exported.

Regards,

Mark Costa

[saranoofa2]

Hi Mark,

It is working. Thanks for guidance 

Next, I want to make it the Date in format --> dd-MM-yyyy with AM/ PM time

Did you have any idea ? I want to try it

[marksouzacosta · Accepted solution]

To do that, add a tMap in your diagram:

Change the tMap date output Date format to the desired format - in your case "dd-MM-yyyy hh:mm:ss a":

Regards,

Mark Costa

[saranoofa2]

Hi Mark,

Problem solved. Thanks ya