API (v2) Search Criteria using CONCAT
With API I can search for a contact using First_Name and Last_Name. However, when I need to search the Contact Module using a full name — and because CRM does not provide an API for full name — I am not finding a way to do this in the traditional way using 'concat'. It is not an option for me to separate the full name I am using to compare (:equals:) because some first names and last names have spaces between them so it is impossible to know where the separation would take place. For example, if this is the full name in the variable I need to compare:
Gary Thomas Duran
There is no way to know whether the first name is "Gary Thomas" or if the last name is "Thomas Duran".
I have tried many variations on this theme without success getting either a 401 or a 400 error depending on the iteration. I'm looking for the proper way to use concat in the search criteria (with an example if possible). Thank you.