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.ioKaivo 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.
| Category | Finance & Payments |
|---|---|
| Authentication | API key |
| Setup | Self-service |
Getting started with the PayPal Transaction Search API connector
Section titled “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
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. |
Subtable: balances__balances
Section titled “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
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. |
Subtable: list_disputes__links
Section titled “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
Section titled “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
Section titled “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_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. |
Subtable: list_payments__transactions__related_resources
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. |
Subtable: list_payments__transactions__related_resources__sale__links
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. |
Subtable: list_products__links
Section titled “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
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. |
Subtable: search_invoices__links
Section titled “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
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. |
Subtable: show_product_details__links
Section titled “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
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.
Frequently asked questions
Section titled “Frequently asked questions”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.
Can I sync only some tables or columns?
Section titled “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?
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”Revenue reporting
Section titled “Revenue reporting”Use transactions to track payment volume, fees, and net revenue over time.
Balance tracking
Section titled “Balance tracking”Bring balances into BigQuery to monitor funds across currencies.
Dispute analysis
Section titled “Dispute analysis”Use list_disputes to track dispute volume and resolution.
Reconciliation
Section titled “Reconciliation”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.
Claude
Section titled “Claude”Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →
Power BI
Section titled “Power BI”Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →
Data Studio
Section titled “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
Section titled “Tableau”The premium analytics standard, with native BigQuery integration. Setup guide →
Google Sheets
Section titled “Google Sheets”Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →
Connect via Power Query’s BigQuery connector. Setup guide →
Metabase
Section titled “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.
Related connectors
Section titled “Related connectors”- 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.