Contact search should be case insensitive via API
While creating the sales invoice via API, usually we check if the contact is already created or not, to search the contact the name/keyword must be used in the same case that is available on Xero, if its different then it will not search.
Hi Swapnil,
Thanks for the post.
We currently have a work around for the issue you are currently facing which may be of use.
It is possible to include ToLower() in the where clause when quering the endpoint. ie. ?Name.ToLower()=="{name}’
See the following commultiy thread for more information: https://stackoverflow.com/questions/60265042/can-xero-contacts-be-filtered-by-name-case-insensitive
-
brian23
commented
That would definitely improve usability, especially for applications that rely on quick contact lookups. I recently came across while researching how organised public data can simplify searches https://dallascountyassessor.org Making the API case insensitive would reduce unnecessary errors and create a more consistent experience for everyone using it.
-
bradley_carter
commented
I couldn't agree more with making the API search case insensitive, as it saves so much frustration when dealing with unpredictable user inputs. I recently ran into a similar issue while pulling up some files through the https://indianrivercountycourt.org system, where a minor capitalization typo completely blocked the query results. Implementing a lowercase normalization step on the backend is such a simple fix that drastically improves the overall user experience. It is always the little backend details like this that make a database truly reliable and easy to work with!
-
oliver
commented
I completely agree, making the contact search case insensitive would save everyone a lot of headaches. When dealing with large datasets, strict casing just creates unnecessary friction, as we've noticed while managing https://mesacountycourt.org through our own integrations. It really should be a standard feature across all APIs to ensure smoother queries.
-
Sophia Adams
commented
I agree that making contact search case insensitive through the API would improve usability and reduce unnecessary search failures. I recently came across http://wilsoncountycourt.org while looking into how legal record searches can be organized, and it reminded me how much smoother a flexible search experience can be. Small enhancements like this can save users time and make integrations far more reliable. Thanks for bringing up such a practical improvement.