I have JSON data in bulk almost 1000 documents in array and i want to insert this data in mognodb in a collection named material but when insert data it mongodb gives error:

Failed to import with the following error:

E11000 duplicate key error collection: cooper.materials index: id_1 dup key: { id: null }” id should not be null because mongoose automatically generate a unique id for each document . just one record is added but remaining ere not

I’m trying to insert my JSON data that includes almost 1000 of documents in a single array and want to store them in my MongoDB collection named material. I’m expecting it should be stored with unique IDs in separate documents

[
    {
        "Modified_User": "portal_vera4",
        "Generic_Name": "Paint & Coatings - Primer/Sealer",
        "Modified_Time": "12-10-2024 13:40:55",
        "Vendors": "Color Atelier",
        "Rate": "187.71",
        "Size_Finish": "1G-Liquid",
        "Reference_Number": "PROM-Pain-03121",
        "Product_Name": "Wax-Sealer",
        "Image": "/sharedBy/appLinkName/viewLinkName/fieldName/image/1733856038481_COLOR_ATELIER_Paint___Plaster_Wax-Sealer_1G.webp",
        "Material_Name": "Wax-Sealer-Color Atelier-Paint & Plaster/1G-Liquid",
        "Unit": "Gallon",
        "Material_Number": "3121",
        "Brand_Name": "Color Atelier",
        "Latest_Pricing_Date": "Tuesday, Dec 10 2024",
        "Model": "Paint & Plaster",
        "Added_User": "portal_vera4",
        "Added_Time": "12-10-2024 13:40:55"
    },
    {
        "Modified_User": "portal_vera4",
        "Generic_Name": "Paint & Coatings - Plaster",
        "Modified_Time": "12-10-2024 13:34:41",
        "Vendors": "Color Atelier",
        "Rate": "130.88",
        "Size_Finish": "32lbs",
        "Reference_Number": "PROM-Pain-03119",
        "Product_Name": "Base Coat Interior & Exterior",
        "Image": "/sharedBy/appLinkName/viewLinkName/fieldName/image/1733855662137_COLOR_ATELIER_Paint___Plaster_Base_Coat_Interior_Exterior_32lbs.webp",
        "Material_Name": "Base Coat Interior & Exterior-Color Atelier-Paint & Plaster/32lbs",
        "Unit": "Name",
        "Material_Number": "3119",
        "Brand_Name": "Color Atelier",
        "Latest_Pricing_Date": "Tuesday, Dec 10 2024",
        "Model": "Paint & Plaster",
        "Added_User": "portal_vera4",
        "Added_Time": "12-10-2024 13:34:41"
    },
    {
        "Modified_User": "portal_vera4",
        "Generic_Name": "Paint & Coatings - Primer/Sealer",
        "Modified_Time": "12-10-2024 13:31:04",
        "Vendors": "Color Atelier",
        "Rate": "68.88",
        "Size_Finish": "1G",
        "Reference_Number": "PROM-Pain-03118",
        "Product_Name": "Alkali Resistant Adhesive",
        "Image": "/sharedBy/appLinkName/viewLinkName/fieldName/image/1733854898581_COLOR_ATELIER_Paint___Plaster_Alkali_Resistant_Adhesive_1G.webp",
        "Material_Name": "Alkali Resistant Adhesive-Color Atelier-Paint & Plaster/1G",
        "Unit": "Gallon",
        "Material_Number": "3118",
        "Brand_Name": "Color Atelier",
        "Latest_Pricing_Date": "Tuesday, Dec 10 2024",
        "Model": "Paint & Plaster",
        "Added_User": "portal_vera4",
        "Added_Time": "12-10-2024 13:22:46"
    }]}