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:
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:
Hello Sophie,
You can use Logic Builder to define your own endpoint and configure pre-processing in Sugar with no-code, so that the custom endpoint provides you an expected answer (list of user ids , I reckon)
Would you like to have an example posted here?
Best Regards,
Dmytro Chupylka
integroscrm.com
We make work in Sugar CRM system faster, more convenient and efficient
Hi Dmytro,
Thanks a lot for your reply.
Do you have any sample about logic builder please?
I’m totally new to sugar...
The number format in sugar system is inconsistent since it’s typed by every single individual.
I just want to make the phone number have a consistent format so that I can filter better.
Thanks a lot!
I would try to see if you can make the format in sugar more consistent. The easiest way, I think, is to do a export of the data and to correct the data in the CSV File that is exported and upload it again. In Excel it is much easier to correct errors. Next you would need to add a validation to the phone number fields that force people to fill in the correct format (based in country etc..). How to add validation can be found here: support.sugarcrm.com/.../
Thank you very much, Jeroen!
I have about 30K contacts to be updated.
Do you know if I can update the phone number via importing a cab file?
Jeroen,
one more piece information: Our instance is cloud instance and I just have the administrator role... so I don’t where to change the php file... Is there a way for an administrator to set the field validation, please? Thank you very much!
One possible solution is that do it with GlobalSearchAPI, the unique requirement is that your fields into Contacts are aviable for Search (by studio)
I leave the following documentation:
I hope help you
Cheers!
Hi Sanchez,
Thank you very much for your reply!
It seems the global search is relevant.
But for my case, could you please suggest how to organize the search expression?
I still couldn’t imagine it...
Thank you very much!
I leave one example made in Postman:
Thanks a lot! I’ll try it!
Hi,