Skip to content
Book a demoStart free
Connectors

PayPal Transaction Search API connector

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

PayPal Transaction Search API connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your PayPal Transaction Search API 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 Transaction Search API connector

Section titled “What is the PayPal Transaction Search API connector”

Sync your PayPal transaction data into BigQuery with Kaivo to analyse payments, balances, and disputes alongside the rest of your finance data.

CategoryFinance & Payments
AuthenticationAPI key
SetupSelf-service

Getting started with the PayPal Transaction Search API connector

Section titled “Getting started with the PayPal Transaction Search API connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your PayPal Transaction Search API 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.

Authenticating PayPal Transaction Search API

Section titled “Authenticating PayPal Transaction Search API”

Authenticate with your PayPal Transaction Search API credentials. You provide:

Field Description
Client ID
The Client ID of your PayPal developer application.

| | Client Secret |

The Client Secret of your PayPal developer application.

|

Configuring the PayPal Transaction Search API connector

Section titled “Configuring the PayPal Transaction Search API connector”

When you set up the connector, you provide:

Field Description
Start Date
Any data before this date will not be fetched.

| | Dispute Start Date |

Any data before this date will not be fetched.

|

Tables and columns synced from PayPal Transaction Search API

Section titled “Tables and columns synced from PayPal Transaction Search API”

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

