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 Março 3, 2021, 4:41pm 13

hey @harshil1712

I found the solution here Loop through MySQL Results

Tópico		Respostas	Visualizações
Loop through MySQL Results Questions	1	1625	3 de Março de 2021
Inserting documents if they don't already exist in MongoDB (with multiple items) Questions	3	1172	16 de Novembro de 2024
MongoDB nothing found stop the whole execution Questions	3	630	22 de Outubro de 2021
MongoDB query returns 0 items on first execution but succeeds on second execution Questions data-transformation , deployment , node , mongodb , edit-fields	9	148	16 de Julho de 2026
Force items one by one Questions data-transformation	5	919	22 de Fevereiro de 2022

Check the record already exists in MongoDB?

Tópicos relacionados