separate fields and parse a json array to get the normal structure of a json file

Anonymous — Tue, 10 Mar 2020 15:58:18 GMT

Hello

I created this job

here is a part of the result of the tow tLogRow

here is a part o my json file structure

my problem is with the arrays the content o an array is tronsformed to a string that contains all fields and values like beneficiaries array so when i insert into my mongo data base the result looks like this

can you help me please to separate fields and parse this string to get the normal structure of a json file ?

Thanks

Re: separate fields and parse a json array to get the normal structure of a json file

Anonymous — Wed, 11 Mar 2020 15:58:20 GMT

Hi,

The problem comes from your Jsonpath tree in tjsoninput component.

Use tExtractJSONField

define "beneficiaries" 's class to "array"

add the sub elements :

for example : jsonpath for "lastName" is "$.beneficiaries[*].name.lastName"

topic Re: separate fields and parse a json array to get the normal structure of a json file in Talend Studio

separate fields and parse a json array to get the normal structure of a json file

Re: separate fields and parse a json array to get the normal structure of a json file