Install and Configure the Recipe

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

On the Oracle Integration Home page, scroll to the Accelerators & Recipes section.
Click Search All.
The list of available recipes appears.
Select the PayPal — FTP | Export Invoices recipe , and click Install .
A confirmation message informing the recipe was successfully installed appears, and the recipe now displays the Installed tag.
Click Configure on the recipe card to configure the following resources using the Configuration Editor.

You must configure connection properties and log in credentials for your PayPal instance.

On the Configuration Editor page, select Oracle PayPal Connection.
Click Edit .
The PayPal Connection window appears.
In the Connection Properties section, from the PayPal Environment drop-down list, select the environment (Sandbox).
In the Security section, from the Security Policy drop-down list, select Client Credentials.
In the Client Id and Client Secret fields, enter the Client ID and Secret that you obtained before.
See Get PayPal API Credentials.
Click Save. If prompted, click Save for a second time to confirm.
Click Test to ensure that your connection is successfully configured. In the dialog that displays, click Test again.
You get a confirmation message if your test is successful.
Click Back to return to the Configuration Editor page. Click Save again if prompted.

You must configure connection details such as connection properties and log in credentials for your FTP server.

In the Connection 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.

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.

Click Save. If prompted, click Save for a second time to confirm.
Click Test to ensure that your connection is successfully configured. In the dialog that displays, click Test again.
You get a confirmation message if your test is successful.
Click Back to return to the Configuration Editor page. Click Save again if prompted.

You must configure connection details such as connection properties and log in credentials for your REST PayPal connection.

In the Configuration Editor, select Oracle REST PayPal Connection.
Click Edit .
The REST Connection window appears.
From the Connection Type drop-down list, select REST API Base URL.
In the Connection URL field, enter the endpoint URL of your PayPal instance. For example: https://api-sample.sandbox.paypal.com/.
In the Security section, from the Security Policy drop-down list, select Basic Authentication.
In the Username field enter the Client ID, and in the Password field enter the Client Secret that you obtained before.
See Get PayPal API Credentials.
Click Save. If prompted, click Save for a second time to confirm.
Click Test to ensure that your connection is successfully configured. In the dialog that displays, click Test again.
You get a confirmation message if your test is successful.
Click Back to return to the Configuration Editor page. Click Save again if prompted.

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

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.