Avalara AvaTax
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 Avalara AvaTax to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Connect your Avalara AvaTax account to pull tax transactions, companies, nexus, customers and exemption certificates into the PostHog Data warehouse.
Use your AvaTax account ID and a license key (found under Settings > License and API Keys). Generating a new license key immediately revokes the previous one. Sandbox and production credentials only work against their matching environment, so pick the one your account was created in.
Configuration
| Option | Type | Required |
|---|---|---|
Environment | select | Yes |
Account ID | text | Yes |
License key | password | Yes |
Linking Avalara AvaTax to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select Avalara AvaTax
- 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 |
|---|---|---|---|---|
Companies | A company (or subsidiary) registered in your Avalara account that AvaTax calculates and reports tax for. | Incremental, Full refresh | modifiedDate | — |
Transactions | A recorded taxable action (sale, purchase, return, or inventory transfer) with its calculated tax detail. | Incremental, Full refresh | modifiedDate | — |
Nexus | A jurisdiction where this company has a legal obligation to collect and remit tax. | Incremental, Full refresh | modifiedDate | — |
Customers | A customer of this company, used to apply exemptions and track exemption certificates. | Incremental, Full refresh | modifiedDate | — |
ExemptionCertificates | A tax exemption certificate a customer has provided to this company. | Incremental, Full refresh | modifiedDate | — |