Hi, all!I am currently creating a membership lookup function for our ticketing website and I'd like to give the option to search for an account based on constituent number, email, or phone number. I have the constituent number and email working perfectly, but does anyone know if there is a place that I can query the Tessitura API using a phone number? It seems that all the places where the phones are, you need the constituent number as well. Thanks in advance for the help!
You can look up Constituents using Phone as a search via the API by using the POST CRM/Constituents/Search resource. You can find help for this resource from your own API help pages, or from the static version (15.1) here: https://www.tessituranetwork.com/REST_v151/TessituraService/HELP/API/GET_CRM_CONSTITUENTS_SEARCH_TYP.HTM
This is used in the client application. From Constituent Search window, you can open the Log Viewer (Help menu, Log Viewer) to see request URIs and responses when making a search. In the application, the single line search (called "fluent" in the API) will do a phone lookup if a hash (#) precedes a number. So a search of "#5556667777" would look up constituents having a phone number matching 5556667777 (no regional formatting expected). This translates to the API request URL as such (with hash encoded):
HTTPS://{yourbaseuri}/TessituraService/CRM/Constituents/Search?type=fluent&q=%23555666777
The response is ConstituentSearchResponse which provides a collection of ConstituentSummaries.
Hope this helps!
-Ryan Creps