topic Re: Extract Nodes Json File in Talend Studio

Extract Nodes Json File

Anonymous — Sat, 27 Apr 2019 13:42:06 GMT

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 — Sat, 27 Apr 2019 17:04:46 GMT

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 — Mon, 29 Apr 2019 20:37:27 GMT

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.