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" } ]}