topic Re: Read JSON file in Talend Studio

Read JSON file

saranoofa2 — Sat, 28 Mar 2026 05:19:23 GMT

Hello,

My JSON file as below

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

Below is the full JSON

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

Re: Read JSON file

marksouzacosta — Sun, 29 Mar 2026 20:01:47 GMT

Hi @saranoofa2 ,

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

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

Regards,

Mark Costa

Re: Read JSON file

saranoofa2 — Sun, 29 Mar 2026 20:04:24 GMT

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 }]

Re: Read JSON file

marksouzacosta — Sun, 29 Mar 2026 21:16:05 GMT

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

Re: Read JSON file

saranoofa2 — Sun, 29 Mar 2026 22:23:27 GMT

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

Re: Read JSON file

marksouzacosta — Sun, 29 Mar 2026 23:18:33 GMT

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

Re: Read JSON file

saranoofa2 — Mon, 30 Mar 2026 00:09:00 GMT

Hi Mark,

Problem solved. Thanks ya