New to KNIME facing issues using MongoDB Reader need help

#1

Dear Friends,

I am very new to KNIME and trying to connect MongoDB through MongoDB reader to extract few data from the collection.

But I am receving the below error:
“ERROR MongoDB Reader 2:1 Execute failed: Cannot parse query:db.getCollection(‘callingbatchdetails’).count()”

image
image.png1366×730 52.2 KB

image
image.png444×541 11.7 KB

Able to successfully execute the above query through MongoDB.
image

Please help…

0 Likes
#2

Can anyone guide where am i going wrong in using the MongoDB reader component

0 Likes
#3

I only gave the MongoDB nodes a quick attempt a while ago, but as far as I remember you can only perform .find() operations. As they don’t support aggregation queries either, I’m not sure whether there’s any viable workaround.

Without wanting to sound harsh, but I found them hardly usable for any real-world use cases.

– Philipp

1 Like
#4

For the .find() operation also receiving the same error.

image
image.png1366×729 48 KB

Is that i am missing anything

0 Likes
#5

is there any other alternative available in KNIME through which i can connect to MongoDB.

0 Likes
#6

The node’s description states that it uses Jongo as the query language which is different from the Mongo shell language.

1 Like
#7

Hi,

I tried using the mongo query language as well but getting the same error. Can you please guide.

0 Likes