Query Parameters in REST API for Oracle Fusion
Let’s discuss some key parameters frequently used in fusion REST APIs. Let's use the following API endpoint as our reference throughout - /fscmRestApi/resources/11.13.18.05/invoices Query Parameters: 1) Expand Fields like invoiceDFF, invoiceLines are not fetched by default in this API. The Expand parameter allows fetching additional fields. Fields that are usable in parameter – invoiceLines invoiceGdf invoiceDff invoiceInstallments attachments appliedPrepayments availablePrepayments Example – Put this string in Bulk edit: expand:appliedPrepayments,invoiceDff,attachments,availablePrepayments,invoiceGdf,invoiceInstallments,invoiceLines 2) Fields Fetch any Specific field that you want. Including Expand fields mentioned above. Example – Put this string in Bulk edit: - fields:InvoiceId,InvoiceNumber,invoiceDff 3) Limit Limit the number of rec...