Hi Community there,
Could anyone please help, many thanks!
I want to user field 'phone_mobile' to filter all related user via calling endpoint: XXXX/Contacts/filter
I can get some records by setting pload in the request:
pload = {
"filter":[
{"$or":[
{"phone_work":"+61 8 8373 6420"},
{"phone_mobile":"+61 403 995 372"}
]
}
]
}
But my problem is the format of the number is different between what is in the sugar system and the parameter we pass:
1. the number passed vi parameters will be the format without space, say: "+61883736420";
2. the number in sugar system can be with or without '+', same for the space : 61419876746, 0477 151 598, +61 419 019 954 ,etc.
So, my question is:
If the format of the phone number passed from command is fixed.
Instead of getting all results first and pre-processing phone number and then matching the number passed from command.
When I pass the number, can I pre-process the result and then filter when calling API?
Is there any endpoint can do that?