Skip to content
Book a demoStart free
Connectors

TriNet Zenefits connector

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

TriNet Zenefits connector pricing, tier and credits on kaivo.io

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

Sync your TriNet Zenefits HR data into BigQuery with Kaivo to report on headcount, time off, and people data without exporting spreadsheets.

CategoryHR
AuthenticationAPI key
SetupSelf-service

Getting started with the TriNet Zenefits connector

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

Field Description
API Token
Your Zenefits API access token. In Zenefits, go to Settings > Integration and API Access to generate one.

|

Tables and columns synced from TriNet Zenefits

Section titled “Tables and columns synced from TriNet Zenefits”

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

custom_field_values (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING Unique identifier for the custom field value
url STRING URL for the custom field value
object STRING Object type of the custom field value
value STRING The actual value of the custom field
custom_field__ref_object STRING Reference to another object
custom_field__object STRING The type of object
custom_field__url STRING URL for the custom field
person__ref_object STRING Reference to another person object
person__object STRING The type of person object
person__url STRING URL for the person
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
custom_fields (25 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING Unique identifier for the custom field.
can_manager_view_field BOOL Indicates whether a manager is allowed to view this custom field.
custom_field_values__ref_object STRING Reference to the object representing the custom field values.
custom_field_values__object STRING Type of object representing the custom field values.
custom_field_values__url STRING URL linking to the custom field values.
person_during_onboarding BOOL Person information during the onboarding process.
name STRING Name or label of the custom field.
is_field_completer_person BOOL Indicates whether this field is meant to be completed by a person.
url STRING URL linking to the custom field information.
is_sensitive BOOL Indicates whether the information in this field is sensitive.
is_field_required BOOL Indicates whether this field is required to be filled.
object STRING Type of object representing the custom field.
can_person_view_field BOOL Indicates whether a person is allowed to view this custom field.
can_person_edit_field BOOL Indicates whether a person is allowed to edit this custom field.
company__ref_object STRING Reference to the object representing the company.
company__object STRING Type of object representing the company.
company__url STRING URL linking to the company information.
company_during_hiring BOOL Company information during the hiring process.
custom_field_type STRING Type of the custom field.
help_url STRING URL linking to additional help related to the custom field.
help_text STRING Text providing help or guidance related to the custom field.
help_url_media STRING Media content such as images or videos providing help or guidance.
media_file_type JSON Type of media file associated with the custom field.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
departments (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING The unique identifier for the department
name STRING The name of the department
labor_group__ref_object STRING
labor_group__object STRING
labor_group__url STRING
people__ref_object STRING
people__object STRING
people__url STRING
company__ref_object STRING
company__object STRING
company__url STRING
url STRING The URL for accessing more details about the department
object STRING The type of object, in this case, department
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
employments (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
person__url STRING URL to fetch detailed information about the person
person__object STRING Type of object (e.g., person)
person__ref_object STRING Reference to the person associated with this employment
hire_date STRING Date on which the employee was hired for this employment
amount_type STRING Type of amount associated with employment data (e.g., hourly, monthly)
annual_salary STRING The annual salary of the employee in this employment
comp_type STRING Type of compensation for the employment (e.g., salary, hourly wage)
pay_rate STRING Rate of pay for the employee in this employment
employment_type STRING Main type of employment of the employee (e.g., permanent, temporary)
object STRING Type of object (e.g., employment)
is_active BOOL Flag indicating if the employment record is currently active
is_flsa_exempt STRING Flag indicating if the employee is exempt from Fair Labor Standards Act (FLSA)
termination_type STRING Type of termination for this employment (e.g., voluntary, involuntary)
termination_date STRING Date on which the employment was terminated
url STRING URL to fetch detailed information about this employment record
id STRING Unique identifier for the employment record
working_hours_per_week STRING Number of working hours per week for the employee
employment_sub_type STRING Subtype of the employment type (e.g., full-time, part-time)
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
labor_group_types (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING The unique identifier of the labor group type.
name STRING The name of the labor group type.
url STRING The URL for retrieving more details about the labor group type.
company__ref_object STRING
company__object STRING
company__url STRING
labor_groups__ref_object STRING
labor_groups__object STRING
labor_groups__url STRING
object STRING The type of object, in this case, labor group type.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
labor_groups (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING Unique identifier for the labor group
code STRING Unique code assigned to the labor group
name STRING Name of the labor group
url STRING URL to fetch labor group details
object STRING Object representing the labor group
labor_group_type__ref_object STRING Reference object linked to the labor group type
labor_group_type__object STRING Object representing the labor group type
labor_group_type__url STRING URL to fetch the labor group type details
assigned_members__url STRING URL to fetch assigned members data
assigned_members__next_url STRING URL to fetch the next set of assigned members data
assigned_members__object STRING Object representing the assigned members
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: labor_groups__assigned_members__data

Section titled “Subtable: labor_groups__assigned_members__data”
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.
url STRING URL link associated with the member.
is_primary BOOL Indicates if the member is the primary member of the labor group
object STRING Object metadata.
ref_object STRING Reference to another object.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
locations (22 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING Unique identifier for the location.
name STRING The name of the location.
city STRING The city where the location is situated.
labor_group__ref_object STRING Reference to another object related to the labor group.
labor_group__object STRING Defines the labor group object.
labor_group__url STRING URL linking to additional information about the labor group.
zip STRING The ZIP or postal code of the location.
people__ref_object STRING Reference to another object related to the people at the location.
people__object STRING Defines the people object.
people__url STRING URL linking to additional information about the people at the location.
url STRING URL linking to additional information about the location.
street1 STRING First line of the street address for the location.
street2 STRING Second line of the street address for the location.
object STRING Defines the location object.
phone STRING Contact phone number for the location.
state STRING The state or region where the location is situated.
country STRING The country where the location is located.
company__ref_object STRING Reference to another object related to the company.
company__object STRING Defines the company object.
company__url STRING URL linking to additional information about the company.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
people (59 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
employee_number STRING Unique employee identification number
country STRING Country where the person is located
labor_groups__ref_object STRING
labor_groups__object STRING
labor_groups__url STRING
is_admin BOOL Flag indicating if the person is an admin user
object STRING Represents an individual person’s data
street1 STRING First line of the person’s address
company__ref_object STRING
company__object STRING
company__url STRING
department__ref_object STRING
department__object STRING
department__url STRING
subordinates__ref_object STRING
subordinates__object STRING
subordinates__url STRING
location__ref_object STRING
location__object STRING
location__url STRING
work_phone STRING Work phone number of the person
middle_name STRING Middle name of the person
custom_field_values__ref_object STRING
custom_field_values__object STRING
custom_field_values__url STRING
postal_code STRING Postal code of the person’s address
employments__ref_object STRING
employments__object STRING
employments__url STRING
manager__ref_object STRING
manager__object STRING
manager__url STRING
banks__ref_object STRING
banks__object STRING
banks__url STRING
date_of_birth STRING Date of birth of the person
status STRING Status of the person (active, inactive, etc.)
federal_filing_status STRING Federal filing status for tax purposes
gender STRING Gender of the person
personal_email STRING Personal email address of the person
personal_phone STRING Personal phone number of the person
personal_pronoun STRING Preferred personal pronoun of the person
photo_thumbnail_url STRING URL to the thumbnail version of the person’s photo
photo_url STRING URL to the full version of the person’s photo
social_security_number STRING Social security number of the person
is_full_admin BOOL Flag indicating if the person is a full admin user
last_name STRING Last name of the person
first_name STRING First name of the person
state STRING State or region where the person is located
title STRING Job title of the person
url STRING URL endpoint for accessing the person’s details
street2 STRING Second line of the person’s address
work_email STRING Work email address of the person
preferred_name STRING Preferred name used by the person
id STRING Unique identifier for the person
type STRING Type of person (employee, contractor, etc.)
city STRING City where the person is located
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
time_durations (22 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
is_overnight BOOL Flag indicating if the time duration spans across multiple days.
is_approved BOOL Flag indicating whether the time duration is approved.
object STRING Type of the time duration object.
end TIMESTAMP End date and time of the time duration.
person__ref_object STRING Reference object for the person.
person__object STRING Type of the person object associated with the time duration.
person__url STRING URL to fetch more details about the person.
url STRING URL to access the details of the time duration.
approver__ref_object STRING Reference object for the approver.
approver__object STRING Type of the approver object.
approver__url STRING URL to fetch more details about the approver.
labor_group_ids STRING IDs of labor groups associated with the time duration.
hours STRING The total number of hours worked during the time duration.
start STRING Start date and time of the time duration.
state STRING State of the time duration (e.g., pending, approved, rejected).
approved_datetime STRING The date and time the time duration was approved.
valid_status STRING Status indicating the validity of the time duration data.
date STRING The date for which the time duration is recorded.
activity STRING The type of activity or task performed during the time duration.
id STRING Unique identifier for the time duration record.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
vacation_requests (22 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
status STRING Status of the vacation request (approved, pending, denied).
vacation_type__url STRING URL linking to the vacation type details.
vacation_type__object STRING Indicator for the object type.
vacation_type__ref_object STRING Reference to the vacation type object.
end_date STRING The end date of the vacation period.
creator__url STRING URL linking to the creator’s details.
creator__object STRING Indicator for the object type.
creator__ref_object STRING Reference to the creator object.
url STRING URL linking to the vacation request details.
object STRING Indicator for the object type.
start_date STRING The start date of the vacation period.
hours STRING Number of hours requested for vacation.
approved_date STRING The date when the vacation request was approved.
reason STRING Reason provided for the vacation request.
person__url STRING URL linking to the person’s details.
person__object STRING Indicator for the object type.
person__ref_object STRING Reference to the person object.
created_date STRING The date when the vacation request was created.
deny_reason STRING Reason for denying the vacation request.
id STRING Unique identifier for the vacation request.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
vacation_types (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
status STRING Status of the vacation type
name STRING Name of the vacation type
url STRING URL linking to the vacation type details
counts_as STRING How this vacation type counts in the system
company__url STRING URL linking to the company information
company__object STRING Company object details
company__ref_object STRING Reference to the company object
object STRING Object details related to the vacation type
vacation_requests__url STRING URL linking to the vacation requests associated
vacation_requests__object STRING Vacation requests object details
vacation_requests__ref_object STRING Reference to the vacation requests object
count_as STRING How this vacation type is counted as
id STRING Unique identifier for the vacation type
_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 TriNet Zenefits 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 TriNet Zenefits?

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

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

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

Use people and employments to track headcount and changes over time.

Join vacation_requests with vacation_types to see leave trends and coverage.

Use departments and locations to report on your workforce by team and site.

Use TriNet Zenefits data in your AI and BI tools

Section titled “Use TriNet Zenefits data in your AI and BI tools”

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