Filter for fields that may have spaces via Web API

(0) Share

Report

Posted on by Mihai V

Hello,

I'm trying to get customer details based on his telephone number via WEB API

The following example is successful because the number in CRM is formatted with spaces:

GET /api/data/v9.1/contacts?$filter=contains(mobilephone, '+41 12 345 67 89')&$select=fullname

The problem is that the numbers doesn't have a fixed format.. sometimes they are +41123456789 and some times they have spaces in between. All combinations are possible.

Do you know how should I format my filter to include all format possibilities?

Thank you,

Mihai

All responses (1)

Answers (0)

Mihai V 5 on at

Like (0)

Report

RE: Filter for fields that may have spaces via Web API

I have answered my question alone after some more searching. I put % between all digits like %+%4%1%1%2%3%4%5%6%7%8%9% and it seems it works.