topic Re: Unable to extract JSON fields from tMongoDBInput using tExtractJSONFields in Talend Studio

Unable to extract JSON fields from tMongoDBInput using tExtractJSONFields

Anonymous — Sat, 16 Nov 2024 08:47:05 GMT

Hi,

I've been trying to extract JSON fields from my tMongoDBInput (documents from a mongo collection) using a tExtractJSONFields component, but I'm unable to use it.

Logging the output shows :

A JSONObject text must begin with '{' at character 1 of Document{{code=P2.IB.LET, category=PROSECUTION}}

My JSON (document) from mongo looks like this:

{ "_id" : { "code" : "P2.IB.LET", "category" : "PROSECUTION" }, "value" : 1 }
{ "_id" : { "code" : "P2.FILECOPY", "category" : "PROSECUTION" }, "value" : 3 }
{ "_id" : { "code" : "SRNT", "category" : "FAI Request" }, "value" : 1 }
{ "_id" : { "code" : "P.399", "category" : "PROSECUTION" }, "value" : 1 }
{ "_id" : { "code" : "REIS.REVFORM", "category" : "PROSECUTION" }, "value" : 4 }

I've attached screenshots of my settings and the output as well.

I've tried using Json path as well as Xpath giving similar output (json path just gives a blank output).

I need to use tExtractJSONFields for a few other use cases as well, so it's really important that I can get this working.

Any help would be greatly appreciated.

Thanks!

Re: Unable to extract JSON fields from tMongoDBInput using tExtractJSONFields

manodwhb — Thu, 01 Feb 2018 07:07:35 GMT

I have read the Json file with JsonPath using tFileInputJson.

Re: Unable to extract JSON fields from tMongoDBInput using tExtractJSONFields

manodwhb — Thu, 01 Feb 2018 07:14:26 GMT

what are you giving in Loop Jsonpath query ,in tExtractJSONFields?

Re: Unable to extract JSON fields from tMongoDBInput using tExtractJSONFields

Anonymous — Thu, 01 Feb 2018 09:16:17 GMT

I was giving "$" as json looppath query.

It's working fine now, the settings/parameters were all fine. I'm posting the answer.

Re: Unable to extract JSON fields from tMongoDBInput using tExtractJSONFields

Anonymous — Thu, 01 Feb 2018 09:18:15 GMT

I resolved the issue.

The problem was with the mongo driver version I used in Talend.

I changed the DB version setting in tMongoDBConnection from 3.5.X to 3.2.X and it's working fine now.

Just for note, my MongoDB version is 3.6.2.

Re: Unable to extract JSON fields from tMongoDBInput using tExtractJSONFields

Anonymous — Mon, 02 Dec 2019 09:06:21 GMT

thanks

Re: Unable to extract JSON fields from tMongoDBInput using tExtractJSONFields

kanuparthy — Thu, 18 Jun 2020 20:34:44 GMT

Can I have sample code to extract array objects from mongodb input