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. }

      Zoho Campaigns Resources


        • Desk Community Learning Series


        • Digest


        • Functions


        • Meetups


        • Kbase


        • Resources


        • Glossary


        • Desk Marketplace


        • MVP Corner


        • Word of the Day


        • Ask the Experts


          Zoho CRM Plus Resources

            Zoho Books Resources


              Zoho Subscriptions Resources

                Zoho Projects Resources


                  Zoho Sprints Resources


                    Zoho Orchestly Resources


                      Zoho Creator Resources


                        Zoho WorkDrive Resources



                          Zoho CRM Resources

                          • CRM Community Learning Series

                            CRM Community Learning Series


                          • Tips

                            Tips

                          • Functions

                            Functions

                          • Meetups

                            Meetups

                          • Kbase

                            Kbase

                          • Resources

                            Resources

                          • Digest

                            Digest

                          • CRM Marketplace

                            CRM Marketplace

                          • MVP Corner

                            MVP Corner




                            Zoho Writer Writer

                            Get Started. Write Away!

                            Writer is a powerful online word processor, designed for collaborative work.

                              Zoho CRM コンテンツ






                                ご検討中の方