Cliniko
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 Cliniko to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Enter your Cliniko API key. You can generate one from your Cliniko account under My Info > API Keys. The clinic's region (shard) is detected automatically from the key.
Configuration
| Option | Type | Required |
|---|---|---|
API key | password | Yes |
Linking Cliniko to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select Cliniko
- 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 |
|---|---|---|---|---|
appointment_types | A configurable type of appointment (e.g. Initial Consultation), with duration and pricing defaults. | Incremental, Full refresh | updated_at | — |
attendees | A patient's attendance record for one appointment, including arrival and cancellation status. | Incremental, Full refresh | updated_at | — |
businesses | A business location (clinic site) within the practice. | Incremental, Full refresh | updated_at | — |
group_appointments | An appointment with multiple patient attendees, run by one practitioner. | Incremental, Full refresh | updated_at | — |
individual_appointments | A one-on-one appointment between a patient and a practitioner. | Incremental, Full refresh | updated_at | — |
invoice_items | A single line item (service or product) on an invoice. | Incremental, Full refresh | updated_at | — |
invoices | A billing invoice raised for a patient's appointment. | Incremental, Full refresh | updated_at | — |
patients | A patient (client) record in the practice. | Incremental, Full refresh | updated_at | — |
practitioners | A practitioner (allied health provider) who delivers appointments. | Incremental, Full refresh | updated_at | — |
products | A stock item (e.g. retail product) that can be sold or used in appointments. | Incremental, Full refresh | updated_at | — |
referral_sources | How a patient was referred to the practice (e.g. a referring doctor or marketing channel). | Incremental, Full refresh | updated_at | — |
treatment_notes | A clinical treatment note recorded for a patient's appointment. | Incremental, Full refresh | updated_at | — |