is there a way to ignore case sensitivity while querying Items using SOAP/REST API's Fusion ItemsV2
Summary:
Hi team, we are having some issue with case sensitivity in item numbers. Most item numbers are upper case in Oracle but there are some that have lower case characters. If Item Number doesn't match between Source and Oracle, the ItemsV2 REST API see it as a new number and creating as new one.
Our question is, is it possible to remove the item number case sensitivity from the Items V2 REST API calls? If, for example, 120276-c1 was queried, the call to return 120276-C1 details ignoring case.
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):