Searching using telephone numbers

Searching using telephone numbers

Hi,

I am looking to pop a screen based on a phone number.

Q1. Is there a way to search across Leads and Contacts with one query - at the moment it seems I have to issue a query for each type of entity.


Q2. The datastore I am searching against has telephone numbers in seemingly free format. e.g. some entries have spaces between area code and number, others dont, some have +xx in front etc.

So many of my searches fail because the of what seems to be a requirement to exact-match:

https://crm.zoho.com/crm/private/xml/Contacts/searchRecords?authtoken={0}&scope=crmapi&criteria=(((Phone:{1})OR(Mobile:{2})OR(Home Phone:{3})OR(Other Phone:{4})))"

Is there any way round this - can we do matches where the backend remoes spaces for example?

Thanks for any pointers.