Fleetio

Fleetio is a fleet management platform for tracking vehicles and equipment, fuel and charging, service and maintenance, work orders, inspections, parts inventory and purchase orders. Replicating Fleetio into your warehouse lets analytics teams report on fleet cost, utilization and maintenance history alongside the rest of your business data.

Setup Instructions

Follow the setup steps guide for configuring your Fleetio connection to enable data to flow into your destination via DLH.

Supported Features

Here are key features supported for this connector.

Sync Feature	Supported	Details
Custom Data and Development	✓	Ability to enhance connector upon request
Historical Re-Load/Load	✓
Incremental/Delta Load	✓	Gets records created or changed since the previous sync
Column Selection	✓
Column Hashing	✓
Re-Sync Table/Entity	✓	Select at the table level to reload data history (on next Sync Bridge run)
Custom Queries		Utilizing SQL Data Query Connector
Custom Data
Captures Deleted Rows
API Sync Bridge Initiation	✓
Priority Scheduling	✓
Private VPC/Link	☂
DLH Data Model Available	-

If you have any questions about these supported features please reach out to our Customer Support team.

Details on Sync Processing

The first synchronization pulls your full Fleetio history. Every later synchronization pulls only the records created or changed since the previous one. Some reference tables (for example labels, archived vendors and archived parts) are reloaded in full. Fleetio limits how many API requests an account can make each minute based on your plan, so a large first synchronization may take some time. DLH.io automatically paces requests and pauses and resumes when the limit is reached. Some Fleetio features, such as equipment and purchase orders, depend on your Fleetio plan; tables for features your plan does not include are created empty and noted in the sync history. The connection is read only.

Be sure to also check the change log and notes page from time to time for any changes.

Issue Handling

If any issues occur with the connection simply return to the sources page in DLH.io, edit the source details and click the Save & Test button to confirm connectivity. If any issues persist please contact our support team via the DLH.io Support Portal.

Replicated Entities

The following 49 entities are replicated by default to your Target Connection. These are the table names you will see in your Target Connection. If you believe any entities/tables are missing please open a ticket with Customer Support:

ACCOUNTS
VEHICLES
VEHICLE_ASSIGNMENTS
VEHICLE_STATUS_CHANGES
VEHICLE_TYPES
VEHICLE_STATUSES
FUEL_TYPES
GROUPS
LABELS
CUSTOM_FIELDS
EQUIPMENT
EQUIPMENT_TYPES
EQUIPMENT_STATUSES
METER_ENTRIES
FUEL_ENTRIES
CHARGING_ENTRIES
EXPENSE_ENTRIES
EXPENSE_ENTRY_TYPES
FAULTS
PLACES
SERVICE_ENTRIES
SERVICE_ENTRY_LINE_ITEMS
SERVICE_TASKS
SERVICE_REMINDERS
ISSUES
ISSUE_PRIORITIES
WORK_ORDERS
WORK_ORDER_LINE_ITEMS
WORK_ORDER_STATUSES
VMRS_REASON_FOR_REPAIRS
CONTACTS
VENDORS
CONTACT_RENEWAL_REMINDERS
CONTACT_RENEWAL_TYPES
VEHICLE_RENEWAL_REMINDERS
VEHICLE_RENEWAL_TYPES
INSPECTION_FORMS
INSPECTION_SCHEDULES
SUBMITTED_INSPECTION_FORMS
COMMENTS
PARTS
PART_LOCATIONS
PART_LOCATION_DETAILS
INVENTORY_JOURNAL_ENTRIES
INVENTORY_ADJUSTMENT_REASONS
PURCHASE_ORDERS
PURCHASE_ORDER_LINE_ITEMS
PURCHASE_DETAILS
ACQUISITIONS

Schema Details (ER Diagram)

This entity relationship diagram (ERD) provides you with information about what entities/tables DLH provides for you out-of-the-box and how they are related to one another.