You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Unable to filter the sales order line EFF data using single rest api call

edited Sep 10, 2024 1:21PM in Integrations and Extensions

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!