Json Files map to the mongo DB

[Anonymous]

hi
I have big size json files and i have to put in to the mongoDB. I am using tFileInputJson component to fetch the data from json file but the problem is that json files is having so much fields and while defining the schema i have to take care of each field,even while mapping i have to write Json Path query for each field. it's become very complicated,
Is there any component by which i will automatically get the fields from json files. so that i can directly put in to the mongoDB

Thanks In advance

[Anonymous]

Hi,
You want to guess the schema of your big json file, right? Here is a good new for community user. This feature is in available in Talend Open Studio Version 5.3. The latest version will be released in recent(Pay more attention on forum announcement).
see my pic
Best regards
Sabrina

[Anonymous]

Hi ashish.s,
A good news, Talend Open Studio 5.3.0 products have been released. Please get them from products and the feature "File json" in metadata is avaiable in Talend Open Studio 5.3.0 products(see my pic).
Best regards
Sabrina

[Anonymous]

Hi,
You are welcome. thanks for your feedback.
Best regards
Sabrina

[Anonymous]

Hi xdshi,
Thanks for the reply and understanding my post but can it is possible through Talend V 5.2.2 if not then in 5.3.0 can you give me the screenshot with simple steps how to do it.

[Anonymous]

Hi,
"File json" feature is only available in 5.3.0.
Please see the related reference to know how to set the json file schema JSON+file+schema.
Best regards
Sabrina

[Anonymous]

Hi Sabrina,

Thanks for reply, now I am able to get the schema through File json component in V 5.3.0 but for a few the files while uploading I am getting errors like "{0} is not found or json file formate is incorrect", i checked my files in the json validater it is telling valid.
Do you have any idea about it ,why i am getting this errors or how i can resolve this problem.

Regards
Ashish

[Anonymous]

Hi,
From the error message, it means that your json file format is not correct. If a few of files are valid and others are invalid, I think the validation function of "File Json" is working. Could you please paste your error json file into forum, perhaps we can address this issue.
Best regards
Sabrina

[Anonymous]

Hi Sabrina,
I also have facing the same issue when I tried talend 5.3 this feature. Even for the VALID Json, it emits the validation error stating the format is incorrect.
I infact the enterprise user for Talend 5.2.1 and hoping this feature is really useful going forward. I can attach the json file which I tried to upload in "File Json" metadata creator to define the json schema through talend 5.3.
Please let me know how to attach the file as I don't see the option here to attach the file
-Rajeshram

[Anonymous]

Hi,
There is no option for "Attachment ", you can paste the json file content into forum so that I can consult it to our component developer.
Best regards
Sabrina