Skip to content
Book a demoStart free
Connectors

Fleetio connector

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

Fleetio connector pricing, tier and credits on kaivo.io

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

Sync your Fleetio fleet data into BigQuery with Kaivo to analyse vehicle costs, maintenance, and fuel across your fleet.

CategoryOther
AuthenticationAPI key
SetupSelf-service

Getting started with the Fleetio connector

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

Field Description
API Key
Your Fleetio API key. Find it under Account Settings > API & Webhooks in your Fleetio account.

| | Account Token |

Your Fleetio account token. Find it under Account Settings > API & Webhooks in your Fleetio account.

|

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

contacts (41 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
comments_count FLOAT64
created_at STRING
documents_count FLOAT64
email STRING
employee BOOL
first_name STRING
middle_name STRING
group_id FLOAT64
group_name STRING
group_hierarchy STRING
id FLOAT64
images_count FLOAT64
last_name STRING
name STRING
technician BOOL
updated_at STRING
vehicle_operator BOOL
birth_date STRING
street_address STRING
street_address_line_2 STRING
city STRING
country STRING
employee_number STRING
home_phone_number STRING
job_title STRING
leave_date STRING
license_class STRING
license_plate STRING
license_number STRING
license_state STRING
mobile_phone_number STRING
other_phone_number STRING
postal_code STRING
region STRING
start_date STRING
work_phone_number STRING
hourly_labor_rate_cents FLOAT64
default_image_url STRING
account_membership_id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
expense_entries (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING
expense_entry_type_id FLOAT64
expense_entry_type_name STRING
id FLOAT64
notes STRING
occurred_at STRING
total_amount FLOAT64
total_amount_cents FLOAT64
updated_at STRING
vehicle_id FLOAT64
vehicle_name STRING
vendor_id FLOAT64
vendor_name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
fuel_entries (55 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
comments_count FLOAT64
created_at STRING
date STRING
external_id STRING
fuel_type_id FLOAT64
fuel_type_name STRING
kpl STRING
documents_count FLOAT64
fuel_economy_units_for_current_user STRING
id FLOAT64
images_count FLOAT64
is_sample BOOL
liters STRING
meter_entry__created_at STRING
meter_entry__date STRING
meter_entry__id FLOAT64
meter_entry__meterable_id FLOAT64
meter_entry__meterable_type STRING
meter_entry__updated_at STRING
meter_entry__value STRING
meter_entry__vehicle_id FLOAT64
meter_entry__void BOOL
meter_entry__auto_voided_at STRING
meter_entry__category STRING
meter_entry__meter_type STRING
meter_entry__type STRING
partial BOOL
personal BOOL
price_per_volume_unit STRING
reference STRING
region STRING
reset BOOL
uk_gallons_per_hr STRING
us_gallons_per_hr STRING
usage_in_hr STRING
usage_in_km STRING
usage_in_mi STRING
liters_per_hr STRING
lp100k STRING
mpg_uk STRING
mpg_us STRING
total_amount STRING
total_amount_cents FLOAT64
uk_gallons STRING
updated_at STRING
cost_per_hr STRING
cost_per_km STRING
cost_per_mi STRING
us_gallons STRING
vehicle_id FLOAT64
vehicle_name STRING
vendor_id FLOAT64
watchers_count FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
issues (37 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
asset_type STRING
name STRING
closed_at STRING
closed_by__id FLOAT64
closed_note STRING
comments_count FLOAT64
created_at STRING
creation_type STRING
description STRING
documents_count FLOAT64
due_date STRING
due_meter_value FLOAT64
due_secondary_meter_value STRING
external_id FLOAT64
fault_id FLOAT64
fault__id FLOAT64
id FLOAT64
images_count FLOAT64
number STRING
reported_at STRING
reported_by__id FLOAT64
reported_by__name STRING
reported_by__default_image_url STRING
due_primary_meter_value STRING
overdue BOOL
resolvable_id FLOAT64
resolvable__id FLOAT64
resolvable_type STRING
resolved_at STRING
state STRING
submitted_inspection_form_id FLOAT64
submitted_inspection_form__id FLOAT64
summary STRING
updated_at STRING
watchers_count FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
parts (35 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
comments_count FLOAT64
created_at STRING
default_image_url STRING
default_image_url_large STRING
default_image_url_medium STRING
default_image_url_small STRING
description STRING
documents_count FLOAT64
id FLOAT64
images_count FLOAT64
manufacturer_part_number STRING
measurement_unit_id FLOAT64
measurement_unit_name STRING
number STRING
part_category__id FLOAT64
part_category__tire_category BOOL
part_category__account_id FLOAT64
part_category__default BOOL
part_category__name STRING
part_category__description STRING
part_category__tires_count STRING
part_category__created_at STRING
part_category__updated_at STRING
part_category_id FLOAT64
part_category_name STRING
part_manufacturer_id FLOAT64
part_manufacturer_name STRING
unit_cost FLOAT64
unit_cost_cents STRING
average_unit_cost_cents STRING
upc STRING
archived_at STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
purchase_orders (53 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
approved_at STRING
approved_by STRING
comments_count FLOAT64
created_at STRING
created_by STRING
description STRING
discount FLOAT64
discount_percentage FLOAT64
discount_type STRING
documents_count FLOAT64
id FLOAT64
number FLOAT64
part_location_id FLOAT64
part_location_name STRING
shipping FLOAT64
state STRING
subtotal FLOAT64
tax_1 FLOAT64
tax_1_percentage STRING
tax_1_type STRING
tax_2 FLOAT64
tax_2_percentage STRING
tax_2_type STRING
total_amount FLOAT64
watchers_count STRING
status_name STRING
status_color STRING
submitted_for_approval_at STRING
rejected_at STRING
purchased_at STRING
received_partial_at STRING
received_full_at STRING
closed_at STRING
discount_cents STRING
tax_1_cents STRING
tax_2_cents STRING
subtotal_cents STRING
shipping_cents STRING
total_amount_cents STRING
approved_by_id FLOAT64
created_by_id FLOAT64
closed_by_id FLOAT64
purchased_by_id FLOAT64
rejected_by_id FLOAT64
received_partial_by_id FLOAT64
received_full_by_id FLOAT64
purchase_order_status_id FLOAT64
submitted_for_approval_by_id FLOAT64
updated_at STRING
vendor_id FLOAT64
vendor_name 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.
service_entries (48 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
auto_integrate_repair_order_status STRING
warranty_credits_cents STRING
warranty_credits_percentage STRING
warranty_credits_type STRING
labor_subtotal_cents STRING
parts_subtotal_cents STRING
subtotal_cents STRING
discout_cents STRING
tax_1_cents STRING
tax_2_cents STRING
total_amount_cents STRING
warrant_credits_cents STRING
comments_count FLOAT64
completed_at STRING
created_at STRING
discount FLOAT64
discount_percentage STRING
fees_cents FLOAT64
discount_type STRING
discount_cents STRING
documents_count FLOAT64
general_notes STRING
id FLOAT64
images_count FLOAT64
is_sample BOOL
labor_subtotal FLOAT64
parts_subtotal FLOAT64
reference STRING
started_at STRING
status STRING
tax_1 FLOAT64
tax_1_percentage STRING
tax_1_type STRING
tax_2 FLOAT64
tax_2_percentage STRING
tax_2_type STRING
updated_at STRING
vehicle_id FLOAT64
vendor_id FLOAT64
vendor_name STRING
vmrs_repair_priority_class__code STRING
vmrs_repair_priority_class__color STRING
vmrs_repair_priority_class__id FLOAT64
vmrs_repair_priority_class__name STRING
work_order_id FLOAT64
work_order_number 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.
id FLOAT64
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
submitted_inspection_forms (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date STRING
failed_items FLOAT64
id FLOAT64
inspection_form__description STRING
inspection_form__id FLOAT64
inspection_form__title STRING
started_at STRING
starting_latitude FLOAT64
starting_longitude FLOAT64
submitted_at STRING
submitted_latitude FLOAT64
submitted_longitude FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
vehicle_assignments (21 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
comments_count FLOAT64
contact_full_name STRING
contact_id FLOAT64
started_at STRING
ended_at STRING
contact_image_url STRING
created_at STRING
current BOOL
custom_fields__checkbox_type STRING
custom_fields__department_using_vehicle STRING
custom_fields__license_expiration_date STRING
custom_fields__operator_id STRING
custom_fields__test_restricted_custom_fields STRING
future BOOL
starting_meter_entry_value STRING
ending_meter_entry_value STRING
id FLOAT64
updated_at STRING
vehicle_id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
vehicles (59 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_id FLOAT64
archived_at STRING
fuel_type_id FLOAT64
fuel_type_name STRING
ai_enabled BOOL
assetable_type STRING
color STRING
comments_count FLOAT64
created_at STRING
current_location_entry_id FLOAT64
default_image_url_small STRING
documents_count FLOAT64
estimated_replacement_mileage STRING
estimated_resale_price_cents FLOAT64
estimated_service_months FLOAT64
fuel_entries_count FLOAT64
fuel_volume_units STRING
group_ancestry STRING
group_id FLOAT64
group_name STRING
id FLOAT64
images_count FLOAT64
in_service_date STRING
in_service_meter_value STRING
is_sample BOOL
issues_count FLOAT64
license_plate STRING
make STRING
model STRING
name STRING
out_of_service_date STRING
out_of_service_meter_value STRING
ownership STRING
primary_meter_date STRING
primary_meter_unit STRING
primary_meter_usage_per_day STRING
secondary_meter_unit STRING
secondary_meter_date STRING
primary_meter_value STRING
registration_expiration_month FLOAT64
secondary_meter_usage_per_day STRING
secondary_meter_value STRING
service_entries_count FLOAT64
service_reminders_count FLOAT64
system_of_measurement STRING
trim STRING
registration_state STRING
updated_at STRING
vehicle_renewal_reminders_count FLOAT64
vehicle_status_color STRING
vehicle_status_id FLOAT64
vehicle_status_name STRING
vehicle_type_id FLOAT64
vehicle_type_name STRING
vin STRING
work_orders_count FLOAT64
year 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 Fleetio 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 Fleetio?

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

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

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

Use service_entries and issues to track maintenance cost and vehicle problems over time.

Join expense_entries and fuel_entries with vehicles to find your most expensive assets.

Use submitted_inspection_forms to monitor inspection compliance across the fleet.

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