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

REST API query parameters for Purchase Orders not working

I am using the Purchase Order REST API to get the details of Purchase Orders by providing a line description. But the response I am getting is just 200 status but no data is coming as part of Response Payload although there is data available.

Request:

https://*****-dev1.fa.ocs.oraclecloud.com/fscmRestApi/resources/latest/purchaseOrders?q=CreationDate>'2025-08-01' AND UPPER(lines.Description) like UPPER('%iPhone%') &expand=lines&onlyData=true&limit=100

Response:

{    "items": [],    "count": 0,    "hasMore": false,    "limit": 100,    "offset": 0,    "links": [        {            "rel": "self",            "href": "https://*****-dev1.fa.ocs.oraclecloud.com:443/fscmRestApi/resources/11.13.18.05/purchaseOrders",            "name": "purchaseOrders",            "kind": "collection"        }    ]}

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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