Skip to content
Book a demoStart free
Connectors

Invoice Ninja connector

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

Invoice Ninja connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Invoice Ninja 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 Invoice Ninja data into BigQuery with Kaivo to analyse invoices, payments, and project billing in one place.

CategoryFinance & Payments
AuthenticationAPI key
SetupSelf-service

Getting started with the Invoice Ninja connector

Section titled “Getting started with the Invoice Ninja connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Invoice Ninja 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

Tables and columns synced from Invoice Ninja

Section titled “Tables and columns synced from Invoice Ninja”

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

bank transactions (29 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
account_type STRING
amount FLOAT64
archived_at FLOAT64
bank_account_id FLOAT64
bank_integration_id STRING
bank_transaction_rule_id STRING
base_type STRING
category_id FLOAT64
category_type STRING
created_at FLOAT64
currency_id STRING
date STRING
expense_id STRING
id STRING
invoice_ids STRING
is_deleted BOOL
ninja_category_id STRING
nordigen_transaction_id STRING
participant STRING
participant_name STRING
payment_id STRING
status_id STRING
transaction_id FLOAT64
updated_at FLOAT64
user_id STRING
vendor_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
clients (56 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
address1 STRING
address2 STRING
archived_at FLOAT64
assigned_user_id STRING
balance FLOAT64
city STRING
classification STRING
client_hash STRING
country_id STRING
created_at FLOAT64
credit_balance FLOAT64
custom_value1 STRING
custom_value2 STRING
custom_value3 STRING
custom_value4 STRING
display_name STRING
group_settings_id STRING
has_valid_vat_number BOOL
id STRING
id_number STRING
industry_id STRING
is_deleted BOOL
is_tax_exempt BOOL
last_login FLOAT64
name STRING
number STRING
paid_to_date FLOAT64
payment_balance FLOAT64
phone STRING
postal_code STRING
private_notes STRING
public_notes STRING
routing_id STRING
settings__currency_id STRING
settings__default_task_rate FLOAT64
settings__entity STRING
settings__industry_id STRING
settings__language_id STRING
settings__payment_terms STRING
settings__send_reminders BOOL
settings__size_id STRING
settings__valid_until STRING
shipping_address1 STRING
shipping_address2 STRING
shipping_city STRING
shipping_country_id STRING
shipping_postal_code STRING
shipping_state STRING
size_id STRING
state STRING
updated_at FLOAT64
user_id STRING
vat_number STRING
website 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.
archived_at FLOAT64
contact_key STRING
created_at FLOAT64
custom_value1 STRING
custom_value2 STRING
custom_value3 STRING
custom_value4 STRING
email STRING
first_name STRING
id STRING
is_locked BOOL
is_primary BOOL
last_login FLOAT64
last_name STRING
link STRING
password STRING
phone STRING
send_email 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.
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.
credits (61 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount FLOAT64
archived_at FLOAT64
assigned_user_id STRING
balance FLOAT64
client_id STRING
created_at FLOAT64
custom_surcharge1 FLOAT64
custom_surcharge2 FLOAT64
custom_surcharge3 FLOAT64
custom_surcharge4 FLOAT64
custom_surcharge_tax1 BOOL
custom_surcharge_tax2 BOOL
custom_surcharge_tax3 BOOL
custom_surcharge_tax4 BOOL
custom_value1 STRING
custom_value2 STRING
custom_value3 STRING
custom_value4 STRING
date STRING
design_id STRING
discount FLOAT64
due_date STRING
entity_type STRING
exchange_rate FLOAT64
footer STRING
has_expenses BOOL
has_tasks BOOL
id STRING
invoice_id STRING
is_amount_discount BOOL
is_deleted BOOL
last_sent_date STRING
next_send_date STRING
number STRING
paid_to_date FLOAT64
partial FLOAT64
partial_due_date STRING
po_number STRING
private_notes STRING
project_id STRING
public_notes STRING
reminder1_sent STRING
reminder2_sent STRING
reminder3_sent STRING
reminder_last_sent STRING
status_id STRING
subscription_id STRING
tax_name1 STRING
tax_name2 STRING
tax_name3 STRING
tax_rate1 FLOAT64
tax_rate2 FLOAT64
tax_rate3 FLOAT64
terms STRING
total_taxes FLOAT64
updated_at FLOAT64
user_id STRING
uses_inclusive_taxes BOOL
vendor_id 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.
archived_at FLOAT64
client_contact_id STRING
created_at FLOAT64
email_error STRING
email_status STRING
id STRING
key STRING
link STRING
message_id STRING
opened_date STRING
sent_date STRING
updated_at FLOAT64
viewed_date 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.
expenses (48 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount FLOAT64
archived_at FLOAT64
assigned_user_id STRING
bank_id STRING
calculate_tax_by_amount BOOL
category_id STRING
client_id STRING
created_at FLOAT64
currency_id STRING
custom_value1 STRING
custom_value2 STRING
custom_value3 STRING
custom_value4 STRING
date STRING
entity_type STRING
exchange_rate FLOAT64
expense_currency_id STRING
foreign_amount FLOAT64
id STRING
invoice_currency_id STRING
invoice_documents BOOL
invoice_id STRING
is_deleted BOOL
number STRING
payment_date STRING
payment_type_id STRING
private_notes STRING
project_id STRING
public_notes STRING
recurring_expense_id STRING
should_be_invoiced BOOL
tax_amount1 FLOAT64
tax_amount2 FLOAT64
tax_amount3 FLOAT64
tax_name1 STRING
tax_name2 STRING
tax_name3 STRING
tax_rate1 FLOAT64
tax_rate2 FLOAT64
tax_rate3 FLOAT64
transaction_id STRING
transaction_reference STRING
updated_at FLOAT64
user_id STRING
uses_inclusive_taxes BOOL
vendor_id 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.
invoices (62 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount FLOAT64
archived_at FLOAT64
assigned_user_id STRING
auto_bill_enabled BOOL
balance FLOAT64
client_id STRING
created_at FLOAT64
custom_surcharge1 FLOAT64
custom_surcharge2 FLOAT64
custom_surcharge3 FLOAT64
custom_surcharge4 FLOAT64
custom_surcharge_tax1 BOOL
custom_surcharge_tax2 BOOL
custom_surcharge_tax3 BOOL
custom_surcharge_tax4 BOOL
custom_value1 STRING
custom_value2 STRING
custom_value3 STRING
custom_value4 STRING
date STRING
design_id STRING
discount FLOAT64
due_date STRING
entity_type STRING
exchange_rate FLOAT64
footer STRING
has_expenses BOOL
has_tasks BOOL
id STRING
is_amount_discount BOOL
is_deleted BOOL
last_sent_date STRING
next_send_date STRING
number STRING
paid_to_date FLOAT64
partial FLOAT64
partial_due_date STRING
po_number STRING
private_notes STRING
project_id STRING
public_notes STRING
recurring_id STRING
reminder1_sent STRING
reminder2_sent STRING
reminder3_sent STRING
reminder_last_sent STRING
status_id STRING
subscription_id STRING
tax_name1 STRING
tax_name2 STRING
tax_name3 STRING
tax_rate1 FLOAT64
tax_rate2 FLOAT64
tax_rate3 FLOAT64
terms STRING
total_taxes FLOAT64
updated_at FLOAT64
user_id STRING
uses_inclusive_taxes BOOL
vendor_id 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.
archived_at FLOAT64
client_contact_id STRING
created_at FLOAT64
email_error STRING
email_status STRING
id STRING
key STRING
link STRING
message_id STRING
opened_date STRING
sent_date STRING
updated_at FLOAT64
viewed_date 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.
_id STRING
cost FLOAT64
custom_value1 STRING
custom_value2 STRING
custom_value3 STRING
custom_value4 STRING
date STRING
discount FLOAT64
expense_id STRING
gross_line_total FLOAT64
is_amount_discount BOOL
line_total FLOAT64
notes STRING
product_cost FLOAT64
product_key STRING
quantity FLOAT64
sort_id STRING
task_id STRING
tax_amount FLOAT64
tax_id STRING
tax_name1 STRING
tax_name2 STRING
tax_name3 STRING
tax_rate1 FLOAT64
tax_rate2 FLOAT64
tax_rate3 FLOAT64
type_id STRING
unit_code STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
payments (34 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount FLOAT64
applied FLOAT64
archived_at FLOAT64
assigned_user_id STRING
client_contact_id STRING
client_id STRING
company_gateway_id STRING
created_at FLOAT64
currency_id STRING
custom_value1 STRING
custom_value2 STRING
custom_value3 STRING
custom_value4 STRING
date STRING
exchange_currency_id STRING
exchange_rate FLOAT64
gateway_type_id STRING
id STRING
invitation_id STRING
is_deleted BOOL
is_manual BOOL
number STRING
private_notes STRING
project_id STRING
refunded FLOAT64
status_id STRING
transaction_id STRING
transaction_reference STRING
type_id STRING
updated_at FLOAT64
user_id STRING
vendor_id 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.
products (30 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
archived_at FLOAT64
assigned_user_id STRING
cost FLOAT64
created_at FLOAT64
custom_value1 STRING
custom_value2 STRING
custom_value3 STRING
custom_value4 STRING
id STRING
in_stock_quantity FLOAT64
is_deleted BOOL
max_quantity FLOAT64
notes STRING
price FLOAT64
product_image STRING
product_key STRING
quantity FLOAT64
stock_notification BOOL
stock_notification_threshold FLOAT64
tax_id STRING
tax_name1 STRING
tax_name2 STRING
tax_name3 STRING
tax_rate1 FLOAT64
tax_rate2 FLOAT64
tax_rate3 FLOAT64
updated_at FLOAT64
user_id 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.
projects (23 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
archived_at FLOAT64
assigned_user_id STRING
budgeted_hours FLOAT64
client_id STRING
color STRING
created_at FLOAT64
current_hours FLOAT64
custom_value1 STRING
custom_value2 STRING
custom_value3 STRING
custom_value4 STRING
due_date STRING
id STRING
is_deleted BOOL
name STRING
number STRING
private_notes STRING
public_notes STRING
task_rate FLOAT64
updated_at FLOAT64
user_id 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.
purchase_orders (62 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount FLOAT64
archived_at FLOAT64
assigned_user_id STRING
balance FLOAT64
client_id STRING
created_at FLOAT64
currency_id STRING
custom_surcharge1 FLOAT64
custom_surcharge2 FLOAT64
custom_surcharge3 FLOAT64
custom_surcharge4 FLOAT64
custom_surcharge_tax1 BOOL
custom_surcharge_tax2 BOOL
custom_surcharge_tax3 BOOL
custom_surcharge_tax4 BOOL
custom_value1 STRING
custom_value2 STRING
custom_value3 STRING
custom_value4 STRING
date STRING
design_id STRING
discount FLOAT64
due_date STRING
entity_type STRING
exchange_rate FLOAT64
expense_id STRING
footer STRING
has_expenses BOOL
has_tasks BOOL
id STRING
is_amount_discount BOOL
is_deleted BOOL
last_sent_date STRING
next_send_date STRING
number STRING
paid_to_date FLOAT64
partial FLOAT64
partial_due_date STRING
po_number STRING
private_notes STRING
project_id STRING
public_notes STRING
reminder1_sent STRING
reminder2_sent STRING
reminder3_sent STRING
reminder_last_sent STRING
status_id STRING
subscription_id STRING
tax_name1 STRING
tax_name2 STRING
tax_name3 STRING
tax_rate1 FLOAT64
tax_rate2 FLOAT64
tax_rate3 FLOAT64
terms STRING
total_taxes FLOAT64
updated_at FLOAT64
user_id STRING
uses_inclusive_taxes BOOL
vendor_id 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.
archived_at FLOAT64
created_at FLOAT64
email_error STRING
email_status STRING
id STRING
key STRING
link STRING
message_id STRING
opened_date STRING
sent_date STRING
updated_at FLOAT64
vendor_contact_id STRING
viewed_date 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.
quotes (61 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount FLOAT64
archived_at FLOAT64
assigned_user_id STRING
balance FLOAT64
client_id STRING
created_at FLOAT64
custom_surcharge1 FLOAT64
custom_surcharge2 FLOAT64
custom_surcharge3 FLOAT64
custom_surcharge4 FLOAT64
custom_surcharge_tax1 BOOL
custom_surcharge_tax2 BOOL
custom_surcharge_tax3 BOOL
custom_surcharge_tax4 BOOL
custom_value1 STRING
custom_value2 STRING
custom_value3 STRING
custom_value4 STRING
date STRING
design_id STRING
discount FLOAT64
due_date STRING
entity_type STRING
exchange_rate FLOAT64
footer STRING
has_expenses BOOL
has_tasks BOOL
id STRING
invoice_id STRING
is_amount_discount BOOL
is_deleted BOOL
last_sent_date STRING
next_send_date STRING
number STRING
paid_to_date FLOAT64
partial FLOAT64
partial_due_date STRING
po_number STRING
private_notes STRING
project_id STRING
public_notes STRING
reminder1_sent STRING
reminder2_sent STRING
reminder3_sent STRING
reminder_last_sent STRING
status_id STRING
subscription_id STRING
tax_name1 STRING
tax_name2 STRING
tax_name3 STRING
tax_rate1 FLOAT64
tax_rate2 FLOAT64
tax_rate3 FLOAT64
terms STRING
total_taxes FLOAT64
updated_at FLOAT64
user_id STRING
uses_inclusive_taxes BOOL
vendor_id 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.
archived_at FLOAT64
client_contact_id STRING
created_at FLOAT64
email_error STRING
email_status STRING
id STRING
key STRING
link STRING
message_id STRING
opened_date STRING
sent_date STRING
updated_at FLOAT64
viewed_date 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.
recurring expenses (52 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount FLOAT64
archived_at FLOAT64
assigned_user_id STRING
bank_id STRING
calculate_tax_by_amount BOOL
category_id STRING
client_id STRING
created_at FLOAT64
currency_id STRING
custom_value1 STRING
custom_value2 STRING
custom_value3 STRING
custom_value4 STRING
date STRING
entity_type STRING
exchange_rate FLOAT64
foreign_amount FLOAT64
frequency_id STRING
id STRING
invoice_currency_id STRING
invoice_documents BOOL
invoice_id STRING
is_deleted BOOL
last_sent_date STRING
next_send_date STRING
number STRING
payment_date STRING
payment_type_id STRING
private_notes STRING
project_id STRING
public_notes STRING
recurring_expense_currency_id STRING
remaining_cycles FLOAT64
should_be_invoiced BOOL
status_id STRING
tax_amount1 FLOAT64
tax_amount2 FLOAT64
tax_amount3 FLOAT64
tax_name1 STRING
tax_name2 STRING
tax_name3 STRING
tax_rate1 FLOAT64
tax_rate2 FLOAT64
tax_rate3 FLOAT64
transaction_id STRING
transaction_reference STRING
updated_at FLOAT64
user_id STRING
uses_inclusive_taxes BOOL
vendor_id 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.

Subtable: recurring expenses__recurring_dates

Section titled “Subtable: recurring expenses__recurring_dates”
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.
recurring invoices (62 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount FLOAT64
archived_at FLOAT64
assigned_user_id STRING
auto_bill STRING
auto_bill_enabled BOOL
balance FLOAT64
client_id STRING
created_at FLOAT64
custom_surcharge1 FLOAT64
custom_surcharge2 FLOAT64
custom_surcharge3 FLOAT64
custom_surcharge4 FLOAT64
custom_surcharge_tax1 BOOL
custom_surcharge_tax2 BOOL
custom_surcharge_tax3 BOOL
custom_surcharge_tax4 BOOL
custom_value1 STRING
custom_value2 STRING
custom_value3 STRING
custom_value4 STRING
date STRING
design_id STRING
discount FLOAT64
due_date STRING
due_date_days STRING
entity_type STRING
exchange_rate FLOAT64
footer STRING
frequency_id STRING
has_expenses BOOL
has_tasks BOOL
id STRING
is_amount_discount BOOL
is_deleted BOOL
last_sent_date STRING
next_send_date STRING
next_send_datetime STRING
number STRING
paid_to_date FLOAT64
partial FLOAT64
partial_due_date STRING
po_number STRING
private_notes STRING
project_id STRING
public_notes STRING
remaining_cycles FLOAT64
status_id STRING
subscription_id STRING
tax_name1 STRING
tax_name2 STRING
tax_name3 STRING
tax_rate1 FLOAT64
tax_rate2 FLOAT64
tax_rate3 FLOAT64
terms STRING
total_taxes FLOAT64
updated_at FLOAT64
user_id STRING
uses_inclusive_taxes BOOL
vendor_id 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.
archived_at FLOAT64
client_contact_id STRING
created_at FLOAT64
email_error STRING
email_status STRING
id STRING
key STRING
link STRING
message_id STRING
opened_date STRING
sent_date STRING
updated_at FLOAT64
viewed_date 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.
_id STRING
cost FLOAT64
custom_value1 STRING
custom_value2 STRING
custom_value3 STRING
custom_value4 STRING
date STRING
discount FLOAT64
expense_id STRING
gross_line_total FLOAT64
is_amount_discount BOOL
line_total FLOAT64
notes STRING
product_cost FLOAT64
product_key STRING
quantity FLOAT64
sort_id STRING
task_id STRING
tax_amount FLOAT64
tax_id STRING
tax_name1 STRING
tax_name2 STRING
tax_name3 STRING
tax_rate1 FLOAT64
tax_rate2 FLOAT64
tax_rate3 FLOAT64
type_id STRING
unit_code STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: recurring invoices__recurring_dates

Section titled “Subtable: recurring invoices__recurring_dates”
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 (47 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
archived_at FLOAT64
assigned_user_id STRING
client_id STRING
created_at FLOAT64
custom_value1 STRING
custom_value2 STRING
custom_value3 STRING
custom_value4 STRING
date STRING
duration FLOAT64
id STRING
invoice_id STRING
is_date_based BOOL
is_deleted BOOL
is_running BOOL
number STRING
project__archived_at FLOAT64
project__assigned_user_id STRING
project__budgeted_hours FLOAT64
project__client_id STRING
project__color STRING
project__created_at FLOAT64
project__current_hours FLOAT64
project__custom_value1 STRING
project__custom_value2 STRING
project__custom_value3 STRING
project__custom_value4 STRING
project__due_date STRING
project__id STRING
project__is_deleted BOOL
project__name STRING
project__number STRING
project__private_notes STRING
project__public_notes STRING
project__task_rate FLOAT64
project__updated_at FLOAT64
project__user_id STRING
project_id STRING
rate FLOAT64
status_id STRING
status_sort_order FLOAT64
time_log STRING
updated_at FLOAT64
user_id 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.
vendors (34 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
address1 STRING
address2 STRING
archived_at FLOAT64
assigned_user_id STRING
city STRING
classification STRING
country_id STRING
created_at FLOAT64
currency_id STRING
custom_value1 STRING
custom_value2 STRING
custom_value3 STRING
custom_value4 STRING
display_name STRING
id STRING
id_number STRING
is_deleted BOOL
is_tax_exempt BOOL
language_id STRING
last_login FLOAT64
name STRING
number STRING
phone STRING
postal_code STRING
private_notes STRING
public_notes STRING
routing_id STRING
state STRING
updated_at FLOAT64
user_id STRING
vat_number STRING
website 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.
archived_at FLOAT64
created_at FLOAT64
custom_value1 STRING
custom_value2 STRING
custom_value3 STRING
custom_value4 STRING
email STRING
first_name STRING
id STRING
is_primary BOOL
last_login FLOAT64
last_name STRING
link STRING
password STRING
phone STRING
send_email 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.

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Invoice Ninja 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 Invoice Ninja?

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

It depends on how much history is in your Invoice Ninja 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 Invoice Ninja’s schema changes?

Section titled “What happens when Invoice Ninja’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 Invoice Ninja, 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 Invoice Ninja 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 Invoice Ninja 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 recurring invoices to monitor subscription revenue.

Join projects and tasks with invoices to compare billed time against work.

Use Invoice Ninja data in your AI and BI tools

Section titled “Use Invoice Ninja data in your AI and BI tools”

Once Invoice Ninja 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 Invoice Ninja 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 Invoice Ninja connector pricing and plan details.