## Problem Description
I'm trying to match user emails from MongoDB with Zoho CRM contacts, but the email search isn't finding matches even though emails exist in Zoho. Phone number matching works fine.
## Workflow Setup
1. MongoDB → Aggregate Documents (gets user data)
2. Loop Over Items (iterates through users)
3. Search Contacts in Zoho CRM (fails to match by email)
## What I've Tried:
- Search by email: `{{ "((Email:equals:'" + $json.T_email + "'))" }}` → No matches
- Search by phone: `{{ "((Phone:equals:'" + $json.T_phone + "'))" }}` → Works perfectly
- Cleaned email with Transform node (trim, lowercase)
- Tried different Zoho fields (Email, Contact_Email, Secondary_Email)
## Error Messages:
- No error when searching by email, just returns empty results
- Phone search returns correct contact data
The issue is likely with how Zoho CRM indexes and searches email fields. Here’s how to fix your email matching, Use COQL (Zoho’s Query Language) Instead
Change your Zoho search node to use “Search Records (COQL)” instead of regular search:
COQL Query:
SELECT * FROM Contacts WHERE Email = ‘{{ $json.T_email }}’
This is more reliable for email matching.
