Skip to content
Book a demoStart free
Connectors

PayPal Enterprise Payments connector

Set up the PayPal Enterprise Payments connector in Kaivo: authentication, configuration, the 7 BigQuery tables it syncs, and answers to common questions.

PayPal Enterprise Payments connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your PayPal Enterprise Payments data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your payment and finance data instead of moving it.

What is the PayPal Enterprise Payments connector

Section titled “What is the PayPal Enterprise Payments connector”

Sync your Braintree payments, transactions, and disputes into BigQuery with Kaivo to report on revenue and reconcile settlements alongside your business data.

CategoryFinance & Payments
AuthenticationAPI key
SetupSelf-service

Getting started with the PayPal Enterprise Payments connector

Section titled “Getting started with the PayPal Enterprise Payments connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your PayPal Enterprise Payments account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticate with your Private Key.

Field Description
Private Key
Your Private Key for authentication. See this help article on how to get this value.

|

Configuring the PayPal Enterprise Payments connector

Section titled “Configuring the PayPal Enterprise Payments connector”

When you set up the connector, you provide:

Field Description
Merchant ID
The identifier for your Braintree account. See this help article on how to get this value.

| | Public Key |

Your Public Key for authentication. See this help article on how to get this value.

| | Start Date |

Any data before this date will not be fetched.

|

Tables and columns synced from PayPal Enterprise Payments

Section titled “Tables and columns synced from PayPal Enterprise Payments”

Kaivo syncs 7 tables from PayPal Enterprise Payments into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

