Certain information in this article may be missing or out of date. We are in the process of updating the content.
Paypal allows you to securely send money, receive money, or set up a merchant account. This article will give you an overview of the PayPal/Grow (Beta) integration.
Connecting to PayPal
- Select the Data tab next to the Dashboard.
This takes you to the Data Overview page. - Click on the Connections button.
- Click on the blue Connect button at the end of the Your Top Data Sources options.
- From the list of Connections, search and select the PayPal logo.
A window pops up to log in with your PayPal credentials. Once the connection is successful, a green confirmation message is displayed.
If the green success message pops up without the window to enter your credentials, that means your previously logged in PayPal account was used to connect to Grow.
Data Warehousing
You can store the raw data from PayPal in the warehouse. For more information about warehousing your data, visit the Data Warehouse Help Article.
Tables
The list of tables available will depend on your unique PayPal project. You can expect to see one table per dataset associated with the project Id in your connection.
Others Tables
Invoices
Products
Subscriptions
Warehousing Your Data
Starting with the Connections Overview Page, navigate to your PayPal connection. Click on it to open the Connection Details page.
Select the Manage Connection button inside the Connection Details section to open the warehouse table selection flow.
Select the data you want stored in the Data Warehouse and click the Sync & Store button at the bottom of the Manage Connection page.
This will begin the initial population of your warehouse with the tables you defined. Populating your data warehouse for the first time may take a while, even up to several hours.
You may continue working within the app while your data is In Queue or Processing.
If your data source is not already connected, refer to the Connecting to a Data Source for more details.
Sync Interval
Full Sync
The default sync interval is 1 week.
Full sync intervals is 12 hours for Other tables.
Incremental Sync
Incremental sync is not supported for Other tables.
To learn more about sync intervals and how to adjust the default settings, please visit the Sync section of the Data Warehouse help article.
Endpoints
The PayPal/Grow (Beta) integration currently offers a connection to the Invoices endpoint from PayPal. When you connect to this report, it returns a list of the invoices created. Some of the data that it returns include the following:
- ID
- Number
- Status (Paid, cancelled, refunded, marked as paid, etc.)
- Merchant info
- Billing details (i.e. email, business name)
- Shipping info
- Invoice date
- Payment information
- Notes
- Value and currency
- Refund amounts, currencies, and other information
- Among other details.
API Documentation
https://developer.paypal.com/api/rest/
https://developer.paypal.com/api/nvp-soap/
https://graphql.braintreepayments.com/