topic Re: Extraction of values from mongodb collection in Talend Studio

Extraction of values from mongodb collection

Anonymous — Tue, 07 Jul 2015 09:38:30 GMT

Hi,
While extracting a particular field "key" from mongodb collection using textractjsonfield I'm getting below error.
Error on line 1 of document : The content of elements must consist of well-formed character data or markup. Nested exception: The content of elements must consist of well-formed character data or markup
"requests" : ,
Any solution?????
Thanks in advance..

Re: Extraction of values from mongodb collection

Anonymous — Wed, 08 Jul 2015 10:56:58 GMT

Hi,
Did you check your json source file to see if it is well-formed (Json Validator JSONLint)?
Have you tried to added this json source file to the repository Talend to see if it works?
Could you please take a look at a jira issue: https://jira.talendforge.org/browse/TDI-28800?
Best regards
Sabrina

Re: Extraction of values from mongodb collection

Anonymous — Fri, 10 Jul 2015 09:57:15 GMT

Yeah json file is well formed only.. I have similar structure files and i'm able to extract values from those files..

Re: Extraction of values from mongodb collection

cmadaka — Fri, 10 Jul 2015 16:10:22 GMT

I am getting the same issue. Unable to convert to flat (relational) from JSON Array format. Any help is appreciated.
Regards

Re: Extraction of values from mongodb collection

Anonymous — Thu, 16 Jul 2015 11:18:11 GMT

Hi,
Could you please show us the screenshot of textractjsonfield commponent setting?
Best regards
Sabrina