Explore with AI
ChatGPTClaudeGeminiPerplexity
All connectors/E-commerce & Payments
PayPal
§ Connector
PayPal

Connect PayPal to your Definite lakehouse in minutes.

Native sync with row-level security, CDC where supported, and hourly-or-faster freshness. Query it with SQL, build dashboards, or ask Fi.

Have multiple PayPal accounts? Analytics across multiple PayPal accounts →

§ What you get

Everything PayPal exposes, modeled and queryable.

Extracts PayPal Transaction Search data, including transaction amounts and fees, balances, payer and payee details, itemized cart lines, shipping info, and timestamps. Enables analysis of sales and refunds, fee impact, payouts and cash flow, and reconciliation across PayPal activity. Supports both live and sandbox environments.

Sync cadence
Hourly or faster
CDC
Native where supported
Auth
OAuth / API key
Row-level security
Yes

Tables & streams

6 objects
Transaction

Individual PayPal financial events (payments, refunds, transfers) with amounts, fees, status, and timestamps; supports revenue tracking, refund rate analysis, reconciliation, and cash flow reporting.

revenue_finance
Line Item

Itemized cart lines within transactions (SKUs, quantities, unit prices) enabling product-level performance, basket composition, and average order value analysis.

revenue_financeproduct
Fee

PayPal fee components associated with each transaction; used for net revenue calculation, fee impact assessment, and margin analysis.

revenue_finance
Customer (Payer)

Details about the payer sending funds (identity, email, location) enabling customer segmentation, repeat purchase behavior, and cohort analysis.

customerrevenue_finance
Merchant Account (Payee)

The receiving account or business entity for funds, used to attribute revenue and settlements across accounts, brands, or channels.

revenue_finance
Balance and Cash Flow

Running balances and inflow/outflow movements derived from transactions; enables daily cash position tracking, payout reconciliation, and liquidity analysis.

revenue_finance
Authentication

Uses your PayPal REST API client ID and secret to obtain an OAuth 2.0 access token (Client Credentials)

Requirements

Requires a PayPal account to connect.

Analyze with Fi

Operational data, performance metrics, and business insights.

Domainsrevenue_finance
§ How it works

Three steps. One afternoon.

01
Connect

Authenticate PayPal in a few clicks. OAuth, API key, or IAM role — we handle secrets and rotation.

definite connect paypal
02
Sync

We pull every stream into your lakehouse. CDC where the API supports it; full + incremental otherwise. Hourly-or-faster, row-level secure.

→ paypal.raw (synced hourly)
03
Query

SQL, dashboards, or ask Fi in plain English. Your PayPal data lives next to every other source — ready to join.

SELECT * FROM paypal.*
*
Don't see yours?
Any API becomes a Definite connector in minutes.

Build your own with the Definite SDK, or ask us — we add new connectors every week.

Request a connector
§ Combine with your stack

Pair PayPal with the rest of your data.

Cross-source joins, one governed semantic layer, AI answers across everything.

§ Related connectors

More e-commerce & payments sources.

Browse all 571 →

Your answer engine
is one afternoon away.

Book a 30-minute call. We'll build your first dashboard on the call — or you can stop paying us.