Paypal Integration

In this article, we’ll integrate a PayPal data source with Y42.

You can find the list of available reports and the available dimensions and metrics for each report on Paypal API documentation.


Authentication: App Credentials
Settings: Historical Date selection, Account selection
Schema type: Fixed
Update Type: Full import and incremental


Application credentials are strongly generated username:password combinations and have a one-to-one binding with a membership in the consortia. They are strictly isolated to the environment in which they are created and can only be used to access a node/service owned by the same membership that created the credentials.
For this authentication you will need to retrieve your Client ID and your secret code:
  1. Go to PayPal Developers Website home page.
  2. Then Login to the dashboard.
  3. Go to “[Your Name]“, then go to “Dashboard” in the top right corner. You will get an option to “Create App“. 
  4. Fill in the details for the new app and create a new app. 
  5. On the next page, you will be able to see your PayPal Client Id and secret.

Note: You will find Sandbox App settings and credentials on the same page.


Import Settings

By default the historical date will be set to one year ago. Refer to your own datasource to decide from which exact date you would want to retrieve data.

Account pre-requisites

You have the option of connecting with either a Sandbox account or not.



You can find a list of available API endpoints and their entities for this integration on Paypal API documentation.


Updating your data

You have the option of scheduling Full imports or Incremental Imports by the month, weeks, days, and even by the hour. With the incremental import you will only add the new rows to that table, while a full import will actually re-import the entire table completely.

Incremental imports significantly increase the import speed, we import your table incrementally based on the last imported state e.g. id - If the table does not have a state, a full import will be triggered - This is done automatically.

We recommend therefore to schedule an incremental import regularly, but also schedule a full import with a certain frequency -- this is because only the full import will guarantee that old rows that have been updated on the data source will also get updated on your Y42 integration destination.


Paypal Storage Setup Guide:

  1. On Integrate, click on "Add..." to search for Paypal and select it.

  2. Name your integration.

  3. Connect with you Client code and Secret Code.

  4. Once you have connected to your Paypal, you can start importing your objects.

  5. Select the tables you need and click import. You can access the tables once the status is “Ready”.

Note: You can always import and reimport other tables as well, or delete them.

Was this article helpful?
0 out of 0 found this helpful