Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Case sensitivity on Fusion REST API calls

splattMar 28 2022

Hi,
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?
Thanks,
Steve

Added on Mar 28 2022

#applications-integration-using-oracle-fusion-middleware, #fusion, #rest, #soa-process-management

3 comments

643 views

1 mention