Skip to content
Book a demoStart free
Connectors

Dolibarr connector

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

Dolibarr connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Dolibarr 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 ERP data instead of moving it.

Sync your Dolibarr ERP data into BigQuery with Kaivo to analyse invoices, customers, and suppliers in one place.

CategoryERP, CRM
AuthenticationAPI key
SetupSelf-service

Getting started with the Dolibarr connector

Section titled “Getting started with the Dolibarr connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Dolibarr 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
Your Dolibarr API key, generated on your user record (Users & Groups → your user → Generate API Key). Requires the REST API / Web Services module to be enabled.

|

When you set up the connector, you provide:

Field Description
Dolibarr URL
Your Dolibarr URL, e.g. https://mydomain.com/dolibarr. If you omit the scheme, https:// is assumed.

| | Start Date |

Any data before this date will not be fetched.

|

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

Company profile data (51 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
address STRING
capital FLOAT64
company_id FLOAT64
country_code STRING
country_id FLOAT64
default_lang STRING
email STRING
entity FLOAT64
fax STRING
id FLOAT64
idprof1 STRING
idprof10 STRING
idprof2 STRING
idprof3 STRING
idprof4 STRING
idprof5 STRING
idprof6 STRING
idprof7 STRING
idprof8 STRING
idprof9 STRING
localtax1_assuj FLOAT64
localtax2_assuj FLOAT64
logo STRING
logo_mini STRING
logo_small STRING
logo_squarred STRING
logo_squarred_mini STRING
logo_squarred_small STRING
managers STRING
module STRING
name STRING
note_private STRING
phone STRING
phone_mobile STRING
socialnetworks__facebook STRING
socialnetworks__instagram STRING
socialnetworks__linkedin STRING
socialobject STRING
specimen FLOAT64
state_id FLOAT64
status FLOAT64
termsofsale STRING
town STRING
tva_assuj FLOAT64
tva_intra STRING
typent_id FLOAT64
url STRING
vat_reverse_charge FLOAT64
zip STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: Company profile data__supplier_categories

Section titled “Subtable: Company profile data__supplier_categories”
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: Company profile data__array_options

Section titled “Subtable: Company profile data__array_options”
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: Company profile data__extraparams

Section titled “Subtable: Company profile data__extraparams”
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: Company profile data__partnerships

Section titled “Subtable: Company profile data__partnerships”
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.
Customer invoices lines list (53 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
date_end STRING
date_start STRING
desc STRING
fk_accounting_account STRING
fk_code_ventilation FLOAT64
fk_multicurrency STRING
fk_parent_attribute STRING
fk_product_type STRING
id STRING
info_bits STRING
invoice_id FLOAT64
localtax1_tx STRING
localtax1_type STRING
localtax2_tx STRING
localtax2_type STRING
marge_tx STRING
marque_tx STRING
multicurrency_code STRING
multicurrency_subprice STRING
multicurrency_total_ht STRING
multicurrency_total_ttc STRING
multicurrency_total_tva STRING
pa_ht STRING
parent_element STRING
product_barcode STRING
product_desc STRING
product_id FLOAT64
product_label STRING
product_ref STRING
product_type STRING
qty STRING
rang STRING
ref STRING
ref_ext STRING
remise_percent STRING
rowid STRING
situation_percent STRING
special_code STRING
specimen FLOAT64
subprice STRING
total_ht STRING
total_localtax1 STRING
total_localtax2 STRING
total_sell_price FLOAT64
total_ttc STRING
total_tva STRING
tva_tx STRING
unit_buy_price FLOAT64
unit_sell_price FLOAT64
vat_src_code STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: Customer invoices lines list__array_options

Section titled “Subtable: Customer invoices lines list__array_options”
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: Customer invoices lines list__extraparams

Section titled “Subtable: Customer invoices lines list__extraparams”
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.
Customer invoices list (58 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
cond_reglement_code STRING
cond_reglement_doc STRING
cond_reglement_id STRING
customer_id FLOAT64
date FLOAT64
date_creation FLOAT64
date_lim_reglement FLOAT64
date_modification FLOAT64
date_pointoftax STRING
date_validation FLOAT64
datem FLOAT64
entity STRING
fk_account STRING
fk_facture_source STRING
fk_incoterms STRING
fk_multicurrency STRING
fk_user_author STRING
fk_user_valid STRING
id STRING
invoice_id FLOAT64
last_main_doc STRING
location_incoterms STRING
mode_reglement_code STRING
mode_reglement_id STRING
module_source STRING
multicurrency_code STRING
multicurrency_total_ht STRING
multicurrency_total_ttc STRING
multicurrency_total_tva STRING
multicurrency_tx STRING
online_payment_url STRING
paye STRING
pos_source STRING
ref STRING
remaintopay STRING
retained_warranty STRING
retained_warranty_date_limit STRING
retained_warranty_fk_cond_reglement STRING
revenuestamp STRING
situation_final STRING
socid STRING
specimen FLOAT64
status STRING
statut STRING
sumcreditnote STRING
sumpayed STRING
total_ht STRING
total_localtax1 STRING
total_localtax2 STRING
total_ttc STRING
total_tva STRING
totalcreditnotes STRING
totalpaid FLOAT64
user_creation_id STRING
user_validation_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: Customer invoices list__array_options

Section titled “Subtable: Customer invoices list__array_options”
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: Customer invoices list__contacts_ids

Section titled “Subtable: Customer invoices list__contacts_ids”
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: Customer invoices list__extraparams

Section titled “Subtable: Customer invoices list__extraparams”
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: Customer invoices list__tab_next_situation_invoice

Section titled “Subtable: Customer invoices list__tab_next_situation_invoice”
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: Customer invoices list__tab_previous_situation_invoice

Section titled “Subtable: Customer invoices list__tab_previous_situation_invoice”
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.
Customer invoices payments list (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
amount STRING
date STRING
fk_bank_line STRING
invoice_id FLOAT64
num STRING
ref STRING
ref_ext STRING
typeline STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Customers list (58 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
accountancy_code_buy STRING
accountancy_code_sell STRING
address STRING
client STRING
code_client STRING
code_fournisseur STRING
country_code STRING
country_id STRING
customer_id FLOAT64
date_creation FLOAT64
date_modification FLOAT64
effectif STRING
email STRING
entity STRING
fax STRING
fk_account STRING
fk_incoterms STRING
fk_multicurrency STRING
fk_prospectlevel STRING
fk_warehouse STRING
forme_juridique STRING
fournisseur STRING
id STRING
idprof1 STRING
idprof2 STRING
idprof3 STRING
idprof4 STRING
idprof5 STRING
idprof6 STRING
localtax1_value STRING
localtax2_value STRING
module STRING
multicurrency_code STRING
name STRING
name_alias STRING
phone STRING
prospect FLOAT64
ref STRING
region_id STRING
remise_percent FLOAT64
remise_supplier_percent STRING
specimen FLOAT64
state_id STRING
status STRING
status_prospect_label STRING
stcomm_id STRING
town STRING
tva_assuj STRING
tva_intra STRING
typent_code STRING
typent_id STRING
url STRING
user_creation_id STRING
user_modification_id STRING
vat_reverse_charge FLOAT64
zip STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: Customers list__supplier_categories

Section titled “Subtable: Customers list__supplier_categories”
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.
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.
Internal Users (51 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
accountancy_code STRING
accountancy_code_user_general STRING
address STRING
admin STRING
birth STRING
civility_code STRING
color STRING
country_code STRING
country_id STRING
datec FLOAT64
dateemployment STRING
dateemploymentend STRING
dateendvalidity STRING
datelastlogin STRING
datem FLOAT64
datepreviouslogin STRING
datestartvalidity STRING
email STRING
employee STRING
entity STRING
firstname STRING
fk_establishment STRING
fk_user STRING
flagdelsessionsbefore STRING
gender STRING
id STRING
iplastlogin STRING
ippreviouslogin STRING
job STRING
lastname STRING
login STRING
national_registration_number STRING
note_private STRING
note_public STRING
office_fax STRING
office_phone STRING
personal_email STRING
personal_mobile STRING
ref STRING
ref_employee STRING
signature STRING
specimen FLOAT64
state_id STRING
status STRING
statut STRING
town STRING
user_id FLOAT64
user_mobile STRING
zip 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.
Product categories list (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
category_id FLOAT64
color STRING
date_creation FLOAT64
date_modification FLOAT64
entity FLOAT64
fk_parent FLOAT64
id STRING
label STRING
position STRING
specimen FLOAT64
user_creation_id FLOAT64
user_modification_id FLOAT64
visible FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: Product categories list__array_options

Section titled “Subtable: Product categories list__array_options”
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.

Subtable: Product categories list__extraparams

Section titled “Subtable: Product categories list__extraparams”
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: Product categories list__multilangs

Section titled “Subtable: Product categories list__multilangs”
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 category id list (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
category_id FLOAT64
fk_parent FLOAT64
id STRING
product_id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: Products category id list__array_options

Section titled “Subtable: Products category id list__array_options”
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 list (63 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
accountancy_code_buy STRING
accountancy_code_buy_export STRING
accountancy_code_buy_intra STRING
accountancy_code_sell STRING
accountancy_code_sell_export STRING
accountancy_code_sell_intra STRING
barcode STRING
barcode_type STRING
batch_mask STRING
canvas STRING
cost_price STRING
country_code STRING
customcode STRING
date_creation STRING
date_modification FLOAT64
desiredstock STRING
duration STRING
duration_value FLOAT64
entity STRING
finished STRING
fk_default_warehouse STRING
height_units STRING
id STRING
import_key STRING
label STRING
length_units STRING
localtax1_tx STRING
localtax1_type STRING
localtax2_tx STRING
localtax2_type STRING
mandatory_period STRING
note_private STRING
pmp STRING
price STRING
price_autogen STRING
price_base_type STRING
price_min STRING
price_min_ttc STRING
price_ttc STRING
product_id FLOAT64
ref STRING
sell_or_eat_by_mandatory STRING
seuil_stock_alerte STRING
specimen FLOAT64
stats_expedition__customers STRING
stats_expedition__nb STRING
stats_expedition__qty FLOAT64
stats_expedition__rows STRING
status STRING
status_batch STRING
status_buy STRING
stock_reel FLOAT64
stock_theorique FLOAT64
stock_warehouse JSON
surface_units STRING
tva_tx STRING
volume_units STRING
weight_units STRING
width_units 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.

Subtable: Products list__multiprices_base_type

Section titled “Subtable: Products list__multiprices_base_type”
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: Products list__multiprices_default_vat_code

Section titled “Subtable: Products list__multiprices_default_vat_code”
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.

Subtable: Products list__multiprices_min_ttc

Section titled “Subtable: Products list__multiprices_min_ttc”
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.

Subtable: Products list__multiprices_tva_tx

Section titled “Subtable: Products list__multiprices_tva_tx”
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.

Subtable: Products list__prices_by_qty_list

Section titled “Subtable: Products list__prices_by_qty_list”
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.

Subtable: Products list__stats_facture_fournisseur

Section titled “Subtable: Products list__stats_facture_fournisseur”
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.

Subtable: Products list__stats_proposal_supplier

Section titled “Subtable: Products list__stats_proposal_supplier”
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.
Supplier invoices lines list (44 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
buy_unit_price FLOAT64
desc STRING
fk_accounting_account STRING
fk_facture_fourn STRING
fk_multicurrency STRING
fk_product STRING
id STRING
info_bits STRING
localtax1_tx STRING
localtax1_type STRING
localtax2_tx STRING
localtax2_type STRING
multicurrency_code STRING
multicurrency_subprice STRING
multicurrency_total_ht STRING
multicurrency_total_ttc STRING
multicurrency_total_tva STRING
product_barcode STRING
product_desc STRING
product_id FLOAT64
product_label STRING
product_ref STRING
product_type STRING
pu_ht STRING
pu_ttc STRING
qty STRING
rang STRING
ref_supplier STRING
remise_percent STRING
special_code STRING
specimen FLOAT64
subprice STRING
supp_invoice_id FLOAT64
total_buy_price FLOAT64
total_ht STRING
total_localtax1 STRING
total_localtax2 STRING
total_ttc STRING
total_tva STRING
tva_tx STRING
vat_src_code STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: Supplier invoices lines list__array_options

Section titled “Subtable: Supplier invoices lines list__array_options”
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: Supplier invoices lines list__extraparams

Section titled “Subtable: Supplier invoices lines list__extraparams”
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.
Supplier invoices list (55 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
amount FLOAT64
close_code STRING
close_note STRING
cond_reglement_code STRING
cond_reglement_doc STRING
cond_reglement_id STRING
cond_reglement_label STRING
date FLOAT64
date_echeance STRING
datec FLOAT64
entity STRING
fk_account STRING
fk_facture_source STRING
fk_incoterms STRING
fk_multicurrency STRING
fk_statut STRING
id STRING
label STRING
last_main_doc STRING
libelle STRING
location_incoterms STRING
mode_reglement_code STRING
mode_reglement_id STRING
multicurrency_code STRING
multicurrency_total_ht STRING
multicurrency_total_ttc STRING
multicurrency_total_tva STRING
multicurrency_tx STRING
note_private STRING
note_public STRING
paid STRING
paye STRING
ref STRING
ref_ext STRING
ref_supplier STRING
remise FLOAT64
socid STRING
specimen FLOAT64
status STRING
statut STRING
subtype FLOAT64
supp_invoice_id FLOAT64
supplier_id FLOAT64
tms FLOAT64
total_ht STRING
total_localtax1 STRING
total_localtax2 STRING
total_ttc STRING
total_tva STRING
user_creation_id STRING
user_validation_id STRING
vat_reverse_charge FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: Supplier invoices list__array_options

Section titled “Subtable: Supplier invoices list__array_options”
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: Supplier invoices list__extraparams

Section titled “Subtable: Supplier invoices list__extraparams”
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.
Supplier invoices payments list (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
amount STRING
date STRING
fk_bank_line STRING
num STRING
ref STRING
supp_invoice_id FLOAT64
typeline STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Suppliers list (57 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
accountancy_code_buy STRING
accountancy_code_sell STRING
address STRING
client STRING
code_fournisseur STRING
country_code STRING
country_id STRING
date_creation FLOAT64
date_modification FLOAT64
effectif STRING
email STRING
entity STRING
fax STRING
fk_account STRING
fk_incoterms STRING
fk_multicurrency STRING
fk_prospectlevel STRING
fk_warehouse STRING
forme_juridique STRING
fournisseur STRING
id STRING
idprof1 STRING
idprof2 STRING
idprof3 STRING
idprof4 STRING
idprof5 STRING
idprof6 STRING
localtax1_value STRING
localtax2_value STRING
module STRING
multicurrency_code STRING
name STRING
name_alias STRING
phone STRING
prospect FLOAT64
ref STRING
region_id STRING
remise_percent FLOAT64
remise_supplier_percent STRING
specimen FLOAT64
state_id STRING
status STRING
status_prospect_label STRING
stcomm_id STRING
supplier_id FLOAT64
town STRING
tva_assuj STRING
tva_intra STRING
typent_code STRING
typent_id STRING
url STRING
user_creation_id STRING
user_modification_id STRING
vat_reverse_charge FLOAT64
zip STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: Suppliers list__supplier_categories

Section titled “Subtable: Suppliers list__supplier_categories”
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.
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 Dolibarr 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 Dolibarr?

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

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

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

Use customer invoices and lines to track revenue and what sells over time.

Join supplier invoices with payments to monitor what you owe and when.

Use customers and suppliers to understand your trading relationships.

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