MongoDB, Find Request Problem

I have a problem with the find method of the MongoDB node.

My workflow:

I am trying to find documents in my mongo database that match the names present on my google sheets.

My problem:

The problem is that the MongoDB node, with the find method, returns only one output while there are several entries and several matches.

In the example below, I expect 2 items in the output of the MongoDB node for example, because there will be two matches.
Obviously the variable in find is dynamic.

Google sheets Data

Capture d’écran 2022-05-10 170058

MongoDB Data


Last output

Hi @Nayel_Ferai, I am sorry to hear you’re having trouble here.

The MongoDB node behaves similar to other database nodes which would typically run only once when querying data, but it seems it’s missing from the respective list so far :see_no_evil:. We’ll make sure to update the documentation.

You can still search for different items, but you’d need to split these up and then run the node once for every single incoming item. This can be done by adding a Split In Batches node like so:

I hope this helps! Let me know if you have any questions on this approach :slight_smile:

1 Like