Alegra
BetaThis source is currently in beta. It works end to end, but you may still hit rough edges. Let us know if you do.
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 Alegra to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Configuration
| Option | Description |
|---|---|
EmailType: email Required: True | |
API tokenType: password Required: True | Find your token in Alegra under Settings > API integrations. |
Linking Alegra to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select Alegra
- 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 |
|---|---|---|---|---|
invoices | Sales invoices with line items, taxes, payments, and outstanding balances. | Full refresh | — | — |
contacts | Customers and suppliers with contact details and accounting information. | Full refresh | — | — |
items | Products and services with prices, taxes, and inventory details. | Full refresh | — | — |
incoming_payments | Received payments and their associated invoices, contacts, and bank accounts. | Full refresh | — | — |
outgoing_payments | Outgoing payments and their associated purchase documents and bank accounts. | Full refresh | — | — |
bills | Supplier bills with purchase details, taxes, payments, and outstanding balances. | Full refresh | — | — |
estimates | Sales quotations with customers, line items, prices, and taxes. | Full refresh | — | — |
credit_notes | Customer credit notes, associated sales invoices, and refunds. | Full refresh | — | — |
debit_notes | Supplier debit notes and their associated purchase documents. | Full refresh | — | — |
bank_accounts | Bank, cash, and credit card accounts used to receive and make payments. | Full refresh | — | — |
item_categories | Categories used to group products and services. | Full refresh | — | — |
warehouses | Warehouses that hold item inventory. | Full refresh | — | — |
inventory_adjustments | Manual stock corrections that add or remove item quantities in a warehouse. | Full refresh | — | — |
warehouse_transfers | Stock movements of items from one warehouse to another. | Full refresh | — | — |
purchase_orders | Purchase orders sent to suppliers before the supplier bills arrive. | Full refresh | — | — |
recurring_invoices | Schedules that create sales invoices for a client at a fixed interval. | Full refresh | — | — |
taxes | Tax definitions and rates that apply to invoices, bills, and items. | Full refresh | — | — |