Skip to content

Latest commit

 

History

History
94 lines (69 loc) · 6.41 KB

paypal-transaction.md

File metadata and controls

94 lines (69 loc) · 6.41 KB
Raw

Paypal Transaction

This page contains the setup guide and reference information for the Paypal Transaction source connector.

Prerequisites

The Paypal Transaction API is used to get the history of transactions for a PayPal account.

Setup guide

Step 1: Set up Paypal Transaction

In order to get an Client ID and Secret please go to this page and follow the instructions. After registration you may find your Client ID and Secret here.

:::note

Note: Our Paypal Transactions Source Connector does not support OAuth at this time due to limitations outside of our control. If OAuth for Paypal Transactions is critical to your business, please reach out to us to discuss how we may be able to partner on this effort.

:::

Step 2: Set up the Paypal Transaction connector in Airbyte

For Airbyte Cloud:

  1. Log into your Airbyte Cloud account.
  2. In the left navigation bar, click Sources. In the top-right corner, click +new source.
  3. On the Set up the source page, enter the name for the Paypal Transaction connector and select Paypal Transaction from the Source type dropdown.
  4. Enter your client id
  5. Enter your secret
  6. Choose if your account is sandbox
  7. Enter the date you want your sync to start from
  8. Click Set up source.

For Airbyte Open Source:

  1. Navigate to the Airbyte Open Source dashboard
  2. Set the name for your source
  3. Enter your client id
  4. Enter your secret
  5. Choose if your account is sandbox
  6. Enter the date you want your sync to start from
  7. Click Set up source

Supported sync modes

The PayPal Transaction source connector supports the following sync modes:

Feature Supported?
Full Refresh Sync Yes
Incremental - Append Sync Yes
Namespaces No

Supported Streams

This Source is capable of syncing the following core Streams:

Performance considerations

Paypal transaction API has some limits

  • start_date_min = 3 years, API call lists transaction for the previous three years.
  • start_date_max = 1.5 days, it takes a maximum of three hours for executed transactions to appear in the list transactions call. It is set to 1.5 days by default based on experience, otherwise API throw an error.
  • stream_slice_period = 1 day, the maximum supported date range is 31 days.
  • records_per_request = 10000, the maximum number of records in a single request.
  • page_size = 500, the maximum page size is 500.
  • requests_per_minute = 30, maximum limit is 50 requests per minute from IP address to all endpoint

Transactions sync is performed with default stream_slice_period = 1 day, it means that there will be 1 request for each day between start_date and now or end_date. if start_date is greater then start_date_max. Balances sync is similarly performed with default stream_slice_period = 1 day, but it will do additional request for the end_date of the sync now.

Data type map

Integration Type Airbyte Type
string string
number number
array array
object object

Changelog

Version Date Pull Request Subject
0.1.10 2022-09-04 17554 Made the spec and source config to be consistent
0.1.9 2022-08-18 15741 Removed OAuth2.0 option
0.1.8 2022-07-25 15000 Added support of OAuth2.0 authentication, fixed bug when normalization couldn't handle nested cursor field and primary key
0.1.7 2022-07-18 14804 Added RESULTSET_TOO_LARGE error validation
0.1.6 2022-06-10 13682 Updated paypal transaction schema
0.1.5 2022-04-27 12335 Added fixtures to mock time.sleep for connectors that explicitly sleep
0.1.4 2021-12-22 9034 Updated connector fields title/description
0.1.3 2021-12-16 8580 Added more logs during check connection stage
0.1.2 2021-11-08 7499 Removed base-python dependencies
0.1.1 2021-08-03 5155 Fixed start_date_min limit
0.1.0 2021-06-10 4240 PayPal Transaction Search API