Fusion REST API filtering based on child resources: journal batches, journal headers, journal lines?
Summary:
Querying the Fusion Financials journalBatches REST API with the filter, q=journalHeaders.journalLines.AccountCombination='ABC-123-DEF-456'
returns all batches. The expectation was that only journal batches containing journal entries for the specific account combination would be in the response.
The basis for this expectation was the documentation, "In REST framework version 2 and later, advanced query syntax is supported: more operators, filtering based on child resource fields," found here: Set the REST Framework Version
Content (please ensure you mask any confidential information):
An example request:
GET https://omitted-instance.fa.ocs.oraclecloud.com/fscmRestApi/resources/11.13.18.05/journalBatches?q=journalHeaders.journalLines.AccountCombination='ABC-123-DEF-456'&limit=500&fields=JeBatchId&onlyData=true