C# ROQL Query Email Address

Content

I have a list of customers email addresses that I want to query against the Contacts table in the Oracle Service Cloud.  I basically want to see if the email address exists in the system, so I could just select the count and if it is greater than 0 that would give me what I need. I have attached my code.  I am using a while loop to go through my email list.

Thanks,

Andrew

 

 

Version

February '15

Code Snippet

             SELECT count() FROM Contact WHERE (Contact.Emails[0].Address = '" + customers[i].email + "'OR Contact.Emails[1].Address = '" + customers[i].email + "'OR Contact.Emails[2].Address = '" + customers[i].email + "');