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

Coupa Procurement Adapter Capabilities

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

The Coupa Procurement Adapter provides the following capabilities:

  • Supports the following modules:

    • Purchase Orders
    • Requisitions
    • Contracts
    • Payment Terms
    • Advance Ship Notices
    • Exchange Rates
    • Items
    • Address
    • Budget Lines
    • Commodities
    • Comments
    • Attachments
    • Bulk Import

  • Supports attachments, including the ability to import and export in bulk up to 250 MB.

  • Supports custom fields.

  • Supports pagination.
  • Supports query and filter parameters.
  • Supports OAuth Client Credentials and OAuth Authorization Code Credentials authentication.

The Coupa Procurement 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, the Advance Ship Notices, Purchase Orders, Requisitions, and Budget Lines 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.