PayPal Transaction

Availability

Core Standard Plus Pro Enterprise Flex Self-Managed Enterprise PyAirbyte

Support Level

Airbyte

Connector Version

2.6.25 (last updated 10 days ago)

Sync Success Rate

Usage Rate

Definition ID

d913b0f2-cc51-4e55-a44c-8ba1697b9239

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

This connector uses PayPal APIs OAuth 2.0 access token to authenticate requests.

Prerequisites

You need a PayPal account, which you can get by following these steps.

On the same page, you can also find how to set up a sandbox so you can test the connector before using it in production.

Setup guide

Step 1: Get your PayPal credentials

After creating your account, you can get your Client ID and Secret from the Apps & Credentials page.

Step 2: Set up the PayPal Transaction connector in Airbyte

1. Log into your Airbyte account

   • For Cloud Log in here.

2. In the left navigation bar, click Sources.

   a. If this is your first time creating a source, use the search bar and enter Paypal Transaction and select it.

   b. If you already have sources configured, go to the top-right corner and click +new source. Then enter Paypal Transaction in the search bar and select the connector.

3. Set the name for your source

4. Enter your Client ID

5. Enter your Client secret

6. Start Date: Use the provided datepicker or enter manually a UTC date and time in the format YYYY-MM-DDTHH:MM:SSZ.

7. Toggle Sandbox on or off. By default, the toggle is off, meaning the connector works with the production environment.

8. (Optional) Dispute Start Date Range: Use the provided datepicker or enter a UTC date and time in the format YYYY-MM-DDTHH:MM:SS.sssZ. The milliseconds are required. If you don't set a date, the list_disputes stream defaults to 180 days in the past. This option only applies to the list_disputes stream.

9. (Optional) Refresh Token: You can enter a refresh token manually. The connector handles token refresh automatically.

10. (Optional) Number of days per request: The number of days of data to request per API call. This helps avoid hitting rate limits. PayPal has a 10K record limit per request, so this option is useful if your sync frequency is weekly and you have more than 10K records per week. The default value is 7, and the maximum is 31 days.

11. Click Set up source

info

By default, syncs are run with a slice period of 7 days. If you see errors with the message Result set size is greater than the maximum limit or an error code like RESULTSET_TOO_LARGE:

• Try lowering the size of the slice period in the optional parameters of your connection configuration.
• You can try lowering the scheduling sync window in case a single-day slice period is not enough. Lowering the sync period may help avoid reaching the 10K limit.

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:

• Transactions
• Balances
• List Products
• Show Product Details
• List Disputes
• Search Invoices
• List Payments

Transactions Stream

The following table contains the configuration parameters and default values for this stream.

Param/Feature	Transactions
Start Date	Timestamp with TZ (no ms)
Dispute Start Date Range	NA
Refresh token	Auto
Number of days per request	Max 31 , 7(D)
Pagination Strategy	Page Increment
Page size	Max 500 (F)
Full Refresh	✅
Incremental	✅ (D)

D: Default configured Value

F: Fixed Value. This means it is not configurable.

---

Balances Stream

The following table contains the configuration parameters and default values for this stream.

Param/Feature	Balances
Start Date	Timestamp with TZ (no ms)
Dispute Start Date Range	NA
Refresh token	Auto
Number of days per request	NA
Pagination Strategy	NA
Page size	NA
Full Refresh	✅
Incremental	✅ (D)

D: Default configured Value

F: Fixed Value. This means it is not configurable.

---

List Products Stream

The following table contains the configuration parameters and default values for this stream.

Param/Feature	List Products
Start Date	NA
Dispute Start Date Range	NA
Refresh token	Auto
Number of days per request	NA
Pagination Strategy	Page Increment
Page size	Max 20 (F)
Full Refresh	✅ (D)
Incremental	❌

D: Default configured Value

F: Fixed Value. This means it is not configurable.

caution

The API limits the speed of data retrieval. A catalog with 30K or more products could take 10-15 minutes to retrieve.

---

Show Products Stream

The following table contains the configuration parameters and default values for this stream.

Param/Feature	Show Prod. Details
Start Date	NA
Dispute Start Date Range	NA
Refresh token	Auto
Number of days per request	NA
Pagination Strategy	NA
Page size	NA
Full Refresh	✅ (D)
Incremental	❌

D: Default configured Value

F: Fixed Value. This means it is not configurable.

caution

The parent stream (list_products) paginates with a maximum page size of 20 items. PayPal API calls are not concurrent, so the time depends entirely on the server. This stream could take a considerable time to sync. Depending on the size of the catalog, it could take several hours.

---

List Disputes Stream

The following table contains the configuration parameters and default values for this stream.

Param/Feature	List Disputes
Start Date	NA
Dispute Start Date Range	Timestamp with TZ (w/ms)
Refresh token	Auto
Number of days per request	Max 180 , 7(D)
Pagination Strategy	Page Token
Page size	Max 50 (F)
Full Refresh	✅
Incremental	✅ (D)

D: Default configured Value

F: Fixed Value. This means it is not configurable.

---

Search Invoices Stream

The following table contains the configuration parameters and default values for this stream.

Param/Feature	Search Invoices
Start Date	Timestamp with TZ (no ms)
Dispute Start Date Range	NA
Refresh token	Auto
Number of days per request	ND
Pagination Strategy	Page Number
Page size	Max 100 (F)
Full Refresh	✅ (D)
Incremental	❌

