Lexware Office (formerly lexoffice), Haufe-Lexware GmbH
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 Lexware Office (formerly lexoffice), Haufe-Lexware GmbH to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Create an API key in Lexware Office with read access to contacts, articles, the voucher list, and the document and payment types you want to sync. Collections with 10,000 or more records cannot be imported yet.
Configuration
| Option | Type | Required |
|---|---|---|
API key | password | Yes |
Linking Lexware Office (formerly lexoffice), Haufe-Lexware GmbH to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select Lexware Office (formerly lexoffice), Haufe-Lexware GmbH
- 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 |
|---|---|---|---|---|
contacts | Customers and vendors with addresses, contact details, and contact people. | Full refresh | — | — |
articles | Products and services available for sales document line items. | Full refresh | — | — |
voucherlist | Document summaries with type, status, dates, contact, and amounts. | Full refresh | — | — |
invoices | Sales invoices with line items, taxes, and payment terms. | Full refresh | — | — |
credit_notes | Sales credit notes with line items and tax details. | Full refresh | — | — |
quotations | Sales quotations with prices, optional items, and validity dates. | Full refresh | — | — |
delivery_notes | Delivery documents with recipient details and delivered items. | Full refresh | — | — |
order_confirmations | Confirmed sales orders with items, prices, and shipping conditions. | Full refresh | — | — |
down_payment_invoices | Invoices requesting advance payments for sales. | Full refresh | — | — |
vouchers | Bookkeeping records for sales and purchase invoices and credit notes. | Full refresh | — | — |
payments | Payment status per document, with nested payment items. | Full refresh | — | — |