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.

Written By Lauri Raivio

Last updated 16 days ago

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

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

Category	Finance & Payments
Authentication	API key
Setup	Self-service

Getting started with the PayPal Transaction Search API connector

Sign up for Kaivo and create a workspace.
Connect your PayPal Transaction Search API account.
Choose which tables to sync.
Wait for the initial sync to finish.
Query your data in BigQuery or your favourite AI or BI tool.

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

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

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.

Subtable: balances__balances

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

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.

Subtable: list_disputes__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.
`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.

Subtable: list_payments__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.

Subtable: list_payments__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.
`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_paymentstransactionsitem_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.

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.

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.

Subtable: list_products__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 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

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_invoicesdetailattachments

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.

Subtable: search_invoices__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`	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

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_infoaddressphones

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.

Subtable: show_product_details__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 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

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

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

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

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.

Frequently asked questions

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.

Can I sync only some tables or columns?

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?

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.

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

Revenue reporting

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

Balance tracking

Bring balances into BigQuery to monitor funds across currencies.

Dispute analysis

Use list_disputes to track dispute volume and resolution.

Reconciliation

Join transactions with your accounting data to reconcile payments.

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.

Claude

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

Power BI

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

Data Studio

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

Tableau

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

Google Sheets

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

Excel

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

Metabase

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

See our pricing page for PayPal Transaction Search API connector pricing and plan details.

Chargebee: Sync Chargebee to BigQuery.
ChartMogul: Sync ChartMogul to BigQuery.
Fennoa: Sync Fennoa to BigQuery.
Fortnox: Sync Fortnox to BigQuery.
FreshBooks: Sync FreshBooks to BigQuery.
PayPal Enterprise Payments: Sync PayPal Enterprise Payments to BigQuery.

Was this helpful?

Still need help? Share an idea