Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

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!