We are having timeout error observed when we try to use the SOAP API, ItemsV2 using a % in filter
We are having timeout error observed when we try to use the SOAP API, ItemsV2 using a % in filter. This timeout is observed, wven if the results set is expected to be small(Ex: lkess than 100). Appreciate any help in suggesting any changes to the below SOAP UI call to make it quicker.
We are looking to get all Items that have a specific formulation %FOM12345% within an EFF field.
We are trying to see whether the REST API (ItemsV2, REST-Framework-Version: 2) can be used to query items via an EFF just in case it doesn't suffer the same issue, but we are having trouble figuring out the syntax for the query using an EF hence looking for some guidance on whether we could ever query efficiently by this EFF (espec. considering the query will need to use a 'CONTAINS' rather than an 'EQUALS' operator), and if not, any suggestion to achieve our goal.