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

[Anonymous]

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

[Anonymous]

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"