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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

API Fetch Purchase agreements based on Supplier, supplierSite and ItemNumber (BPA)

in Purchasing 3 comments

API Fetch Purchase agreements based on Supplier, supplierSite and ItemNumber (BPA)

Hi Oracle community,

I have API to fetch data based on Supplier, supplierSite but unable to add additional filter on Lines level data ItemNumber .

Working API-
https://iatgqy-dev1.fa.ocs.oraclecloud.com/fscmRestApi/resources/11.13.18.05/purchaseAgreements?expand=lines&q=Supplier='ABC';SupplierSite='ABC Site'

Non Working API - (expand and filter on child item)
https://iatgqy-dev1.fa.ocs.oraclecloud.com/fscmRestApi/resources/11.13.18.05/purchaseAgreements/?expand=lines&q=Supplier='ABC';SupplierSite='ABC Site'&q=lines.Item=ItemNumber_xyz

Problem with Working API is, it will produce multiple Agreements with same combination of supplier and Supplier site and "ItemNumber_xyz" combination would be present in one of them. The Result should fetch me only one agreement where the item is present.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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