Skip to content
Book a demoStart free
Connectors

Netvisor connector

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

Netvisor connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Netvisor 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 Netvisor accounting data into BigQuery with Kaivo to report on invoices, ledgers, and financials alongside the rest of your business.

CategoryFinance & Payments
AuthenticationAPI key
SetupSelf-service

Getting started with the Netvisor connector

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

Field Description
Customer key
Key of the API User. In Finnish “Avain”.

|

To be able to use this connector, you first need to:

  1. Open custom integration in Netvisor using this partner search identifier: “47D3C7724BC430B56E3AD4EC7515A6ED”. Instructions (in Finnish).
  2. Give the custom integration access rights to the customerlist.nv resource (it is needed for checking that the connection works).
  3. Create API identifiers (Ohjelmistorajapintatunnukset) in Netvisor. Instructions (in Finnish).

When you set up the connector, you provide:

Field Description
Customer ID
ID of the API User. In Finnish “Käyttäjätunniste”.

| | Organization ID |

ID of the organization. In Finnish “Y-Tunnus”.

| | Ledger start date |

Any data before this date will not be fetched.

|

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

accounting_ledgers (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
linked_source_netvisor_key__text INT64
linked_source_netvisor_key__type STRING
netvisor_key INT64
status STRING
voucher_class STRING
voucher_class__netvisorkey STRING
voucher_date DATE
voucher_description STRING
voucher_netvisor_uri STRING
voucher_number INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: accounting_ledgers__voucher_lines

Section titled “Subtable: accounting_ledgers__voucher_lines”
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.
account_dimension__netvisor_key STRING
account_dimension__text STRING
account_number INT64
description STRING
line_sum FLOAT64
netvisor_key INT64
status STRING
vat_code STRING
vat_percent FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: accounting_ledgers__voucher_lines__dimensions

Section titled “Subtable: accounting_ledgers__voucher_lines__dimensions”
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.
dimension_item STRING
dimension_name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
accounts (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_type STRING
end_sort INT64
father_netvisor_key INT64
is_active INT64
is_cumulative INT64
is_natural_negative INT64
name STRING
netvisor_key INT64
number INT64
sort INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
circulation_lists (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
approver__name STRING
is_default STRING
is_forced STRING
last_edited_time_stamp STRING
name STRING
netvisor_key INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: circulation_lists__factual_verifiers

Section titled “Subtable: circulation_lists__factual_verifiers”
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.
is_main_factual_verifier STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
customers (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
code STRING
customer_group_id INT64
customer_group_name STRING
name STRING
netvisorkey INT64
organisation_identifier STRING
uri STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
dimensions (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
is_hidden STRING
link_type INT64
name STRING
netvisorkey INT64
_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.
end_sort INT64
father_id INT64
is_hidden STRING
level INT64
name STRING
netvisorkey INT64
sort INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
employees (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
employeenumber INT64
employmentstatus INT64
firstname STRING
lastname STRING
netvisorkey INT64
payrollservice INT64
personalid__personalid_text STRING
personalid__type STRING
realname STRING
resourcemanagement INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
payroll_ratios (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
default_credit_account_number INT64
default_debit_account_number INT64
identifier__identifier_text INT64
identifier__type STRING
ratio_number INT64
source__netvisor_key STRING
source__source_text 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.
iso639_1_code STRING
name_text STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
products (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
name STRING
netvisor_key INT64
product_code STRING
product_group_description STRING
product_group_id INT64
unit_gross_price FLOAT64
unit_price FLOAT64
uri STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
purchase_invoices (42 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
actions JSON
alerts JSON
approval_status STRING
attachment_count INT64
fingerprint STRING
foreign_currency_amount FLOAT64
foreign_currency_name_id STRING
invoice_status STRING
is_accounted STRING
is_purchase_invoice_vendor_bank_account_deleted STRING
is_purchase_invoice_vendor_bank_account_from_sepa_region STRING
notifications JSON
posting_lines_access__can_edit_accounting_suggestion STRING
posting_lines_access__can_edit_posting_lines STRING
posting_lines_access__can_user_post_invoice STRING
posting_lines_access__suggest_posting_by_default STRING
purchase_invoice_agreement_identifier STRING
purchase_invoice_amount FLOAT64
purchase_invoice_date DATE
purchase_invoice_delivery_date DATE
purchase_invoice_description STRING
purchase_invoice_due_date DATE
purchase_invoice_event_date DATE
purchase_invoice_netvisor_key INT64
purchase_invoice_number STRING
purchase_invoice_our_reference STRING
purchase_invoice_paid_amount FLOAT64
purchase_invoice_referencenumber STRING
purchase_invoice_value_date DATE
purchase_invoice_vendor_bank_account_number STRING
purchase_invoice_your_reference STRING
vendor_addressline STRING
vendor_code STRING
vendor_country STRING
vendor_name STRING
vendor_netvisor_key INT64
vendor_organization_identifier STRING
vendor_postnumber STRING
vendor_town STRING
voucher_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: purchase_invoices__handling_history

Section titled “Subtable: purchase_invoices__handling_history”
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
heading STRING
timestamp STRING
type STRING
user_email STRING
user_name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: purchase_invoices__handling_history__updated_information_fields

Section titled “Subtable: purchase_invoices__handling_history__updated_information_fields”
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.
field_name STRING
new_value STRING
old_value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: purchase_invoices__linked_purchase_orders

Section titled “Subtable: purchase_invoices__linked_purchase_orders”
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.
netvisor_key INT64
order_number INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: purchase_invoices__purchase_invoice_lines

Section titled “Subtable: purchase_invoices__purchase_invoice_lines”
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.
accounting_suggestion_bookkeeping_account STRING
accounting_suggestion_bookkeeping_account_netvisor_key INT64
delivered_amount FLOAT64
description STRING
discount_percentage FLOAT64
line_net_sum FLOAT64
line_sum FLOAT64
netvisor_key INT64
ordered_amount FLOAT64
product_code STRING
product_name STRING
purchase_price JSON
unit STRING
unit_price FLOAT64
vat_code STRING
vat_percent INT64
purchase_invoice_line_dimensions JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
purchase_orders (30 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount__currencycode STRING
amount__text FLOAT64
amount__type STRING
comment STRING
delivery_address_line STRING
delivery_city STRING
delivery_country__text STRING
delivery_country__type STRING
delivery_method STRING
delivery_name STRING
delivery_post_number INT64
delivery_term STRING
linked_purchase_invoices__linked_purchase_invoices JSON
netvisor_key INT64
order_date DATE
order_number INT64
order_status__deliverystatus STRING
order_status__text STRING
our_reference STRING
payment_term STRING
private_comment STRING
purchase_order_product_lines JSON
vendor_address_line STRING
vendor_city STRING
vendor_country__text STRING
vendor_country__type STRING
vendor_name STRING
vendor_post_number STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
salaries (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
key INT64
employee_name STRING
payperiod_start DATE
payperiod_end DATE
due_date DATE
paid_amount STRING
version STRING
vacation_records__heading STRING
pay_details__heading STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: salaries__vacation_records__records

Section titled “Subtable: salaries__vacation_records__records”
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.
label STRING
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: salaries__pay_details__heading_line__heading

Section titled “Subtable: salaries__pay_details__heading_line__heading”
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 STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: salaries__pay_details__detail_lines__detail_line

Section titled “Subtable: salaries__pay_details__detail_lines__detail_line”
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.
amount STRING
description STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: salaries__pay_details__detail_lines__detail_line__value

Section titled “Subtable: salaries__pay_details__detail_lines__detail_line__value”
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 STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
salary_parameters (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
netvisorkey INT64
rationumber INT64
value INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
sales_invoices (55 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
credited_invoice_netvisor_key INT64
delivery_address_country_code STRING
delivery_address_line STRING
delivery_address_name STRING
delivery_address_postnumber STRING
delivery_address_town STRING
delivery_method STRING
delivery_office_identifier JSON
delivery_term STRING
foreign_currency_amount FLOAT64
invoice_status__status STRING
invoice_status__text STRING
invoice_voucher__netvisor_key STRING
invoice_voucher__text INT64
invoicing_customer_additional_address_line STRING
invoicing_customer_addressline STRING
invoicing_customer_code INT64
invoicing_customer_country_code__iso_3166 STRING
invoicing_customer_country_code__text STRING
invoicing_customer_name STRING
invoicing_customer_name_extension STRING
invoicing_customer_netvisor_key INT64
invoicing_customer_organization_identifier STRING
invoicing_customer_postnumber STRING
invoicing_customer_town STRING
match_partial_payments_by_default STRING
payment_term_cash_discount__text INT64
payment_term_cash_discount__type STRING
payment_term_cash_discount_days INT64
payment_term_net_days INT64
sales_invoice_agreement_identifier JSON
sales_invoice_amount__currencyrate STRING
sales_invoice_amount__iso4217currencycode STRING
sales_invoice_amount__text FLOAT64
sales_invoice_collection_cost INT64
sales_invoice_date DATE
sales_invoice_delivery_date DATE
sales_invoice_due_date DATE
sales_invoice_event_date DATE
sales_invoice_free_text_after_lines STRING
sales_invoice_free_text_before_lines STRING
sales_invoice_netvisor_key INT64
sales_invoice_number INT64
sales_invoice_our_reference STRING
sales_invoice_private_comment STRING
sales_invoice_referencenumber INT64
sales_invoice_value_date DATE
sales_invoice_your_reference STRING
second_name JSON
seller_identifier__text STRING
seller_identifier__type STRING
tax_handling_clause JSON
waybill_identifier JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: sales_invoices__sales_invoice_product_lines

Section titled “Subtable: sales_invoices__sales_invoice_product_lines”
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.
accounting_account_suggestion INT64
accounting_account_suggestion_account_number INT64
netvisor_key INT64
product_name STRING
product_netvisor_key INT64
product_primary_ean_code JSON
product_purchase_price FLOAT64
product_secondary_ean_code JSON
product_unit_price FLOAT64
product_vat_percentage__text INT64
product_vat_percentage__vatcode STRING
productidentifier__text STRING
productidentifier__type STRING
provision_percentage INT64
sales_invoice_product_line_discount_percentage FLOAT64
sales_invoice_product_line_free_text STRING
sales_invoice_product_line_inventory_id INT64
sales_invoice_product_line_inventory_name STRING
sales_invoice_product_line_quantity FLOAT64
sales_invoice_product_line_sum FLOAT64
sales_invoice_product_line_unit STRING
sales_invoice_product_line_vat_sum 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.
netvisor_key INT64
order_number INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
sales_orders (52 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
delivery_address_country_code STRING
delivery_address_line STRING
delivery_address_name STRING
delivery_address_postnumber STRING
delivery_address_town STRING
delivery_method STRING
delivery_office_identifier JSON
delivery_term STRING
delivery_to_customer_date DATE
delivery_to_customer_week STRING
foreign_currency_amount FLOAT64
invoice_status__status STRING
invoice_status__text STRING
invoicing_customer_additional_address_line STRING
invoicing_customer_addressline STRING
invoicing_customer_code INT64
invoicing_customer_country_code__iso_3166 STRING
invoicing_customer_country_code__text STRING
invoicing_customer_name STRING
invoicing_customer_name_extension STRING
invoicing_customer_netvisor_key INT64
invoicing_customer_organization_identifier STRING
invoicing_customer_postnumber STRING
invoicing_customer_town STRING
match_partial_payments_by_default STRING
payment_term_cash_discount__text INT64
payment_term_cash_discount__type STRING
payment_term_cash_discount_days INT64
payment_term_net_days INT64
sales_invoice_agreement_identifier JSON
sales_invoice_amount__currencyrate STRING
sales_invoice_amount__iso4217currencycode STRING
sales_invoice_amount__text FLOAT64
sales_invoice_date DATE
sales_invoice_delivery_date DATE
sales_invoice_due_date DATE
sales_invoice_event_date DATE
sales_invoice_free_text_after_lines STRING
sales_invoice_free_text_before_lines STRING
sales_invoice_netvisor_key INT64
sales_invoice_number INT64
sales_invoice_our_reference STRING
sales_invoice_private_comment STRING
sales_invoice_referencenumber INT64
sales_invoice_value_date DATE
sales_invoice_your_reference STRING
second_name JSON
seller_identifier__text STRING
seller_identifier__type STRING
waybill_identifier JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: sales_orders__sales_invoice_product_lines

Section titled “Subtable: sales_orders__sales_invoice_product_lines”
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.
accounting_account_suggestion JSON
accounting_account_suggestion_account_number JSON
line_status STRING
netvisor_key INT64
product_name STRING
product_netvisor_key INT64
product_primary_ean_code JSON
product_purchase_price FLOAT64
product_secondary_ean_code JSON
product_unit_price FLOAT64
product_vat_percentage__text INT64
product_vat_percentage__vatcode STRING
productidentifier__text STRING
productidentifier__type STRING
provision_percentage INT64
sales_invoice_product_line_delivery_date DATE
sales_invoice_product_line_discount_percentage FLOAT64
sales_invoice_product_line_free_text STRING
sales_invoice_product_line_inventory_id INT64
sales_invoice_product_line_inventory_name STRING
sales_invoice_product_line_quantity FLOAT64
sales_invoice_product_line_sum FLOAT64
sales_invoice_product_line_unit STRING
sales_invoice_product_line_vat_sum 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.
invoice_number INT64
netvisor_key INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
vendors (27 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active BOOL
address STRING
city STRING
code STRING
comment STRING
contact_person_email STRING
contact_person_name STRING
contact_person_phone_number STRING
country__text STRING
country__type STRING
default_vat_percent INT64
email STRING
fax_number STRING
group_name STRING
home_page STRING
is_partial_vat_reduce_privileged INT64
name STRING
netvisor_key INT64
organization_id STRING
payment_term STRING
phone_number STRING
post_code STRING
use_default_payment_term_in_received_invoices INT64
vendor_bank_accounts__vendor_domestic_bank_accounts JSON
vendor_bank_accounts__vendor_foreign_bank_accounts JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: vendors__vendor_acceptance_details

Section titled “Subtable: vendors__vendor_acceptance_details”
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.
acceptance_name STRING
is_default STRING
is_forced STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: vendors__vendor_accounting_accounts

Section titled “Subtable: vendors__vendor_accounting_accounts”
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.
account_name STRING
account_number INT64
is_default 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.
dimension_item STRING
dimension_name STRING
_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 Netvisor 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 Netvisor?

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

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

Section titled “What happens when Netvisor’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 Netvisor, 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 Netvisor 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 Netvisor connector in Kaivo and all of its synced data is deleted with it.

Build profit and loss and balance reporting from your Netvisor ledger data.

Track sales and purchase invoices to monitor receivables, payables, and cash flow.

Join Netvisor financials with sales or CRM data in BigQuery for a full picture.

Report on financials over time to compare months, quarters, and years.

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