D: Default configured Value

F: Fixed Value. This means it is not configurable.

ND: Not Defined in the source.

info

The start_date from the configuration is passed to the body of the request as creation_date_range.start and creation_date_range.end. For more information, see the PayPal Invoicing API documentation.

---

List Payments Stream

The following table contains the configuration parameters and default values for this stream.

info

The PayPal Payments API v1 is deprecated by PayPal. This stream continues to work, but PayPal recommends using the Orders API v2 for new integrations.

Param/Feature	List Payments
Start Date	Timestamp with TZ (no ms)
Dispute Start Date Range	NA
Refresh token	Auto
Number of days per request	NA , 7(D)
Pagination Strategy	Page Cursor
Page size	Max 20 (F)
Full Refresh	✅
Incremental	✅ (D)

D: Default configured Value

F: Fixed Value. This means it is not configurable.

---

Performance Considerations

• Data Availability: It takes a maximum of 3 hours for executed transactions to appear in the list transactions call.
• Number of days per request: The maximum supported date range is 31 days.
• Historical Data: You can't retrieve more than 3 years of data for the transactions stream. For dispute_start_date, you can only retrieve 180 days of data (see specifications per stream).
• records_per_request: The maximum number of records in a single request is 10K (API server restriction).
• page_size: The number of records per page differs per stream. The connector sets the maximum allowed page size for each stream by default.
• requests_per_minute: The maximum limit is 50 requests per minute from a single IP address to all endpoints (API server restriction).

Data type map

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

Reference

Config fields reference

Field

Type

Property name

string

client_id

string

client_secret

boolean

is_sandbox

string

start_date

string

dispute_start_date

string

end_date

string

refresh_token

integer

time_window

Changelog

Expand to review

Version	Date	Pull Request	Subject
2.6.26	2026-02-27	74027	Fix INVALID_DATE_TIME_FORMAT error on disputes stream by using 3-digit milliseconds
2.6.25	2026-02-17	73574	Update dependencies
2.6.24	2026-02-10	73171	Update dependencies
2.6.23	2026-02-03	72637	Update dependencies
2.6.22	2026-01-22	70967	Update HTTP response action for 400 error transactions from IGNORE to FAIL
2.6.21	2026-01-20	71652	Update dependencies
2.6.20	2025-12-18	70505	Update dependencies
2.6.19	2025-11-25	69974	Update dependencies
2.6.18	2025-11-18	69668	Update dependencies
2.6.17	2025-10-29	69044	Update dependencies
2.6.16	2025-10-21	68286	Update dependencies
2.6.15	2025-10-14	67760	Update dependencies
2.6.14	2025-10-07	67348	Update dependencies
2.6.13	2025-09-30	66378	Update dependencies
2.6.12	2025-09-09	65835	Update dependencies
2.6.11	2025-08-23	65171	Update dependencies
2.6.10	2025-08-09	64716	Update dependencies
2.6.9	2025-08-02	64258	Update dependencies
2.6.8	2025-07-26	63821	Update dependencies
2.6.7	2025-07-19	63449	Update dependencies
2.6.6	2025-07-12	63255	Update dependencies
2.6.5	2025-07-05	62625	Update dependencies
2.6.4	2025-06-28	62390	Update dependencies
2.6.3	2025-06-21	61932	Update dependencies
2.6.2	2025-06-14	51848	Update dependencies
2.6.1	2025-06-05	58674	Update CDK to fix complex datatype errors with interpolation
2.6.0	2024-10-23	47282	Migrate to Manifest-only
2.5.8	2025-01-11	43797	Starting with this version, the Docker image is now rootless. Please note that this and future versions will not be compatible with Airbyte versions earlier than 0.64
2.5.7	2024-06-25	40269	Update dependencies
2.5.6	2024-06-22	40110	Update dependencies
2.5.5	2024-06-04	38983	[autopull] Upgrade base image to v1.2.1
2.5.4	2024-05-20	38265	Replace AirbyteLogger with logging.Logger
2.5.3	2024-04-24	36654	Schema descriptions
2.5.2	2024-04-19	37435	Updated manifest.yaml to use the latest CDK Manifest version to fix the Incremental STATE values
2.5.1	2024-03-15	36165	Unpin CDK Version
2.5.0	2024-03-15	36173	Extended Disputes stream schema with missing properties
2.4.0	2024-02-20	35465	Per-error reporting and continue sync on stream failures
2.3.0	2024-02-14	34510	Silver certified. New Streams Added
2.2.2	2024-02-09	35075	Manage dependencies with Poetry.
2.2.1	2024-01-11	34155	prepare for airbyte-lib
2.2.0	2023-10-25	31852	The size of the time_window can be configured
2.1.2	2023-10-23	31759	Keep transaction_id as a string and fetch data in 7-day batches
2.1.1	2023-10-19	31599	Base image migration: remove Dockerfile and use the python-connector-base image
2.1.0	2023-08-14	29223	Migrate Python CDK to Low Code schema
2.0.0	2023-07-05	27916	Update Balances schema
1.0.0	2023-07-03	27968	mark Client ID and Client Secret as required fields
0.1.13	2023-02-20	22916	Specified date formatting in specification
0.1.12	2023-02-18	23211	Fix error handler
0.1.11	2023-01-27	22019	Set AvailabilityStrategy for streams explicitly to None
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