AccuLynx
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 AccuLynx to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Create an API key in AccuLynx API settings with a company or location administrator account. Tables use full refresh. Jobs include leads. Calendar appointments cover the date range below.
Configuration
| Option | Description |
|---|---|
API keyType: password Required: True | |
Appointment start dateType: text Required: False | Optional. Defaults to 2000-01-01. Use YYYY-MM-DD. |
Appointment end dateType: text Required: False | Optional. Defaults to 90 days from today. Use YYYY-MM-DD. |
Linking AccuLynx to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select AccuLynx
- 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 |
|---|---|---|---|---|
jobs | Jobs and leads, with their current milestone, contact, location, and lead source. | Full refresh | — | — |
contacts | Contacts with their email addresses, phone numbers, mailing address, and billing address. | Full refresh | — | — |
estimates | Detailed job estimates, including financial totals, profit, and section references. | Full refresh | — | — |
invoices | Invoices for each job, including totals, balance due, invoice state, and sections. | Full refresh | — | — |
financials | Job financial summaries with approved job value, balance due, and worksheet section totals. | Full refresh | — | — |
payments | Received payments, paid payments, and additional expenses for each job. | Full refresh | — | — |
calendars | Calendars available for the connected AccuLynx location. | Full refresh | — | — |
calendar_appointments | Appointments within the configured date range. | Full refresh | — | — |
lead_sources | Active lead sources for the connected location, including child lead sources. | Full refresh | — | — |
users | Company users across active, inactive, archived, and deleted statuses. | Full refresh | — | — |