TriNet Zenefits connector

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

Written By Lauri Raivio

Last updated 16 days ago

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.

What is the TriNet Zenefits connector

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

Category	HR
Authentication	API key
Setup	Self-service

Getting started with the TriNet Zenefits connector

Sign up for Kaivo and create a workspace.
Connect your TriNet Zenefits account.
Choose which tables to sync.
Wait for the initial sync to finish.
Query your data in BigQuery or your favourite AI or BI tool.

Authenticating TriNet Zenefits

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

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

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.

How the TriNet Zenefits sync works

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.

Frequently asked questions

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.

Can I sync only some tables or columns?

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?

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.

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.

Common use cases for TriNet Zenefits data

Headcount reporting

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

Time off analysis

Join vacation_requests with vacation_types to see leave trends and coverage.

Org view

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

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.

Claude

Use Kaivo's MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Power BI

Microsoft's BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Data Studio

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

Tableau

The premium analytics standard, with native BigQuery integration. Setup guide →

Google Sheets

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Excel

Connect via Power Query's BigQuery connector. Setup guide →

Metabase

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for TriNet Zenefits connector pricing and plan details.

Greenhouse: Sync Greenhouse to BigQuery.
Kellokortti: Sync Kellokortti to BigQuery.
Nepton: Sync Nepton to BigQuery.
Teamtailor: Sync Teamtailor to BigQuery.
7shifts: Sync 7shifts to BigQuery.
Ashby: Sync Ashby to BigQuery.

Was this helpful?

Still need help? Share an idea