PayPal
PayPal is a leading online payment platform that provides businesses and consumers with secure, convenient, and fast payment solutions.
Features
| Feature name | Supported | |
|---|---|---|
| Column Hashing | True | Field level |
| Blocking | False | |
| Incremental | True | Table level |
| Custom data | False | |
| History | True | Table level |
| ReSync | True | Table level |
| Templates | False |
Data Schema
Loading diagram…
billing_plan
T
billing_plan
id
string-create_time
date-description
string-merchant_preferences_cancel_url
string-merchant_preferences_return_url
string-name
string-payment_preferences_auto_bill_outstanding
boolean-payment_preferences_payment_failure_threshold
int-payment_preferences_setup_fee_currency_code
string-payment_preferences_setup_fee_value
string-payment_preferences_setup_fee_failure_action
string-product_id
string-quantity_supported
boolean-status
string-taxes_inclusive
boolean-taxes_percentage
string-update_time
date-_weld_synced
dateS
billing_plan_billing_cycle
billing_plan_id
string-index
int-create_time
date-frequency_interval_count
int-frequency_interval_unit
string-pricing_scheme_fixed_price_currency_code
string-pricing_scheme_fixed_price_value
string-pricing_scheme_pricing_model
string-pricing_scheme_version
int-sequence
int-tenure_type
string-total_cycles
int-update_time
date-_weld_synced
dateS
billing_plan_pricing_tier
billing_plan_id
string-billing_cycle_index
int-index
int-amount_currency_code
string-amount_value
string-ending_quantity
string-starting_quantity
string-_weld_synced
datedispute
T
dispute
dispute_id
string-allowed_response_options_accept_claim_accept_claim_types
string-allowed_response_options_acknowledge_return_item_acknowledgement_types
string-allowed_response_options_make_offer_offer_types
string-buyer_response_due_date
date-communication_details_email
string-communication_details_note
string-communication_details_time_posted
date-create_time
date-dispute_amount_currency_code
string-dispute_amount_value
string-dispute_asset_asset_symbol
string-dispute_asset_quantity
string-dispute_asset_quantity_in_subunits
string-dispute_asset_decimals
int-dispute_channel
string-dispute_life_cycle_stage
string-dispute_outcome_amount_refunded_currency_code
string-dispute_outcome_amount_refunded_value
string-dispute_outcome_asset_refunded_asset_symbol
string-dispute_outcome_asset_refunded_quantity
string-dispute_outcome_asset_refunded_quantity_in_subunits
string-dispute_outcome_asset_refunded_decimals
int-dispute_outcome_outcome_code
string-dispute_outcome_outcome_reason
string-dispute_state
string-extensions_buyer_contacted_time
date-extensions_merchant_buyer_contacted_channel
string-extensions_merchant_contacted
boolean-extensions_merchant_contacted_mode
string-extensions_merchant_contacted_outcome
string-extensions_merchant_contacted_time
date-extensions_reported_source
string-external_reason_code
string-fee_policy
string-offer_buyer_requested_amount_currency_code
string-offer_buyer_requested_amount_value
string-offer_offer_type
string-offer_seller_offered_amount_currency_code
string-offer_seller_offered_amount_value
string-reason
string-refund_details_allowed_refund_amount_currency_code
string-refund_details_allowed_refund_amount_value
string-seller_response_due_date
date-status
string-update_time
date-_weld_synced
dateS
dispute_disputed_transaction
dispute_id
string-index
int-buyer_name
string-buyer_transaction_id
string-create_time
date-custom
string-gross_amount_currency_code
string-gross_amount_value
string-gross_asset_asset_symbol
string-gross_asset_quantity
string-gross_asset_quantity_in_subunits
string-gross_asset_decimals
int-invoice_number
string-reference_id
string-seller_email
string-seller_merchant_id
string-seller_name
string-seller_transaction_id
string-transaction_status
string-_weld_synced
dateS
dispute_disputed_transaction_item
dispute_id
string-disputed_transaction_index
int-index
int-dispute_amount_currency_code
string-dispute_amount_value
string-item_description
string-item_id
string-item_name
string-item_quantity
string-item_type
string-notes
string-partner_transaction_id
string-reason
string-_weld_synced
dateS
dispute_adjudication
dispute_id
string-index
int-adjudication_time
date-dispute_life_cycle_stage
string-reason
string-type
string-_weld_synced
dateS
dispute_fund_movement
dispute_id
string-index
int-amount_currency_code
string-amount_value
string-asset_asset_symbol
string-asset_quantity
string-asset_quantity_in_subunits
string-asset_decimals
int-initiated_time
date-party
string-reason
string-type
string-_weld_synced
dateS
dispute_message
dispute_id
string-index
int-content
string-documents
string-posted_by
string-time_posted
date-_weld_synced
dateS
dispute_evidence
dispute_id
string-index
int-action_info_action
string-action_info_mandatory
boolean-action_info_response_option
string-date
date-dispute_life_cycle_stage
string-documents
string-evidence_info_refund_ids
string-evidence_info_tracking_info
string-evidence_type
string-item_id
string-item_type
string-notes
string-source
string-_weld_synced
dateS
dispute_supporting_info
dispute_id
string-index
int-dispute_life_cycle_stage
string-documents
string-notes
string-provided_time
date-source
string-_weld_synced
dateS
dispute_offer_history
dispute_id
string-index
int-actor
string-dispute_life_cycle_stage
string-event_type
string-notes
string-offer_amount_currency_code
string-offer_amount_value
string-offer_time
date-offer_type
string-_weld_synced
dateS
dispute_refund_transaction
id
stringdispute_id
string-index
int-create_time
date-gross_amount_currency_code
string-gross_amount_value
string-_weld_synced
datedispute_history
T
dispute_history
dispute_id
string-allowed_response_options_accept_claim_accept_claim_types
string-allowed_response_options_acknowledge_return_item_acknowledgement_types
string-allowed_response_options_make_offer_offer_types
string-buyer_response_due_date
date-communication_details_email
string-communication_details_note
string-communication_details_time_posted
date-create_time
date-dispute_amount_currency_code
string-dispute_amount_value
string-dispute_asset_asset_symbol
string-dispute_asset_quantity
string-dispute_asset_quantity_in_subunits
string-dispute_asset_decimals
int-dispute_channel
string-dispute_life_cycle_stage
string-dispute_outcome_amount_refunded_currency_code
string-dispute_outcome_amount_refunded_value
string-dispute_outcome_asset_refunded_asset_symbol
string-dispute_outcome_asset_refunded_quantity
string-dispute_outcome_asset_refunded_quantity_in_subunits
string-dispute_outcome_asset_refunded_decimals
int-dispute_outcome_outcome_code
string-dispute_outcome_outcome_reason
string-dispute_state
string-extensions_buyer_contacted_time
date-extensions_merchant_buyer_contacted_channel
string-extensions_merchant_contacted
boolean-extensions_merchant_contacted_mode
string-extensions_merchant_contacted_outcome
string-extensions_merchant_contacted_time
date-extensions_reported_source
string-external_reason_code
string-fee_policy
string-offer_buyer_requested_amount_currency_code
string-offer_buyer_requested_amount_value
string-offer_offer_type
string-offer_seller_offered_amount_currency_code
string-offer_seller_offered_amount_value
string-reason
string-refund_details_allowed_refund_amount_currency_code
string-refund_details_allowed_refund_amount_value
string-seller_response_due_date
date-status
string-update_time
date-_weld_synced
dateinvoice
T
invoice
id
string-additional_recipients
string-amount_currency_code
string-amount_value
string-amount_breakdown_custom_amount_currency_code
string-amount_breakdown_custom_amount_value
string-amount_breakdown_custom_label
string-amount_breakdown_discount_invoice_discount_amount_currency_code
string-amount_breakdown_discount_invoice_discount_amount_value
string-amount_breakdown_discount_invoice_discount_percent
string-amount_breakdown_discount_item_discount_currency_code
string-amount_breakdown_discount_item_discount_value
string-amount_breakdown_item_total_currency_code
string-amount_breakdown_item_total_value
string-amount_breakdown_shipping_amount_currency_code
string-amount_breakdown_shipping_amount_value
string-amount_breakdown_shipping_tax_amount_currency_code
string-amount_breakdown_shipping_tax_amount_value
string-amount_breakdown_shipping_tax_name
string-amount_breakdown_shipping_tax_note
string-amount_breakdown_shipping_tax_percent
string-amount_breakdown_tax_total_currency_code
string-amount_breakdown_tax_total_value
string-configuration_allow_tip
boolean-configuration_partial_payment_allow_partial_payment
boolean-configuration_partial_payment_minimum_amount_due_currency_code
string-configuration_partial_payment_minimum_amount_due_value
string-configuration_tax_calculated_after_discount
boolean-configuration_tax_inclusive
boolean-configuration_template_id
string-detail_currency_code
string-detail_invoice_date
string-detail_invoice_number
string-detail_memo
string-detail_metadata_cancel_time
date-detail_metadata_cancelled_by
string-detail_metadata_create_time
date-detail_metadata_created_by
string-detail_metadata_created_by_flow
string-detail_metadata_first_sent_time
date-detail_metadata_invoicer_view_url
string-detail_metadata_last_sent_by
string-detail_metadata_last_sent_time
date-detail_metadata_last_update_time
date-detail_metadata_last_updated_by
string-detail_metadata_recipient_view_url
string-detail_note
string-detail_payment_term_due_date
date-detail_payment_term_term_type
string-detail_reference
string-detail_terms_and_conditions
string-due_amount_currency_code
string-due_amount_value
string-gratuity_currency_code
string-gratuity_value
string-invoicer_additional_notes
string-invoicer_address_address_line_1
string-invoicer_address_address_line_2
string-invoicer_address_address_line_3
string-invoicer_address_admin_area_1
string-invoicer_address_admin_area_2
string-invoicer_address_admin_area_3
string-invoicer_address_admin_area_4
string-invoicer_address_country_code
string-invoicer_address_postal_code
string-invoicer_business_name
string-invoicer_email_address
string-invoicer_logo_url
string-invoicer_name_alternate_full_name
string-invoicer_name_full_name
string-invoicer_name_given_name
string-invoicer_name_middle_name
string-invoicer_name_prefix
string-invoicer_name_suffix
string-invoicer_name_surname
string-invoicer_tax_id
string-invoicer_website
string-parent_id
string-payments_paid_amount_currency_code
string-payments_paid_amount_value
string-refunds_refund_amount_currency_code
string-refunds_refund_amount_value
string-status
string-_weld_synced
dateS
invoice_attachment
id
stringinvoice_id
string-content_type
string-create_time
date-reference_url
string-size
string-_weld_synced
dateS
invoice_item
id
stringinvoice_id
string-description
string-discount_amount_currency_code
string-discount_amount_value
string-discount_percent
string-item_date
string-name
string-quantity
string-tax_amount_currency_code
string-tax_amount_value
string-tax_name
string-tax_note
string-tax_percent
string-unit_amount_currency_code
string-unit_amount_value
string-unit_of_measure
string-_weld_synced
dateS
invoice_payment_transaction
invoice_id
string-payment_id
string-_weld_synced
dateS
invoice_recipient
invoice_id
string-index
int-billing_info_additional_info
string-billing_info_address_address_line_1
string-billing_info_address_address_line_2
string-billing_info_address_address_line_3
string-billing_info_address_admin_area_1
string-billing_info_address_admin_area_2
string-billing_info_address_admin_area_3
string-billing_info_address_admin_area_4
string-billing_info_address_country_code
string-billing_info_address_postal_code
string-billing_info_business_name
string-billing_info_email_address
string-billing_info_language
string-billing_info_name_alternate_full_name
string-billing_info_name_full_name
string-billing_info_name_given_name
string-billing_info_name_middle_name
string-billing_info_name_prefix
string-billing_info_name_suffix
string-billing_info_name_surname
string-billing_info_phones
string-shipping_info_address_address_line_1
string-shipping_info_address_address_line_2
string-shipping_info_address_address_line_3
string-shipping_info_address_admin_area_1
string-shipping_info_address_admin_area_2
string-shipping_info_address_admin_area_3
string-shipping_info_address_admin_area_4
string-shipping_info_address_country_code
string-shipping_info_address_postal_code
string-shipping_info_business_name
string-shipping_info_name_alternate_full_name
string-shipping_info_name_full_name
string-shipping_info_name_given_name
string-shipping_info_name_middle_name
string-shipping_info_name_prefix
string-shipping_info_name_suffix
string-shipping_info_name_surname
string-_weld_synced
dateS
invoice_refund_transaction
invoice_id
string-refund_id
string-_weld_synced
dateS
invoice_invoicer_phone
invoice_id
string-index
int-country_code
string-extension_number
string-national_number
string-phone_type
string-_weld_synced
datesubscription
T
subscription
id
string-billing_info_current_cycle_sequence
int-billing_info_failed_payments_count
int-billing_info_final_payment_time
date-billing_info_last_failed_payment_amount_currency_code
string-billing_info_last_failed_payment_amount_value
string-billing_info_last_failed_payment_next_payment_retry_time
date-billing_info_last_failed_payment_reason_code
string-billing_info_last_failed_payment_time
date-billing_info_last_payment_amount_currency_code
string-billing_info_last_payment_amount_value
string-billing_info_last_payment_status
string-billing_info_last_payment_time
date-billing_info_next_billing_time
date-billing_info_outstanding_balance_currency_code
string-billing_info_outstanding_balance_value
string-create_time
date-custom_id
string-plan_id
string-plan_overridden
boolean-quantity
string-shipping_amount_currency_code
string-shipping_amount_value
string-start_time
date-status
string-status_change_note
string-status_update_time
date-subscriber_email_address
string-subscriber_name_given_name
string-subscriber_name_surname
string-subscriber_payer_id
string-subscriber_shipping_address_address_address_line_1
string-subscriber_shipping_address_address_address_line_2
string-subscriber_shipping_address_address_admin_area_1
string-subscriber_shipping_address_address_admin_area_2
string-subscriber_shipping_address_address_postal_code
string-subscriber_shipping_address_address_country_code
string-subscriber_shipping_address_email_address
string-subscriber_shipping_address_name_full_name
string-subscriber_shipping_address_phone_number_country_code
string-subscriber_shipping_address_phone_number_national_number
string-subscriber_shipping_address_type
string-subscriber_tenant
string-update_time
date-_weld_synced
dateS
subscription_cycle_execution
subscription_id
string-index
int-current_pricing_scheme_version
int-cycles_completed
int-cycles_remaining
int-sequence
int-tenure_type
string-total_cycles
int-_weld_synced
datesubscription_history
T
subscription_history
id
string-billing_info_current_cycle_sequence
int-billing_info_failed_payments_count
int-billing_info_final_payment_time
date-billing_info_last_failed_payment_amount_currency_code
string-billing_info_last_failed_payment_amount_value
string-billing_info_last_failed_payment_next_payment_retry_time
date-billing_info_last_failed_payment_reason_code
string-billing_info_last_failed_payment_time
date-billing_info_last_payment_amount_currency_code
string-billing_info_last_payment_amount_value
string-billing_info_last_payment_status
string-billing_info_last_payment_time
date-billing_info_next_billing_time
date-billing_info_outstanding_balance_currency_code
string-billing_info_outstanding_balance_value
string-create_time
date-custom_id
string-plan_id
string-plan_overridden
boolean-quantity
string-shipping_amount_currency_code
string-shipping_amount_value
string-start_time
date-status
string-status_change_note
string-status_update_time
date-subscriber_email_address
string-subscriber_name_given_name
string-subscriber_name_surname
string-subscriber_payer_id
string-subscriber_shipping_address_address_address_line_1
string-subscriber_shipping_address_address_address_line_2
string-subscriber_shipping_address_address_admin_area_1
string-subscriber_shipping_address_address_admin_area_2
string-subscriber_shipping_address_address_postal_code
string-subscriber_shipping_address_address_country_code
string-subscriber_shipping_address_email_address
string-subscriber_shipping_address_name_full_name
string-subscriber_shipping_address_phone_number_country_code
string-subscriber_shipping_address_phone_number_national_number
string-subscriber_shipping_address_type
string-subscriber_tenant
string-update_time
date-_weld_synced
datetransaction
T
transaction
id
string-event_code
string-account_number
string-auction_info_auction_buyer_id
string-auction_info_auction_closing_date
date-auction_info_auction_item_site
string-auction_info_auction_site
string-cart_info_paypal_invoice_id
string-cart_info_tax_inclusive
boolean-last_refreshed_datetime
date-payer_info_account_id
string-payer_info_address_city
string-payer_info_address_country_code
string-payer_info_address_line1
string-payer_info_address_line2
string-payer_info_address_postal_code
string-payer_info_address_state
string-payer_info_address_status
string-payer_info_country_code
string-payer_info_email_address
string-payer_info_payer_name_alternate_full_name
string-payer_info_payer_name_full_name
string-payer_info_payer_name_given_name
string-payer_info_payer_name_middle_name
string-payer_info_payer_name_prefix
string-payer_info_payer_name_suffix
string-payer_info_payer_name_surname
string-payer_info_payer_status
string-payer_info_phone_number_country_code
string-payer_info_phone_number_extension_number
string-payer_info_phone_number_national_number
string-shipping_info_address_city
string-shipping_info_address_country_code
string-shipping_info_address_line1
string-shipping_info_address_line2
string-shipping_info_address_postal_code
string-shipping_info_address_state
string-shipping_info_method
string-shipping_info_name
string-shipping_info_secondary_shipping_address_city
string-shipping_info_secondary_shipping_address_country_code
string-shipping_info_secondary_shipping_address_line1
string-shipping_info_secondary_shipping_address_line2
string-shipping_info_secondary_shipping_address_postal_code
string-shipping_info_secondary_shipping_address_state
string-store_info_store_id
string-store_info_terminal_id
string-transaction_info_annual_percentage_rate
string-transaction_info_available_balance_currency_code
string-transaction_info_available_balance_value
string-transaction_info_bank_reference_id
string-transaction_info_credit_promotional_fee_currency_code
string-transaction_info_credit_promotional_fee_value
string-transaction_info_credit_term
string-transaction_info_credit_transactional_fee_currency_code
string-transaction_info_credit_transactional_fee_value
string-transaction_info_custom_field
string-transaction_info_discount_amount_currency_code
string-transaction_info_discount_amount_value
string-transaction_info_ending_balance_currency_code
string-transaction_info_ending_balance_value
string-transaction_info_fee_amount_currency_code
string-transaction_info_fee_amount_value
string-transaction_info_instrument_sub_type
string-transaction_info_instrument_type
string-transaction_info_insurance_amount_currency_code
string-transaction_info_insurance_amount_value
string-transaction_info_invoice_id
string-transaction_info_other_amount_currency_code
string-transaction_info_other_amount_value
string-transaction_info_payment_method_type
string-transaction_info_payment_tracking_id
string-transaction_info_paypal_account_id
string-transaction_info_paypal_reference_id
string-transaction_info_paypal_reference_id_type
string-transaction_info_protection_eligibility
string-transaction_info_sales_tax_amount_currency_code
string-transaction_info_sales_tax_amount_value
string-transaction_info_shipping_amount_currency_code
string-transaction_info_shipping_amount_value
string-transaction_info_shipping_discount_amount_currency_code
string-transaction_info_shipping_discount_amount_value
string-transaction_info_shipping_tax_amount_currency_code
string-transaction_info_shipping_tax_amount_value
string-transaction_info_tip_amount_currency_code
string-transaction_info_tip_amount_value
string-transaction_info_transaction_amount_currency_code
string-transaction_info_transaction_amount_value
string-transaction_info_transaction_initiation_date
date-transaction_info_transaction_note
string-transaction_info_transaction_status
string-transaction_info_transaction_subject
string-transaction_info_transaction_updated_date
date-_weld_synced
dateS
transaction_item_detail
transaction_id
string-transaction_event_code
string-index
int-adjustment_amount_currency_code
string-adjustment_amount_value
string-basic_shipping_amount_currency_code
string-basic_shipping_amount_value
string-discount_amount_currency_code
string-discount_amount_value
string-extra_shipping_amount_currency_code
string-extra_shipping_amount_value
string-gift_wrap_amount_currency_code
string-gift_wrap_amount_value
string-handling_amount_currency_code
string-handling_amount_value
string-insurance_amount_currency_code
string-insurance_amount_value
string-invoice_number
string-item_amount_currency_code
string-item_amount_value
string-item_code
string-item_description
string-item_name
string-item_options
string-item_quantity
string-item_unit_price_currency_code
string-item_unit_price_value
string-tax_percentage
string-total_item_amount_currency_code
string-total_item_amount_value
string-_weld_synced
dateS
transaction_item_tax_amount
transaction_id
string-transaction_event_code
string-transaction_item_detail_index
int-index
int-tax_amount_currency_code
string-tax_amount_value
string-_weld_synced
dateS
transaction_item_checkout_option
transaction_id
string-transaction_event_code
string-transaction_item_detail_index
int-index
int-checkout_option_name
string-checkout_option_value
string-_weld_synced
dateS
transaction_incentive
transaction_id
string-index
int-transaction_event_code
string-incentive_amount_currency_code
string-incentive_amount_value
string-incentive_code
string-incentive_program_code
string-incentive_type
string-_weld_synced
dateT
balance
-account_id
string-currency
string-as_of_time
date-available_balance_currency_code
string-available_balance_value
string-last_refresh_time
date-primary
boolean-total_balance_currency_code
string-total_balance_value
string-withheld_balance_currency_code
string-withheld_balance_value
string-_weld_synced
dateT
balance_history
-account_id
string-currency
string-as_of_time
date-available_balance_currency_code
string-available_balance_value
string-last_refresh_time
date-primary
boolean-total_balance_currency_code
string-total_balance_value
string-withheld_balance_currency_code
string-withheld_balance_value
string-_weld_synced
dateT
TableS
Sub tablePress enter or space to select a node. You can then use the arrow keys to move the node around. Press delete to remove it and escape to cancel.
Press enter or space to select an edge. You can then press delete to remove it or escape to cancel.
Open full-page schema explorer
Setup Guide
Step 1 - Get Client ID and Secret
- Log in to your PayPal Developer dashboard.
- Navigate to “My Apps & Credentials” in the dashboard.
- Choose the appropriate environment (Sandbox for testing or Production/Live for real payments).
- Create the App.
- Make sure that the type is "Merchant" and create.
- Pick any number of the following settings: Customer disputes, Transaction search, Subscriptions, Invoicing.
- Find and copy your Client ID and Secret.
Step 2 - Connection Settings
- Paste the Client ID and Secret into the appropriate fields, and choose the right environment.
- Choose if you want to include history tables and if so how far back you want to sync data from.
- In the next step, you can select which historical tables you want to sync.
Step 3 - Data to sync
- Select which data tables you want to sync from PayPal.
- You can view the schema, remove columns or hash sensitive information.
- Choose history tables if needed.
- Set up available tables for incremental or full sync.
- Press Next to continue.
Step 4 - Configure sync
- Select how often you would like the data to sync.
- You can limit the data to sync by selecting a specific start date in the “Will sync now and update data:” section via the three-dot menu. If left blank, the connector will sync all available data.
Weld will take over from here and commence syncing data from your PayPal account.