topic Re: Use tFileInputJSON to output one record per object in a JSONArray of objects in Talend Studio

Use tFileInputJSON to output one record per object in a JSONArray of objects

aaronrums — Fri, 15 Nov 2024 21:14:39 GMT

Hello! As the title says, I want to use tFileInputJSON to output 1 record per object, when the json file is structured as in the attached example file.

To be clear, want to have one record PER object in the array, so in the case of the attached file, it would be three rows, and each row would only have a 1 column, which would be the entire JSON object as a string.

I cannot hardcode the column names, because they are not the same for every execution - I will extract the columns names using custom java code later on.

I have attached a screenshot of the component setup right now. I've tried lots of small variations on what you see in the screenshot, including toggling the "use loop node as root".

Thank you!

Re: Use tFileInputJSON to output one record per object in a JSONArray of objects

Anonymous — Tue, 21 Nov 2023 08:10:07 GMT

Set the Json query as below:

"@"

Is this the output string you expect?

Starting job J11 at 16:07 21/11/2023.

[statistics] connecting to socket on port 3480

[statistics] connected

{"FirstName":"Bob","LastName":"Doe"}

{"FirstName":"Frank","LastName":"Doe"}

{"FirstName":"John","LastName":"Doe"}

[statistics] disconnected

Job J11 ended at 16:07 21/11/2023. [Exit code = 0]

Regards

Shong

Re: Use tFileInputJSON to output one record per object in a JSONArray of objects

aaronrums — Tue, 21 Nov 2023 14:20:19 GMT

yes, perfect! I did not know about the "@" character in the json path syntax. Thank you!

Re: Use tFileInputJSON to output one record per object in a JSONArray of objects

Anonymous — Wed, 22 Nov 2023 01:42:14 GMT

Great, thanks for your feedback!