customer_stream (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
company STRING
created_at TIMESTAMP
custom_fields STRING
email STRING
fax STRING
first_name STRING
graphql_id STRING
id STRING
last_name STRING
phone STRING
updated_at TIMESTAMP
website STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
company STRING
country_code_alpha2 STRING
country_code_alpha3 STRING
country_code_numeric STRING
country_name STRING
created_at TIMESTAMP
customer_id STRING
extended_address STRING
first_name STRING
id STRING
last_name STRING
locality STRING
postal_code STRING
region STRING
street_address STRING
updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: customer_stream__android_pay_cards

Section titled “Subtable: customer_stream__android_pay_cards”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
billing_address JSON
bin STRING
card_type STRING
cardholder_name STRING
commercial STRING
country_of_issuance STRING
created_at TIMESTAMP
customer_id STRING
customer_location STRING
debit STRING
default BOOL
durbin_regulated STRING
expiration_date STRING
expiration_month STRING
expiration_year STRING
expired BOOL
healthcare STRING
image_url STRING
issuing_bank STRING
last_4 STRING
masked_number STRING
payroll STRING
prepaid STRING
product_id STRING
token STRING
unique_number_identifier STRING
updated_at TIMESTAMP
google_transaction_id STRING
source_card_type STRING
source_description STRING
is_network_tokenized BOOL
source_card_last_4 STRING
virtual_card_last_4 STRING
virtual_card_type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: customer_stream__apple_pay_cards

Section titled “Subtable: customer_stream__apple_pay_cards”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
billing_address JSON
bin STRING
card_type STRING
cardholder_name STRING
commercial STRING
country_of_issuance STRING
created_at TIMESTAMP
customer_id STRING
customer_location STRING
debit STRING
default BOOL
durbin_regulated STRING
expiration_date STRING
expiration_month STRING
expiration_year STRING
expired BOOL
healthcare STRING
image_url STRING
issuing_bank STRING
last_4 STRING
masked_number STRING
payroll STRING
prepaid STRING
product_id STRING
token STRING
unique_number_identifier STRING
updated_at TIMESTAMP
source_description STRING
payment_instrument_name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
billing_address JSON
bin STRING
card_type STRING
cardholder_name STRING
commercial STRING
country_of_issuance STRING
created_at TIMESTAMP
customer_id STRING
customer_location STRING
debit STRING
default BOOL
durbin_regulated STRING
expiration_date STRING
expiration_month STRING
expiration_year STRING
expired BOOL
healthcare STRING
image_url STRING
issuing_bank STRING
last_4 STRING
masked_number STRING
payroll STRING
prepaid STRING
product_id STRING
token STRING
unique_number_identifier STRING
updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: customer_stream__masterpass_cards

Section titled “Subtable: customer_stream__masterpass_cards”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
billing_address JSON
bin STRING
card_type STRING
cardholder_name STRING
commercial STRING
country_of_issuance STRING
created_at TIMESTAMP
customer_id STRING
customer_location STRING
debit STRING
default BOOL
durbin_regulated STRING
expiration_date STRING
expiration_month STRING
expiration_year STRING
expired BOOL
healthcare STRING
image_url STRING
issuing_bank STRING
last_4 STRING
masked_number STRING
payroll STRING
prepaid STRING
product_id STRING
token STRING
unique_number_identifier STRING
updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: customer_stream__payment_methods

Section titled “Subtable: customer_stream__payment_methods”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: customer_stream__paypal_accounts

Section titled “Subtable: customer_stream__paypal_accounts”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
billing_address JSON
bin STRING
card_type STRING
cardholder_name STRING
commercial STRING
country_of_issuance STRING
created_at TIMESTAMP
customer_id STRING
customer_location STRING
debit STRING
default BOOL
durbin_regulated STRING
expiration_date STRING
expiration_month STRING
expiration_year STRING
expired BOOL
healthcare STRING
image_url STRING
issuing_bank STRING
last_4 STRING
masked_number STRING
payroll STRING
prepaid STRING
product_id STRING
token STRING
unique_number_identifier STRING
updated_at TIMESTAMP
billing_agreement_id STRING
email STRING
payer_id STRING
revoked_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: customer_stream__samsung_pay_cards

Section titled “Subtable: customer_stream__samsung_pay_cards”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
billing_address JSON
bin STRING
card_type STRING
cardholder_name STRING
commercial STRING
country_of_issuance STRING
created_at TIMESTAMP
customer_id STRING
customer_location STRING
debit STRING
default BOOL
durbin_regulated STRING
expiration_date STRING
expiration_month STRING
expiration_year STRING
expired BOOL
healthcare STRING
image_url STRING
issuing_bank STRING
last_4 STRING
masked_number STRING
payroll STRING
prepaid STRING
product_id STRING
token STRING
unique_number_identifier STRING
updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: customer_stream__us_bank_accounts

Section titled “Subtable: customer_stream__us_bank_accounts”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
billing_address JSON
bin STRING
card_type STRING
cardholder_name STRING
commercial STRING
country_of_issuance STRING
created_at TIMESTAMP
customer_id STRING
customer_location STRING
debit STRING
default BOOL
durbin_regulated STRING
expiration_date STRING
expiration_month STRING
expiration_year STRING
expired BOOL
healthcare STRING
image_url STRING
issuing_bank STRING
last_4 STRING
masked_number STRING
payroll STRING
prepaid STRING
product_id STRING
token STRING
unique_number_identifier STRING
updated_at TIMESTAMP
account_holder_name STRING
account_type STRING
ach_mandate STRING
bank_name STRING
business_name STRING
last_name STRING
owner_id STRING
ownership_type STRING
plaid_verified_at TIMESTAMP
routing_number STRING
verifiable BOOL
verified BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
billing_address JSON
bin STRING
card_type STRING
cardholder_name STRING
commercial STRING
country_of_issuance STRING
created_at TIMESTAMP
customer_id STRING
customer_location STRING
debit STRING
default BOOL
durbin_regulated STRING
expiration_date STRING
expiration_month STRING
expiration_year STRING
expired BOOL
healthcare STRING
image_url STRING
issuing_bank STRING
last_4 STRING
masked_number STRING
payroll STRING
prepaid STRING
product_id STRING
token STRING
unique_number_identifier STRING
updated_at TIMESTAMP
source_description STRING
username STRING
venmo_user_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: customer_stream__visa_checkout_cards

Section titled “Subtable: customer_stream__visa_checkout_cards”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
billing_address JSON
bin STRING
card_type STRING
cardholder_name STRING
commercial STRING
country_of_issuance STRING
created_at TIMESTAMP
customer_id STRING
customer_location STRING
debit STRING
default BOOL
durbin_regulated STRING
expiration_date STRING
expiration_month STRING
expiration_year STRING
expired BOOL
healthcare STRING
image_url STRING
issuing_bank STRING
last_4 STRING
masked_number STRING
payroll STRING
prepaid STRING
product_id STRING
token STRING
unique_number_identifier STRING
updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
discount_stream (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount FLOAT64
current_billing_cycle FLOAT64
description STRING
id STRING
kind STRING
name STRING
never_expires BOOL
number_of_billing_cycles FLOAT64
quantity FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
dispute_stream (23 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount_disputed FLOAT64
amount_won FLOAT64
case_number STRING
chargeback_protection_level STRING
created_at TIMESTAMP
currency_iso_code STRING
evidence JSON
graphql_id STRING
id STRING
kind STRING
merchant_account_id STRING
original_dispute_id STRING
processor_comments STRING
reason STRING
reason_code STRING
reason_description STRING
received_date DATE
reference_number STRING
reply_by_date DATE
status STRING
updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
message STRING
send_at TIMESTAMP
sender STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
merchant_account_stream (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
business_details JSON
currency_iso_code STRING
funding_details JSON
id STRING
individual_details JSON
status STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
plan_stream (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
billing_day_of_month FLOAT64
billing_frequency FLOAT64
created_at TIMESTAMP
currency_iso_code STRING
description STRING
id STRING
name STRING
number_of_billing_cycles FLOAT64
price FLOAT64
trial_duration FLOAT64
trial_duration_unit STRING
trial_period BOOL
updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount FLOAT64
current_billing_cycle FLOAT64
description STRING
id STRING
kind STRING
name STRING
never_expires BOOL
number_of_billing_cycles FLOAT64
quantity FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount FLOAT64
current_billing_cycle FLOAT64
description STRING
id STRING
kind STRING
name STRING
never_expires BOOL
number_of_billing_cycles FLOAT64
quantity FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
subscription_stream (28 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
balance FLOAT64
billing_day_of_month FLOAT64
billing_period_end_date DATE
billing_period_start_date DATE
created_at TIMESTAMP
current_billing_cycle FLOAT64
days_past_due FLOAT64
description STRING
failure_count FLOAT64
first_billing_date DATE
id STRING
merchant_account_id STRING
never_expires BOOL
next_bill_amount FLOAT64
next_billing_date DATE
next_billing_period_amount FLOAT64
number_of_billing_cycles FLOAT64
paid_through_date DATE
payment_method_token STRING
plan_id STRING
price FLOAT64
status STRING
trial_duration FLOAT64
trial_duration_unit STRING
trial_period BOOL
updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount FLOAT64
current_billing_cycle FLOAT64
description STRING
id STRING
kind STRING
name STRING
never_expires BOOL
number_of_billing_cycles FLOAT64
quantity FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount FLOAT64
current_billing_cycle FLOAT64
description STRING
id STRING
kind STRING
name STRING
never_expires BOOL
number_of_billing_cycles FLOAT64
quantity FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: subscription_stream__transactions

Section titled “Subtable: subscription_stream__transactions”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
acquirer_reference_number STRING
additional_processor_response STRING
amount STRING
android_pay_card_details JSON
apple_pay_details JSON
authorization_expires_at TIMESTAMP
avs_error_response_code STRING
avs_postal_code_response_code STRING
avs_street_address_response_code STRING
billing_details JSON
channel STRING
created_at TIMESTAMP
credit_card_details JSON
currency_iso_code STRING
custom_fields STRING
customer_details JSON
cvv_response_code STRING
disbursement_details JSON
discount_amount FLOAT64
escrow_status STRING
gateway_rejection_reason STRING
global_id STRING
graphql_id STRING
id STRING
installment_count FLOAT64
masterpass_card_details JSON
merchant_account_id STRING
merchant_address JSON
merchant_identification_number STRING
merchant_name STRING
network_response_code STRING
network_response_text STRING
network_transaction_id STRING
order_id STRING
payment_instrument_type STRING
pin_verified BOOL
plan_id STRING
processed_with_network_token BOOL
processor_authorization_code STRING
processor_response_code STRING
processor_response_text STRING
processor_response_type STRING
processor_settlement_response_code STRING
processor_settlement_response_text STRING
purchase_order_number STRING
paypal_details JSON
recurring BOOL
refunded_transaction_id STRING
response_emv_data STRING
retrieval_reference_number STRING
samsung_pay_card_details JSON
sca_exemption_requested STRING
service_fee_amount FLOAT64
settlement_batch_id STRING
shipping_amount FLOAT64
shipping_details JSON
ships_from_postal_code STRING
status STRING
subscription_details JSON
subscription_id STRING
tax_amount FLOAT64
tax_exempt BOOL
terminal_identification_number STRING
type STRING
updated_at TIMESTAMP
venmo_account_details JSON
visa_checkout_card_details JSON
voice_referral_number STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: subscription_stream__transactions__discounts

Section titled “Subtable: subscription_stream__transactions__discounts”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount FLOAT64
current_billing_cycle FLOAT64
description STRING
id STRING
kind STRING
name STRING
never_expires BOOL
number_of_billing_cycles FLOAT64
quantity FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: subscription_stream__transactions__disputes

Section titled “Subtable: subscription_stream__transactions__disputes”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount_disputed FLOAT64
amount_won FLOAT64
case_number STRING
chargeback_protection_level STRING
created_at TIMESTAMP
currency_iso_code STRING
evidence JSON
graphql_id STRING
id STRING
kind STRING
merchant_account_id STRING
original_dispute_id STRING
processor_comments STRING
reason STRING
reason_code STRING
reason_description STRING
received_date DATE
reference_number STRING
reply_by_date DATE
status STRING
updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: subscription_stream__transactions__disputes__paypal_messages

Section titled “Subtable: subscription_stream__transactions__disputes__paypal_messages”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
message STRING
send_at TIMESTAMP
sender STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: subscription_stream__transactions__refund_ids

Section titled “Subtable: subscription_stream__transactions__refund_ids”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: subscription_stream__transactions__refund_global_ids

Section titled “Subtable: subscription_stream__transactions__refund_global_ids”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: subscription_stream__transactions__status_history

Section titled “Subtable: subscription_stream__transactions__status_history”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount FLOAT64
status STRING
timestamp TIMESTAMP
transaction_source STRING
user STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
transaction_stream (69 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
acquirer_reference_number STRING
additional_processor_response STRING
amount STRING
android_pay_card_details JSON
apple_pay_details JSON
authorization_expires_at TIMESTAMP
avs_error_response_code STRING
avs_postal_code_response_code STRING
avs_street_address_response_code STRING
billing_details JSON
channel STRING
created_at TIMESTAMP
credit_card_details JSON
currency_iso_code STRING
customer_details JSON
cvv_response_code STRING
disbursement_details JSON
discount_amount FLOAT64
escrow_status STRING
gateway_rejection_reason STRING
global_id STRING
graphql_id STRING
id STRING
installment_count FLOAT64
masterpass_card_details JSON
merchant_account_id STRING
merchant_address JSON
merchant_identification_number STRING
merchant_name STRING
network_response_code STRING
network_response_text STRING
network_transaction_id STRING
order_id STRING
payment_instrument_type STRING
pin_verified BOOL
plan_id STRING
processed_with_network_token BOOL
processor_authorization_code STRING
processor_response_code STRING
processor_response_text STRING
processor_response_type STRING
processor_settlement_response_code STRING
processor_settlement_response_text STRING
purchase_order_number STRING
paypal_details JSON
recurring BOOL
refunded_transaction_id STRING
response_emv_data STRING
retrieval_reference_number STRING
samsung_pay_card_details JSON
sca_exemption_requested STRING
service_fee_amount FLOAT64
settlement_batch_id STRING
shipping_amount FLOAT64
shipping_details JSON
ships_from_postal_code STRING
status STRING
subscription_details JSON
subscription_id STRING
tax_amount FLOAT64
tax_exempt BOOL
terminal_identification_number STRING
type STRING
updated_at TIMESTAMP
venmo_account_details JSON
visa_checkout_card_details JSON
voice_referral_number STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount FLOAT64
current_billing_cycle FLOAT64
description STRING
id STRING
kind STRING
name STRING
never_expires BOOL
number_of_billing_cycles FLOAT64
quantity FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount_disputed FLOAT64
amount_won FLOAT64
case_number STRING
chargeback_protection_level STRING
created_at TIMESTAMP
currency_iso_code STRING
evidence JSON
graphql_id STRING
id STRING
kind STRING
merchant_account_id STRING
original_dispute_id STRING
processor_comments STRING
reason STRING
reason_code STRING
reason_description STRING
received_date DATE
reference_number STRING
reply_by_date DATE
status STRING
updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: transaction_stream__disputes__paypal_messages

Section titled “Subtable: transaction_stream__disputes__paypal_messages”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
message STRING
send_at TIMESTAMP
sender STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: transaction_stream__refund_global_ids

Section titled “Subtable: transaction_stream__refund_global_ids”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: transaction_stream__status_history

Section titled “Subtable: transaction_stream__status_history”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount FLOAT64
status STRING
timestamp TIMESTAMP
transaction_source STRING
user STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

How the PayPal Enterprise Payments sync works

Section titled “How the PayPal Enterprise Payments sync works”

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where PayPal Enterprise Payments supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for PayPal Enterprise Payments?

Section titled “How long does the initial sync take for PayPal Enterprise Payments?”

It depends on how much history is in your PayPal Enterprise Payments account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when PayPal Enterprise Payments’s schema changes?

Section titled “What happens when PayPal Enterprise Payments’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in PayPal Enterprise Payments, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in PayPal Enterprise Payments instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the PayPal Enterprise Payments connector in Kaivo and all of its synced data is deleted with it.

Common use cases for PayPal Enterprise Payments data

Section titled “Common use cases for PayPal Enterprise Payments data”

Track transactions over time to monitor revenue, refunds, and net settlement.

Analyse disputes and chargebacks to spot fraud and the revenue at risk.

Measure authorisation and decline rates so you can recover failed payments.

Report on recurring billing to follow active subscriptions and churn.

Use PayPal Enterprise Payments data in your AI and BI tools

Section titled “Use PayPal Enterprise Payments data in your AI and BI tools”

Once PayPal Enterprise Payments data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with PayPal Enterprise Payments data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for PayPal Enterprise Payments connector pricing and plan details.