Hi, I am using n8n to migrate data from MySQL to MongoDB. Before inserting the data into MongoDB I want to check the record already exists in MongDB. Is there any way to check the record already exists in MongoDB?

Hey @mkiran , n8n handles your data (100+ records) and insert all the data that got returned to MongoDB. Can you check your MongoDB database and see whether all the data got added or not? Also, it might help if you can share your workflow :slightly_smiling_face:

Hey @mkiran ! You can use the Find operation in the MongoDB node. In the Query field you can enter your MongoDB query to search for the records.

yes @harshil1712 , I am doing like this only, but how can I check the mongoDB query returned the results or not?

In the Settings tab of the node, set Always Output Data to true. You can then connect the IF node to the MongoDB node to check if the MongoDB node returned any value or not.

hey @harshil1712 Could you please provide me a sample code for this.

hey @harshil1712 I got it. Thanks for the help.

hey @harshil1712 Now am in different problem. MySQL query is returning more than 100 results. And when I run the workflow it is inserted first record only. When I run it again it is not inserting any rows. Please help me to fix this issue also

@harshil1712 , no it is not inserting all the records verified in MongoDB also. Following is the workflow [image]

Can you share the workflow code? Select all the nodes (Ctrl + A or CMD + A), copy them using CTRL + C, and paste it here. This might be helpful: How can I contribute? | Docs

hi @harshil1712 here is the workflow code { "nodes": [ { "parameters": {}, "name": "Start", "type": "n8n-nodes-base.start", "typeVersion": 1, "position": [ -40, 20 ], "disabled": true }, { "parameters": { "trigg…

Hi @harshil1712 FYI, If I remove already exists (MongoDB-Find) check, then all the records are inserting.

Check the record already exists in MongoDB?

Questions

mkiran 2021年03月03日16:41 13

hey @harshil1712

I found the solution here Loop through MySQL Results

話題		回覆	觀看
Loop through MySQL Results Questions	1	1625	2021年03月03日
Inserting documents if they don't already exist in MongoDB (with multiple items) Questions	3	1172	2024年11月16日
MongoDB nothing found stop the whole execution Questions	3	630	2021年10月22日
MongoDB query returns 0 items on first execution but succeeds on second execution Questions data-transformation , deployment , node , mongodb , edit-fields	9	148	2026年07月16日
Force items one by one Questions data-transformation	5	919	2022年02月22日

Check the record already exists in MongoDB?

Related topics