balances (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_id STRING The unique identifier of the account associated with the balances data.
as_of_time STRING The timestamp when the balances data was reported.
last_refresh_time STRING The timestamp when the balances data was last refreshed or updated.
_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.
available_balance__currency_code STRING The currency code for the available balance.
available_balance__value STRING The numerical value of the available balance.
currency STRING The currency used for the account balances.
primary BOOL Indicates if the balance is the primary account balance.
total_balance__currency_code STRING The currency code for the total balance.
total_balance__value STRING The numerical value of the total balance.
withheld_balance__currency_code STRING The currency code for the withheld balance.
withheld_balance__value STRING The numerical value of the withheld balance.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
list_disputes (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
create_time TIMESTAMP The timestamp when the dispute was created.
dispute_amount__currency_code STRING The currency code of the disputed amount.
dispute_amount__value STRING The value of the disputed amount.
dispute_channel STRING The channel through which the dispute was initiated.
dispute_id STRING The unique identifier for the dispute.
dispute_life_cycle_stage STRING The stage in the life cycle of the dispute.
dispute_state STRING The current state of the dispute.
outcome STRING The outcome of the dispute resolution.
reason STRING The reason for the dispute.
status STRING The current status of the dispute.
update_time TIMESTAMP The timestamp when the dispute was last updated.
updated_time_cut TIMESTAMP The cut-off timestamp for the last update.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: list_disputes__disputed_transactions

Section titled “Subtable: list_disputes__disputed_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.
buyer_transaction_id STRING The transaction ID of the buyer.
seller__merchant_id STRING The merchant ID of the seller.
_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.
href STRING The URL link.
method STRING The HTTP method for the link.
rel STRING The relation of the link to the resource.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
list_payments (22 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
cart STRING Details of the cart associated with the payment.
create_time TIMESTAMP The date and time when the payment was created.
id STRING Unique identifier for the payment.
intent STRING The intention or purpose behind the payment.
payer__payer_info__country_code STRING The country code of the payer.
payer__payer_info__email STRING The email address of the payer.
payer__payer_info__first_name STRING The first name of the payer.
payer__payer_info__last_name STRING The last name of the payer.
payer__payer_info__payer_id STRING The unique identifier for the payer.
payer__payer_info__phone STRING The phone number of the payer.
payer__payer_info__shipping_address__city STRING The city in the shipping address.
payer__payer_info__shipping_address__country_code STRING The country code in the shipping address.
payer__payer_info__shipping_address__line1 STRING The first line of the shipping address.
payer__payer_info__shipping_address__postal_code STRING The postal code in the shipping address.
payer__payer_info__shipping_address__recipient_name STRING The recipient’s name at the shipping address.
payer__payer_info__shipping_address__state STRING The state in the shipping address.
payer__payment_method STRING The payment method used by the payer.
payer__status STRING The status of the payment.
state STRING The state of the payment.
update_time TIMESTAMP The date and time when the payment was last updated.
_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.
href STRING The URL link related to the item.
method STRING The HTTP method used for the link.
rel STRING The relationship between the current resource and the linked resource.
_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.
description STRING Description of the transaction.
amount__currency STRING The currency used in the transaction.
amount__details__discount STRING Discount applied to the transaction.
amount__details__handling_fee STRING Handling fee charged for the transaction.
amount__details__insurance STRING Insurance fee for the transaction.
amount__details__shipping STRING Shipping cost for the transaction.
amount__details__shipping_discount STRING Discount applied to shipping cost.
amount__details__subtotal STRING Subtotal amount of the transaction.
amount__total STRING Total amount of the transaction.
item_list__shipping_address__city STRING City in the shipping address.
item_list__shipping_address__country_code STRING Country code in the shipping address.
item_list__shipping_address__line1 STRING First line of the shipping address.
item_list__shipping_address__postal_code STRING Postal code in the shipping address.
item_list__shipping_address__recipient_name STRING Recipient’s name in the shipping address.
item_list__shipping_address__state STRING State in the shipping address.
payee__email STRING Email address of the payee.
payee__merchant_id STRING Merchant ID of the payee.
reference_id STRING Reference ID associated with the transaction.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: list_payments__transactions__item_list__items

Section titled “Subtable: list_payments__transactions__item_list__items”
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.
description STRING Description of the item.
currency STRING The currency of the item.
image_url STRING URL of the image of the item.
name STRING Name of the item.
price STRING Price of the item.
quantity INT64 Quantity of the item.
tax STRING Tax applicable to the item.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Section titled “Subtable: list_payments__transactions__related_resources”
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.
sale__amount__currency STRING Currency used in the sale.
sale__amount__details__discount STRING Discount applied to the sale.
sale__amount__details__handling_fee STRING Handling fee for the sale.
sale__amount__details__insurance STRING Insurance fee for the sale.
sale__amount__details__shipping STRING Shipping cost for the sale.
sale__amount__details__shipping_discount STRING Discount applied to shipping cost in the sale.
sale__amount__details__subtotal STRING Subtotal amount of the sale.
sale__amount__total STRING Total amount of the sale.
sale__create_time TIMESTAMP The date and time when the sale was created.
sale__id STRING Unique identifier for the sale.
sale__parent_payment STRING Parent payment associated with the sale.
sale__payment_mode STRING The payment mode used for the sale.
sale__protection_eligibility STRING Indicates if the sale is eligible for protection.
sale__protection_eligibility_type STRING Type of protection eligibility for the sale.
sale__purchase_unit_reference_id STRING Reference ID for the purchase unit.
sale__state STRING The state of the sale.
sale__transaction_fee__currency STRING Currency of the transaction fee.
sale__transaction_fee__value STRING Value of the transaction fee.
sale__update_time TIMESTAMP The date and time when the sale was last updated.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Section titled “Subtable: list_payments__transactions__related_resources__sale__links”
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.
href STRING The URL link related to the item.
method STRING The HTTP method used for the link.
rel STRING The relationship between the current resource and the linked resource.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
list_products (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING Detailed information or features of the product
create_time TIMESTAMP The time when the product was created
id STRING Unique identifier for the product
name STRING The name or title of the product
_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.
href STRING The URL for the link
method STRING HTTP method used for the link (GET, POST, PUT, DELETE, etc.)
rel STRING Relationship of the linked resource to the product
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
search_invoices (47 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount__currency_code STRING Currency code of the invoice amount
amount__value STRING Total value of the invoice amount
configuration__allow_tip STRING Flag indicating whether tips are allowed for the invoice
configuration__partial_payment__allow_partial_payment STRING Flag indicating whether partial payments are allowed
configuration__tax_calculated_after_discount STRING Flag indicating whether taxes are calculated after applying discounts
configuration__tax_inclusive STRING Flag indicating whether taxes are included in the invoice total
configuration__template_id STRING Unique identifier of the template used for the invoice
detail__metadata__cancel_time TIMESTAMP Date and time when the invoice was cancelled
detail__metadata__cancelled_by STRING Details of the user who cancelled the invoice
detail__metadata__create_time TIMESTAMP Date and time when the invoice was created
detail__metadata__created_by STRING Details of the user who created the invoice
detail__metadata__created_by_flow STRING Flow information of the user who created the invoice
detail__metadata__first_sent_time TIMESTAMP Date and time when the invoice was first sent
detail__metadata__invoicer_view_url STRING URL for the invoicer to view the invoice
detail__metadata__last_seen_by STRING Details of the user who last viewed the invoice
detail__metadata__last_sent_time TIMESTAMP Date and time when the invoice was last sent
detail__metadata__last_update_time TIMESTAMP Date and time of the last update made to the invoice
detail__metadata__last_updated_by STRING Details of the user who last updated the invoice
detail__metadata__recipient_view_url STRING URL for the recipient to view the invoice
detail__currency_code STRING Currency code of the invoice
detail__invoice_date DATE Date on which the invoice was created
detail__invoice_number STRING Unique invoice number
detail__memo STRING Additional notes or memo related to the invoice
detail__note STRING Additional notes or messages related to the invoice
detail__payment_term__due_date DATE Due date for the invoice payment
detail__payment_term__term_type STRING Type of payment term (e.g., Net 30)
detail__reference STRING Reference information associated with the invoice
detail__terms_and_conditions STRING Terms and conditions specified for the invoice
due_amount__currency_code STRING Currency code of the due amount
due_amount__value STRING Value of the due amount
gratuity__currency_code STRING Currency code of the gratuity amount
gratuity__value STRING Value of the gratuity amount
id STRING Unique identifier of the invoice
invoicer__business_name STRING Business name of the invoicer
invoicer__name__alternate_full_name STRING Alternate full name of the invoicer
invoicer__name__full_name STRING Full name of the invoicer
invoicer__name__given_name STRING Given name of the invoicer
invoicer__name__middle_name STRING Middle name of the invoicer
invoicer__name__prefix STRING Prefix of the invoicer’s name
invoicer__name__suffix STRING Suffix of the invoicer’s name
invoicer__name__surname STRING Surname of the invoicer
last_update_time TIMESTAMP Date and time of the last update made to the invoice
payments JSON Payment transactions associated with the invoice
refunds JSON Refund transactions associated with the invoice
status STRING Current status of the invoice
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: search_invoices__additional_recipients

Section titled “Subtable: search_invoices__additional_recipients”
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: search_invoices__detail__attachments

Section titled “Subtable: search_invoices__detail__attachments”
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.
content_type STRING Type of content in the attachment
create_time STRING Creation time of the attachment
id STRING Unique identifier of the attachment
reference_url STRING URL reference to the attachment
size STRING Size of the attachment
_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.
href STRING URL reference for the link
method STRING HTTP method for accessing the link
rel STRING Relation type of the link
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: search_invoices__primary_recipients

Section titled “Subtable: search_invoices__primary_recipients”
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_info__address__additiona_info STRING Additional information related to the address
billing_info__address__address_line_1 STRING Address line 1 for billing
billing_info__address__address_line_2 STRING Address line 2 for billing
billing_info__address__address_line_3 STRING Address line 3 for billing
billing_info__address__address_line_4 STRING Address line 4 for billing
billing_info__address__admin_area_1 STRING Primary administrative area for billing
billing_info__address__admin_area_2 STRING Secondary administrative area for billing
billing_info__address__admin_area_3 STRING Tertiary administrative area for billing
billing_info__address__country_code STRING Country code for billing
billing_info__address__email_address STRING Email address for billing
billing_info__address__language STRING Language preference for billing
billing_info__address__postal_code STRING Postal code for billing
billing_info__business_name STRING Business name of the primary recipient
billing_info__name__alternate_full_name STRING Alternate full name of the primary recipient
billing_info__name__full_name STRING Full name of the primary recipient
billing_info__name__given_name STRING Given name of the primary recipient
billing_info__name__middle_name STRING Middle name of the primary recipient
billing_info__name__prefix STRING Prefix of the primary recipient’s name
billing_info__name__suffix STRING Suffix of the primary recipient’s name
billing_info__name__surname STRING Surname of the primary recipient
shipping_info__address__address_line_1 STRING Address line 1 for shipping
shipping_info__address__address_line_2 STRING Address line 2 for shipping
shipping_info__address__address_line_3 STRING Address line 3 for shipping
shipping_info__address__address_line_4 STRING Address line 4 for shipping
shipping_info__address__admin_area_1 STRING Primary administrative area for shipping
shipping_info__address__admin_area_2 STRING Secondary administrative area for shipping
shipping_info__address__admin_area_3 STRING Tertiary administrative area for shipping
shipping_info__address__country_code STRING Country code for shipping
shipping_info__address__postal_code STRING Postal code for shipping
shipping_info__business_name STRING Business name associated with the shipping
shipping_info__name__alternate_full_name STRING Alternate full name for shipping
shipping_info__name__full_name STRING Full name for shipping
shipping_info__name__given_name STRING Given name for shipping
shipping_info__name__middle_name STRING Middle name for shipping
shipping_info__name__prefix STRING Prefix for shipping name
shipping_info__name__suffix STRING Suffix for shipping name
shipping_info__name__surname STRING Surname for shipping
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: search_invoices__primary_recipients__billing_info__address__phones

Section titled “Subtable: search_invoices__primary_recipients__billing_info__address__phones”
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.
show_product_details (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING The type or category of the product
description STRING The detailed description of the product
category STRING The category to which the product belongs
create_time TIMESTAMP The date and time when the product was created
home_url STRING The URL for the home page of the product
id STRING The unique identifier for the product
image_url STRING The URL to the image representing the product
name STRING The name of the product
update_time TIMESTAMP The date and time when the product was last updated
_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.
href STRING The URL associated with the link
method STRING The HTTP method used for the link
rel STRING The relationship of the link to the product
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
transactions (48 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
auction_info__auction_buyer_id STRING ID of the buyer in the auction
auction_info__auction_closing_date TIMESTAMP Closing date and time of the auction
auction_info__auction_item_site STRING Site where the auction item is listed
auction_info__auction_site STRING Site where the auction is taking place
payer_info__account_id STRING ID of the payer’s account
payer_info__address_status STRING Status of the provided address
payer_info__country_code STRING Country code of the payer
payer_info__email_address STRING Email address of the payer
payer_info__payer_name__alternate_full_name STRING Alternate full name of the payer
payer_info__payer_name__given_name STRING Given name of the payer
payer_info__payer_name__surname STRING Surname of the payer
payer_info__payer_status STRING Status of the payer’s account
shipping_info__address__city STRING City for the shipping address
shipping_info__address__country_code STRING Country code of the shipping address
shipping_info__address__line1 STRING First line of the shipping address
shipping_info__address__line2 STRING Second line of the shipping address
shipping_info__address__postal_code STRING Postal code of the shipping address
shipping_info__name STRING Name associated with the shipping information
store_info__store_id STRING ID of the store
store_info__terminal_id STRING ID of the terminal
transaction_id STRING Unique ID of the transaction
transaction_info__custom_field STRING Custom field associated with the transaction
transaction_info__fee_amount__currency_code STRING Currency code of the fee amount
transaction_info__fee_amount__value STRING Value of the fee amount
transaction_info__insurance_amount__currency_code STRING Currency code of the insurance amount
transaction_info__insurance_amount__value STRING Value of the insurance amount
transaction_info__invoice_id STRING ID of the invoice related to the transaction
transaction_info__paypal_account_id STRING ID of the PayPal account used in the transaction
transaction_info__paypal_reference_id STRING Reference ID of the transaction in PayPal
transaction_info__paypal_reference_id_type STRING Type of reference ID in PayPal
transaction_info__protection_eligibility STRING Eligibility for protection in the transaction
transaction_info__shipping_amount__currency_code STRING Currency code of the shipping amount
transaction_info__shipping_amount__value STRING Value of the shipping amount
transaction_info__shipping_discount_amount__currency_code STRING Currency code of the discount amount
transaction_info__shipping_discount_amount__value STRING Value of the discount amount
transaction_info__transaction_amount__currency_code STRING Currency code of the transaction amount
transaction_info__transaction_amount__value STRING Value of the transaction amount
transaction_info__transaction_event_code STRING Event code associated with the transaction
transaction_info__transaction_id STRING ID of the transaction
transaction_info__transaction_initiation_date TIMESTAMP Date and time when the transaction was initiated
transaction_info__transaction_note STRING Note or comment related to the transaction
transaction_info__transaction_status STRING Status of the transaction
transaction_info__transaction_subject STRING Subject or purpose of the transaction
transaction_info__transaction_updated_date TIMESTAMP Date and time when the transaction was last updated
transaction_initiation_date TIMESTAMP Date and time when the transaction was initiated
transaction_updated_date TIMESTAMP Date and time when the transaction was last updated
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: transactions__cart_info__item_details

Section titled “Subtable: transactions__cart_info__item_details”
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.
invoice_number STRING Invoice number associated with the item
item_amount__currency_code STRING Currency code of the item amount
item_amount__value STRING Value of the item amount
item_code STRING Code representing the item
item_description STRING Description of the item
item_name STRING Name of the item
item_quantity STRING Quantity of the item
item_unit_price__currency_code STRING Currency code of the unit price
item_unit_price__value STRING Value of the unit price
total_item_amount__currency_code STRING Currency code of the total item amount
total_item_amount__value STRING Value of the total item amount
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: transactions__cart_info__item_details__tax_amounts

Section titled “Subtable: transactions__cart_info__item_details__tax_amounts”
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.
tax_amount__currency_code STRING Currency code of the tax amount
tax_amount__value STRING Value of the tax amount
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: transactions__incentive_info__incentive_details

Section titled “Subtable: transactions__incentive_info__incentive_details”
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.
incentive_amount__currency_code STRING Currency code of the incentive amount
incentive_amount__value STRING Value of the incentive amount
incentive_code STRING Code representing the incentive
incentive_program_code STRING Program code associated with the incentive
incentive_type STRING Type of the incentive
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

How the PayPal Transaction Search API sync works

Section titled “How the PayPal Transaction Search API sync works”

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where PayPal Transaction Search API 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 Transaction Search API?

Section titled “How long does the initial sync take for PayPal Transaction Search API?”

It depends on how much history is in your PayPal Transaction Search API 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 Transaction Search API’s schema changes?

Section titled “What happens when PayPal Transaction Search API’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 Transaction Search API, 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 Transaction Search API 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 Transaction Search API connector in Kaivo and all of its synced data is deleted with it.

Common use cases for PayPal Transaction Search API data

Section titled “Common use cases for PayPal Transaction Search API data”

Use transactions to track payment volume, fees, and net revenue over time.

Bring balances into BigQuery to monitor funds across currencies.

Use list_disputes to track dispute volume and resolution.

Join transactions with your accounting data to reconcile payments.

Use PayPal Transaction Search API data in your AI and BI tools

Section titled “Use PayPal Transaction Search API data in your AI and BI tools”

Once PayPal Transaction Search API 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 Transaction Search API 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 Transaction Search API connector pricing and plan details.