- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.3K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Case sensitivity on Fusion REST API calls
I'm using the Fusion REST API to retrieve payables invoices and I want the user to be able to search by supplier name. The following works using the expression syntax but I want it to be case-insensitive.
/fscmRestApi/resources/11.13.18.05/invoices/?q=Supplier LIKE 'XXX'
i.e. I would like to have something along the lines of ?q=UPPER(Supplier) LIKE 'XXX' so that the user doesn't need to know the case of how suppler names were originally entered.
Is something like this possible on an expression?