Searching parent entity based on values in child entity REST API

Summary

Searching parent entity based on values in child entity REST API

Content

Hi,

We are using saas application standard REST API to get invoices.

Now, we want to search invoices based on child entities e.g this REST API returns Header fields, attachments, invoiceDff fields etc. Now we want this REST api to return invoices based on invoiceDff fields condition like q=invoiceDff.queueName='processed' on VBCS screen.

{
    "items": [
        {
            "InvoiceId": 45,
            "InvoiceNumber": "297110",
            "InvoiceCurrency": "CNY",
            "PaymentCurrency": "CNY",
            "InvoiceAmount": 8296.2,

            "invoiceDff": [
                {
                    "InvoiceId": 45,
                    "__FLEX_Context": "Scanning Data",
                    "__FLEX_Context_DisplayValue": "Scanning Data",
                    "ponumber": null,
                    "ponumber_Display": null,
                    "queueName": "Processed"

}]

]}

Please let us know how to implement this requirement.