Unable to filter the sales order line EFF data using single rest api call
Summary:
I need to filter the sales order line EFF data based on one field say PO_Number is not null.
Reason to do this: as per requirement we need to get all the SO line where eff po number is not null and release the pauses from order orchestation fulfillment line.
Approach: we want to make one single rest api call to get the required filtered data to proceed further only for the eligilble SO line.
Content (please ensure you mask any confidential information):
Ex: is it possible to use below syntax somehow to make it work.
https://iatgqy-dev1.fa.ocs.oraclecloud.com/fscmRestApi/resources/11.13.18.05/salesOrdersForOrderHub?q=OrderNumber=1308 and lines.LineNumber='1' and lines.additionalInformation.FulfillLineEffBInvoicingprivateVO is not null&expand=lines&onlyData=true