how to search by EFF fields on Sales order API.
Summary:
We have a question on how to search by EFF fields on Sales order API. We have some values stored in certain EFFs, and trying to figure out how to search of all sales order by EFF
Specifically, we have values for ’Sell Branch’ stored under sales order header EFF. How do we search for all sales order by a certain value of a Sell Branch, for example.
Sell Branch | Order header EFF | ATTRIBUTE_CHAR7 |
|---|
/fscmRestApi/resources/11.13.18.05/salesOrdersForOrderHub
The current API we have is using a BIP report under the hood to enable filtering by EFF, but we are worried that this will not scale especially on a high touch touch point API like order header lookup / filtering. We have run some quick benchmarks and seen a max of 5 req/s. Can you provide any guidance on how this API pattern will scale when moved into production? How have you seen other companies handle this limitation of Fusion?