MongoDB: how to get the _id?

Question

Hi all,

I am doing my first steps with FME.

I am trying to read a MongoDB collection using the Mongo reader. To retreive the unique document identifier _id, I use the mongodb_id format attribute. Is it correct?

Then when data are loaded, this attribute does not seem well encoded:

Id (encoded: utf-8): ��{y�q�M�ݰ��z�'

How to fix this?

Many thanks for your help!

Answer 1 · 2018-03-19T10:48:01Z

Answer by ac_ac · Mar 19, 2018 at 10:48 AM

Dear @jakemolnar,

Are the provided file correct?

Many thanks, best regards.

Add comment · Share

10 |4000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 4.0 MB each and 4.0 MB total.

Answer 2 · 2018-03-08T18:22:43Z

Answer by jakemolnar · Mar 08, 2018 at 06:22 PM

Hi @ac_ac, could you post some logs, and a workspace if possible?

Add comment · Show 1 · Share

10 |4000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 4.0 MB each and 4.0 MB total.

ac_ac · Mar 13, 2018 at 09:26 AM 0

Share

Dear @jakemolnar

Many thanks for your interest on my question.

Please find the logs:
mongotoverticajdbc-log.txt

And workspace:
mongotoverticajdbc.fmw

mongotoverticajdbc-log.txt (19.9 kB)

mongotoverticajdbc.fmw (53.6 kB)

MongoDB: how to get the _id?

2 Replies

Follow this Question

Related Questions