Settings and activity
1 result found
-
1 vote
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
An error occurred while saving the comment
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!