mongoDB reader with BSON

KNIME Analytics Platform
1

Hi everyone,

Has anyone figured out how to use the mongoDB nodes (or JSON reader nodes, for that matter) when the data contains binary data in BSON format (i.e. mongo shell mode) https://docs.mongodb.org/manual/reference/mongodb-extended-json/

I get a JSON parse error: JsonParseException: Unexpected character '< ...  since it isn't proper JSON. My solution at the moment is export the mongodb in strict format, or process the file and remove all BSON, but it would be much nicer to use the built-in reader since that's what it's there for.

Thanks!

2

Hi Patricia,

no, I am sorry we don't have experience about the BSON format so far.

Could you read the files with a file reader , do the modification in KNIME and afterwards convert the file into a single cell and than to a JSON?

Best wishes, Iris