1. Using the Coupa Sourcing Adapter with Oracle Integration 3
  2. Understand the Coupa Sourcing Adapter
  3. Coupa Sourcing Adapter Capabilities

Coupa Sourcing Adapter Capabilities

The Coupa Sourcing Adapter enables you to create an integration between Coupa and Oracle Integration. You can configure the Coupa Sourcing Adapter as an invoke connection in an integration in Oracle Integration.

The Coupa Sourcing Adapter provides the following capabilities:

  • Supports the following modules:

    • Attachments
    • Coupa Pay
    • Expense Reports
    • Invoices
    • Legal Entity
    • Payables / Payable
    • Suppliers
    • Users

  • Supports Create, Update, Delete, and Get actions. For example, you can create a user, expense reports, supplier, travel expense, invoice, and legal entity in Coupa.

  • Enables you to integrate the near real-time data between Coupa and other external systems.

  • Supports REST web services.

  • Supports custom fields.
  • Supports attachment downloads of up to 250 MB.
  • Supports pagination.
  • Supports query and filter parameters.
  • Supports OAuth Client Credentials and OAuth Authorization Code Credentials authentication.

The Coupa Sourcing Adapter is one of many predefined adapters included with Oracle Integration. See the Adapters page in the Oracle Help Center.

Query Parameters Support

Query parameters are used to fetch a specific set of records based on certain conditions. These are applicable for all GET operations in Coupa.

Types of Query Parameters

  • Offset: Skips the record as per the order by passing an integer. For example, if the user sets the offset to 3, the first three records are skipped, and the results start from the fourth record.
  • Limit: Restricts the number of records fetched in a single API call. By default, Coupa fetches 50 records per call, but the limit can be set to fetch a specific number of records as required.
  • Filter: Filters are used to fetch records that meet specific criteria. This parameter restricts the number of fields fetched in a single API call. The filter name is passed as a parameter, and only records that match the filter condition are fetched.
  • Order By: Returns the response as per the order of fields passed in the query parameter (it can be in terms of alphabetical/numeric order).
  • Direction: Used in conjunction with Order By to specify the direction of sorting, either ascending or descending.
  • Return Object: This parameter has three values: shallow, limited, and none. It specifies the level of detail included in the returned records. See API Return Formats.

Pagination Support

Pagination is used to retrieve a subset of data from a larger data set to display in pages, typically in response to user requests that exceed the default limit of 50 records per API call.

Functionality

  • Iteration: Pagination works by iterating through the records in batches (usually 50 records per batch) until all records are fetched. Each iteration fetches the next set of records.
  • APIs Supporting Pagination: Not all Coupa APIs support pagination. Generally, APIs that fetch a large number of records (more than 50) support pagination. For example, users, suppliers, and invoices modules support pagination.
  • Implementation: Pagination involves setting up a loop that fetches records in batches. The process continues until all records are retrieved. If the body of the response is empty, the pagination stops.