Skip to content
Book a demoStart free
Connectors

Invoiced connector

Set up the Invoiced connector in Kaivo: authentication, configuration, the 17 BigQuery tables it syncs, and answers to common questions.

Invoiced connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Invoiced data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your payment and finance data instead of moving it.

Sync your Invoiced billing data into BigQuery with Kaivo to analyse invoices, payments, and subscriptions in one place.

CategoryFinance & Payments
AuthenticationAPI key
SetupSelf-service

Getting started with the Invoiced connector

Section titled “Getting started with the Invoiced connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Invoiced account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticate with your API Key.

Field Description
API Key
API key to use. Find it at https://invoiced.com/account

|

Kaivo syncs 17 tables from Invoiced into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

contacts (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
country STRING
created_at FLOAT64
customer FLOAT64
customer_id FLOAT64
email STRING
id FLOAT64
name STRING
object STRING
phone STRING
primary BOOL
send_new_invoices BOOL
sms_enabled BOOL
updated_at FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
coupons (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at FLOAT64
duration FLOAT64
exclusive BOOL
id STRING
is_percent BOOL
max_redemptions FLOAT64
name STRING
object STRING
updated_at FLOAT64
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
credit_balance_adjustments (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount FLOAT64
created_at FLOAT64
currency STRING
customer FLOAT64
date FLOAT64
id FLOAT64
notes STRING
object STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
credit_notes (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
balance FLOAT64
closed BOOL
created_at FLOAT64
currency STRING
customer FLOAT64
date FLOAT64
draft BOOL
id FLOAT64
name STRING
number STRING
object STRING
paid BOOL
pdf_url STRING
status STRING
subtotal FLOAT64
total FLOAT64
updated_at FLOAT64
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
customers (41 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
active BOOL
autopay BOOL
autopay_delay_days FLOAT64
bill_to_parent BOOL
chase BOOL
consolidated BOOL
convenience_fee BOOL
country STRING
created_at FLOAT64
credit_hold BOOL
currency STRING
email STRING
id FLOAT64
name STRING
number STRING
object STRING
owner FLOAT64
owner_id FLOAT64
payment_source__brand STRING
payment_source__chargeable BOOL
payment_source__created_at FLOAT64
payment_source__customer_id FLOAT64
payment_source__exp_month FLOAT64
payment_source__exp_year FLOAT64
payment_source__funding STRING
payment_source__gateway STRING
payment_source__gateway_id STRING
payment_source__id FLOAT64
payment_source__issuing_country STRING
payment_source__last4 STRING
payment_source__object STRING
payment_source__updated_at FLOAT64
payment_terms STRING
phone STRING
statement_pdf_url STRING
statement_url STRING
taxable BOOL
updated_at FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
estimates (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
closed BOOL
created_at FLOAT64
currency STRING
customer FLOAT64
date FLOAT64
deposit FLOAT64
deposit_paid BOOL
draft BOOL
id FLOAT64
name STRING
number STRING
object STRING
pdf_url STRING
status STRING
subtotal FLOAT64
total FLOAT64
updated_at FLOAT64
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
events (168 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
data__object__type STRING
data__object__description STRING
data__object__action STRING
data__object__active BOOL
data__object__amount FLOAT64
data__object__attempt_count FLOAT64
data__object__autopay BOOL
data__object__autopay_delay_days FLOAT64
data__object__balance FLOAT64
data__object__bill_in STRING
data__object__bill_in_advance_days FLOAT64
data__object__bill_to_parent BOOL
data__object__brand STRING
data__object__cancel_at_period_end BOOL
data__object__catalog_item STRING
data__object__chargeable BOOL
data__object__chase BOOL
data__object__closed BOOL
data__object__complete BOOL
data__object__consolidated BOOL
data__object__contract_period_end FLOAT64
data__object__contract_period_start FLOAT64
data__object__contract_renewal_mode STRING
data__object__convenience_fee BOOL
data__object__country STRING
data__object__created_at FLOAT64
data__object__credit_hold BOOL
data__object__csv_url STRING
data__object__currency STRING
data__object__customer__type STRING
data__object__customer__active BOOL
data__object__customer__autopay BOOL
data__object__customer__autopay_delay_days FLOAT64
data__object__customer__bill_to_parent BOOL
data__object__customer__chase BOOL
data__object__customer__consolidated BOOL
data__object__customer__convenience_fee BOOL
data__object__customer__country STRING
data__object__customer__created_at FLOAT64
data__object__customer__credit_hold BOOL
data__object__customer__currency STRING
data__object__customer__email STRING
data__object__customer__id FLOAT64
data__object__customer__name STRING
data__object__customer__number STRING
data__object__customer__object STRING
data__object__customer__owner FLOAT64
data__object__customer__owner_id FLOAT64
data__object__customer__payment_source__brand STRING
data__object__customer__payment_source__chargeable BOOL
data__object__customer__payment_source__created_at FLOAT64
data__object__customer__payment_source__customer_id FLOAT64
data__object__customer__payment_source__exp_month FLOAT64
data__object__customer__payment_source__exp_year FLOAT64
data__object__customer__payment_source__funding STRING
data__object__customer__payment_source__gateway STRING
data__object__customer__payment_source__gateway_id STRING
data__object__customer__payment_source__id FLOAT64
data__object__customer__payment_source__issuing_country STRING
data__object__customer__payment_source__last4 STRING
data__object__customer__payment_source__object STRING
data__object__customer__payment_source__updated_at FLOAT64
data__object__customer__payment_terms STRING
data__object__customer__phone STRING
data__object__customer__statement_pdf_url STRING
data__object__customer__statement_url STRING
data__object__customer__taxable BOOL
data__object__customer__updated_at FLOAT64
data__object__customer_id FLOAT64
data__object__cycles FLOAT64
data__object__date FLOAT64
data__object__deposit FLOAT64
data__object__deposit_paid BOOL
data__object__discountable BOOL
data__object__draft BOOL
data__object__due_date FLOAT64
data__object__email STRING
data__object__exp_month FLOAT64
data__object__exp_year FLOAT64
data__object__funding STRING
data__object__gateway STRING
data__object__gateway_id STRING
data__object__id FLOAT64
data__object__issuing_country STRING
data__object__last4 STRING
data__object__late_fees BOOL
data__object__method STRING
data__object__mrr FLOAT64
data__object__name STRING
data__object__needs_attention BOOL
data__object__notes STRING
data__object__number STRING
data__object__object STRING
data__object__owner FLOAT64
data__object__owner_id FLOAT64
data__object__paid BOOL
data__object__paused BOOL
data__object__payment_source__brand STRING
data__object__payment_source__chargeable BOOL
data__object__payment_source__created_at FLOAT64
data__object__payment_source__customer_id FLOAT64
data__object__payment_source__exp_month FLOAT64
data__object__payment_source__exp_year FLOAT64
data__object__payment_source__funding STRING
data__object__payment_source__gateway STRING
data__object__payment_source__gateway_id STRING
data__object__payment_source__id FLOAT64
data__object__payment_source__issuing_country STRING
data__object__payment_source__last4 STRING
data__object__payment_source__object STRING
data__object__payment_source__updated_at FLOAT64
data__object__payment_terms STRING
data__object__payment_url STRING
data__object__pdf_url STRING
data__object__period_end FLOAT64
data__object__period_start FLOAT64
data__object__phone STRING
data__object__plan__created_at FLOAT64
data__object__plan__currency STRING
data__object__plan__id STRING
data__object__plan__interval STRING
data__object__plan__interval_count FLOAT64
data__object__plan__name STRING
data__object__plan__object STRING
data__object__plan__pricing_mode STRING
data__object__plan__quantity_type STRING
data__object__plan__updated_at FLOAT64
data__object__primary BOOL
data__object__quantity FLOAT64
data__object__recurring_total FLOAT64
data__object__reference STRING
data__object__renewed_last FLOAT64
data__object__renews_next FLOAT64
data__object__send_new_invoices BOOL
data__object__source STRING
data__object__start_date FLOAT64
data__object__statement_pdf_url STRING
data__object__statement_url STRING
data__object__status STRING
data__object__subscription FLOAT64
data__object__subscription_id FLOAT64
data__object__subtotal FLOAT64
data__object__taxable BOOL
data__object__total FLOAT64
data__object__unit_cost FLOAT64
data__object__updated_at FLOAT64
data__object__url STRING
data__object__user__created_at FLOAT64
data__object__user__email STRING
data__object__user__first_name STRING
data__object__user__id FLOAT64
data__object__user__last_name STRING
data__object__user__registered BOOL
data__object__user__two_factor_enabled BOOL
data__object__user__updated_at FLOAT64
data__object__user_id FLOAT64
data__object__voided BOOL
data__previous__balance FLOAT64
data__previous__closed BOOL
data__previous__paid BOOL
data__previous__payment_url STRING
data__previous__status STRING
data__previous__updated_at FLOAT64
id FLOAT64
timestamp FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
amount FLOAT64
created_at FLOAT64
id FLOAT64
object STRING
plan STRING
quantity FLOAT64
updated_at FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: events__data__object__applied_to

Section titled “Subtable: events__data__object__applied_to”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
amount FLOAT64
id FLOAT64
invoice FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: events__data__object__customer__taxes

Section titled “Subtable: events__data__object__customer__taxes”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
amount FLOAT64
created_at FLOAT64
discountable BOOL
id FLOAT64
name STRING
object STRING
period_end FLOAT64
period_start FLOAT64
plan STRING
prorated BOOL
quantity FLOAT64
subscription FLOAT64
taxable BOOL
unit_cost FLOAT64
updated_at FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: events__data__object__items__discounts

Section titled “Subtable: events__data__object__items__discounts”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: events__data__object__items__taxes

Section titled “Subtable: events__data__object__items__taxes”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
invoices (31 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
attempt_count FLOAT64
autopay BOOL
balance FLOAT64
chase BOOL
closed BOOL
created_at FLOAT64
csv_url STRING
currency STRING
customer FLOAT64
date FLOAT64
draft BOOL
due_date FLOAT64
id FLOAT64
late_fees BOOL
name STRING
needs_attention BOOL
number STRING
object STRING
paid BOOL
payment_terms STRING
payment_url STRING
pdf_url STRING
status STRING
subscription FLOAT64
subscription_id FLOAT64
subtotal FLOAT64
total FLOAT64
updated_at FLOAT64
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
amount FLOAT64
catalog_item STRING
created_at FLOAT64
discountable BOOL
id FLOAT64
name STRING
object STRING
period_end FLOAT64
period_start FLOAT64
plan STRING
prorated BOOL
quantity FLOAT64
subscription FLOAT64
taxable BOOL
unit_cost FLOAT64
updated_at FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
items (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
created_at FLOAT64
currency STRING
discountable BOOL
id STRING
name STRING
object STRING
taxable BOOL
unit_cost FLOAT64
updated_at FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
metered_billings (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
amount FLOAT64
created_at FLOAT64
customer FLOAT64
discountable BOOL
id FLOAT64
name STRING
object STRING
quantity FLOAT64
taxable BOOL
unit_cost FLOAT64
updated_at FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
notes (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at FLOAT64
customer FLOAT64
customer_id FLOAT64
id FLOAT64
notes STRING
object STRING
updated_at FLOAT64
user__created_at FLOAT64
user__email STRING
user__first_name STRING
user__id FLOAT64
user__last_name STRING
user__registered BOOL
user__two_factor_enabled BOOL
user__updated_at FLOAT64
user_id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
payment_sources (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
brand STRING
chargeable BOOL
created_at FLOAT64
customer FLOAT64
customer_id FLOAT64
exp_month FLOAT64
exp_year FLOAT64
funding STRING
gateway STRING
gateway_id STRING
id FLOAT64
issuing_country STRING
last4 STRING
object STRING
updated_at FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
payments (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount FLOAT64
balance FLOAT64
created_at FLOAT64
currency STRING
customer FLOAT64
date FLOAT64
id FLOAT64
method STRING
object STRING
pdf_url STRING
reference STRING
source STRING
updated_at FLOAT64
voided BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
plans (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at FLOAT64
currency STRING
id STRING
interval STRING
interval_count FLOAT64
name STRING
object STRING
pricing_mode STRING
quantity_type STRING
updated_at FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
subscriptions (27 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount FLOAT64
bill_in STRING
bill_in_advance_days FLOAT64
cancel_at_period_end BOOL
contract_period_end FLOAT64
contract_period_start FLOAT64
contract_renewal_mode STRING
created_at FLOAT64
customer FLOAT64
cycles FLOAT64
id FLOAT64
mrr FLOAT64
object STRING
paused BOOL
period_end FLOAT64
period_start FLOAT64
plan STRING
quantity FLOAT64
recurring_total FLOAT64
renewed_last FLOAT64
renews_next FLOAT64
start_date FLOAT64
status STRING
updated_at FLOAT64
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
amount FLOAT64
created_at FLOAT64
id FLOAT64
object STRING
plan STRING
quantity FLOAT64
updated_at FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
tasks (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
action STRING
complete BOOL
created_at FLOAT64
customer FLOAT64
customer_id FLOAT64
due_date FLOAT64
id FLOAT64
name STRING
updated_at FLOAT64
user_id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
tax_rates (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at FLOAT64
id STRING
inclusive BOOL
is_percent BOOL
name STRING
object STRING
updated_at FLOAT64
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Invoiced supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for Invoiced?

Section titled “How long does the initial sync take for Invoiced?”

It depends on how much history is in your Invoiced account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when Invoiced’s schema changes?

Section titled “What happens when Invoiced’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in Invoiced, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in Invoiced instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the Invoiced connector in Kaivo and all of its synced data is deleted with it.

Use invoices and payments to track billed and collected revenue over time.

Use subscriptions and plans to monitor recurring revenue and churn.

Join invoices with customers and credit_notes to track outstanding balances.

Once Invoiced data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with Invoiced data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for Invoiced connector pricing and plan details.