Airwallex
Let AI connect your sources for you
Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.
Connect Airwallex to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Sync your Airwallex payments, payouts, balances, and billing data into the PostHog Data warehouse.
Create an API key under Developer then API keys in the Airwallex web app, and copy the client ID shown alongside it. The key needs read access to the resources you want to sync.
Configuration
| Option | Type | Required |
|---|---|---|
Client ID | text | Yes |
API key | password | Yes |
Environment | select | Yes |
Linking Airwallex to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select Airwallex
- Fill in the required configuration fields
- Click Next, select the tables you want to sync, and then press Import
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
FinancialTransactions | The account ledger: every movement that changed an Airwallex balance. | Incremental, Full refresh | created_at | — |
Deposits | Money arriving into an Airwallex account, one row per deposit. | Incremental, Full refresh | created_at | — |
PaymentIntents | One row per attempt to collect money from a customer, with its amount, status, and captured total. | Incremental, Full refresh | created_at | — |
PaymentAttempts | Individual authorisation and capture attempts made against a payment intent. | Incremental, Full refresh | created_at | — |
Refunds | Money returned to a customer, one row per refund. | Incremental, Full refresh | created_at | — |
Customers | The customers you charge, as stored in Airwallex payment acceptance. | Incremental, Full refresh | created_at | — |
Settlements | Batches of payment activity settled into an Airwallex balance. | Incremental, Full refresh | settled_at | — |
Beneficiaries | Saved payout recipients, with their bank and entity details. | Incremental, Full refresh | created_at | — |
Transfers | Outbound payouts, with amounts, fees, conversion detail, and status. | Incremental, Full refresh | created_at | — |
GlobalAccounts | The local receiving accounts opened for your business, one row per account. | Incremental, Full refresh | created_at | — |
Invoices | Billing invoices, with totals, tax, discounts, and payment status. | Incremental, Full refresh | created_at | — |
Subscriptions | Recurring billing subscriptions and their current period and status. | Incremental, Full refresh | created_at | — |
BillingCustomers | The customers billing invoices and subscriptions belong to. | Incremental, Full refresh | created_at | — |