Install and Configure the Recipe

On your Oracle Integration instance, install the recipe to deploy and configure the integration and associated resources.

Install the recipe on your Oracle Integration instance. See Install a Recipe or Accelerator.

After you've installed the recipe, configure the following resources:

Configure the PayPal Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, from the PayPal Environment drop-down list, select the environment (Sandbox).
  3. In the Security section, from the Security Policy drop-down list, select Client Credentials.
  4. In the Client Id and Client Secret fields, enter the Client ID and Secret that you obtained before. See Configure PayPal.
  5. Click Save. If prompted, click Save again.
  6. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.

    A message confirms if your test is successful.

  7. To return to the project workspace, click Go back Back icon.

Configure the FTP Read Write Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    Field Information to Enter
    FTP Server Host Address Enter the host address of your sFTP server.
    FTP Server Port 22
    SFTP Connection Select Yes from the list.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select FTP Server Access Policy.
    User Name Enter the user name to connect to your sFTP server.
    Password Enter the password to connect to your sFTP server.
  4. Click Save. If prompted, click Save again.
  5. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.

    A message confirms if your test is successful.

  6. To return to the project workspace, click Go back Back icon.

Configure the REST PayPal Connection

  1. In the Connections section, click the connection name.
  2. From the Connection Type drop-down list, select REST API Base URL.
  3. In the Connection URL field, enter the endpoint URL of your PayPal instance. For example: https://api-sample.sandbox.paypal.com/.
  4. In the Security section, from the Security Policy drop-down list, select Basic Authentication.
  5. In the Username field enter the Client ID, and in the Password field enter the Client Secret that you obtained before.
  6. Click Save. If prompted, click Save again.
  7. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.

    A message confirms if your test is successful.

  8. To return to the project workspace, click Go back Back icon.

Configure Lookups

Configure lookups to associate values used by one application (PayPal) to values used by the other application (FTP).

  1. In the Lookups section, click the lookup name.
  2. In the lookup table, specify values for FTP_DIR, invPrefix, and pageSize.
    config_name config_value
    FTP_DIR The directory path where the invoice files will be uploaded in the FTP server. For example /oracle-int/paypal-invoices.
    invPrefix Prefix of the invoice files. For example, if the file name is detail_INV-NOV2020.JSON then the prefix is detail_.
    pageSize Number of files that are to be fetched per call from PayPal. For example 1.
  3. Click Save. If prompted, click Save again.
  4. To return to the project workspace, click Go back Back icon.