MongoDB look up of Json

CloverDX Platform
1

Hi,
I have a scenario , One json file which contains product details, need to insert into mongodb after checking existence of each product.

How can I check each json product of the file with the mongoDB and perform insertion if not exist and update if exist.
I got stuck here for three days.

Please help.Thanks in advance

2

Hi Micky,

I think DataIntersection is the component you seek, see http://doc.cloveretl.com/documentation/ … ction.html

Based on specified key fields, you can compare records from two sources and react in three ways. For instance:
A) If the record is in your json input file and does not exist in DB, you can insert it.
B) If the record exists in both sources, you can update it in DB.
C) If the record exists in DB and does not exist in the json file, you can delete it or skip it.

Regards,