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.
- Go to PayPal Developers Website home page.
- Then Login to the dashboard.
- Go to “[Your Name]“, then go to “Dashboard” in the top right corner. You will get an option to “Create App“.
- Fill in the details for the new app and create a new app.
- 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.
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.
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:
- On Integrate, click on "Add..." to search for Paypal and select it.
- Name your integration.
- Connect with you Client code and Secret Code.
- Once you have connected to your Paypal, you can start importing your objects.
- 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.