Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Search invoices based on InvoiceDFF context based fields — Cloud Customer Connect
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

Search invoices based on InvoiceDFF context based fields

Received Response
22
Views
3
Comments
edited Aug 20, 2019 6:53AM in Integrations and Extensions 3 comments

Summary

Search invoices based on InvoiceDFF context based fields

Content

Hi,

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

Now, we want to search invoices based on  invoiceDff context based fields. This API should return invoices based on invoiceDff fields condition like q=invoiceDff.queueName='processed'.

{
    "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"

}]

]}

We have tried something like below 

https://********oraclecloud.com:443/fscmRestApi/resources/latest/invoices?expand=invoiceDff&onlyData=true&q=invoiceDff.queueName='Processed';

but it throws error :

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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