Extract Nodes Json File

[Anonymous]

hi, I'm trying to extract the nodes from a Json file to be able to insert them into a database, but I'm only getting error from Talend.

The json file is follow:

At the simple action for test in LogRow

Thank you for your answers.

[Anonymous · Accepted solution]

Hi,

For nested JSON files loop JSON Query should be "$.[*]" and Mapping columns should have "node name" as json query .

Please make changes to Mapping columns and Loop JSON Query in tFileInputJSON as mentioned in image. It worked for sample file provided.

Thanks,

Vinesh

[Anonymous]

Perfect! thanks for this solution in my case have problem with java installation.

Now correct run, and I apply your implementation and the result is correct.

Regards.