Trying to Delete records from Creator not found in CRM

Trying to Delete records from Creator not found in CRM

    Hi,

    In the following script, I am trying to delete records from Creator not found in CRM, but I am getting the error message "Error at line number: 55 Improper Statement
    Error might be due to missing ';' at end of the line or incomplete expression".

    Please advise on fix.

    1. void ZC_SyncCRMtoCreator()
    2. {
    3.     // Step 1: Fetch existing Creator records
    4.     existing_creator_records = Supplier_Sales_Data_Form[ID != 0];
    5.     creator_meid_map = map(); // MEID -> Record ID

    7.     for each rec in existing_creator_records
    8.     {
    9.         if (rec.MEID != null)
    10.         {
    11.             creator_meid_map.put(rec.MEID.toString(), rec.ID);
    12.         }
    13.     }

    15.     // Step 2: Fetch records from CRM
    16.     crm_response = invokeUrl
    17.     [
    18.         url : "https://www.zohoapis.com/crm/v2/Accounts"
    19.         type : GET
    20.         connection : "regional_suppliers"
    21.     ];

    23.     crm_data = crm_response.get("data");
    24.     crm_active_meid_map = map(); // MEID -> CRM record

    26.     for each crm_rec in crm_data
    27.     {
    28.         status = crm_rec.get("Status");
    29.         meid = crm_rec.get("MEID");

    31.         if (meid != null && status == "Active")
    32.         {
    33.             meid_str = meid.toString();
    34.             crm_active_meid_map.put(meid_str, crm_rec);
    35.         }
    36.     }

    38.     // Step 3: Insert new records from CRM to Creator
    39.     for each meid_str in crm_active_meid_map.keySet()
    40.     {
    41.         if (!creator_meid_map.containsKey(meid_str))
    42.         {
    43.             crm_rec = crm_active_meid_map.get(meid_str);
    44.             insert into Supplier_Sales_Data_Form
    45.             [
    46.                 Company_Name = crm_rec.get("Account_Name")
    47.                 MEID = meid_str
    48.                 Lead_ID = crm_rec.get("Lead_ID")
    49.                 Channel = crm_rec.get("Channel")
    50.             ];
    51.         }
    52.     }

    54.     // Step 4: Delete records from Creator not found in CRM
    55.     for each meid_str in creator_meid_map.keySet()
    56.     {
    57.         if (!crm_active_meid_map.containsKey(meid_str))
    58.         {
    59.             rec_id = creator_meid_map.get(meid_str);
    60.             delrec = Supplier_Sales_Data_Form[ID == rec_id];
    61.             if (delrec != null)
    62.             {
    63.                 delete delrec;
    64.             }
    65.         }
    66.     }

    68.     info " CRM sync complete.";
    69. }