Skip to content
Book a demoStart free
Connectors

EasyPost connector

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

EasyPost connector pricing, tier and credits on kaivo.io

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

Sync your EasyPost shipping data into BigQuery with Kaivo to analyse shipments, tracking, and carrier performance.

CategoryE-commerce
AuthenticationAPI key
SetupSelf-service

Getting started with the EasyPost connector

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

|

When you set up the connector, you provide:

Field Description
Start Date
Any data before this date will not be fetched.

|

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

addresses (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
city STRING
company STRING
country STRING
created_at STRING
email STRING
id STRING
mode STRING
name STRING
object STRING
phone STRING
state STRING
street1 STRING
street2 STRING
updated_at STRING
zip STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
api_keys (3 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id 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.
id 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.
active BOOL
created_at STRING
id STRING
key STRING
mode STRING
object 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.
active BOOL
created_at STRING
id STRING
key STRING
mode STRING
object STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
batches (45 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING
id STRING
mode STRING
num_shipments FLOAT64
object STRING
pickup__address__city STRING
pickup__address__company STRING
pickup__address__country STRING
pickup__address__created_at STRING
pickup__address__id STRING
pickup__address__mode STRING
pickup__address__object STRING
pickup__address__phone STRING
pickup__address__state STRING
pickup__address__street1 STRING
pickup__address__street2 STRING
pickup__address__updated_at STRING
pickup__address__zip STRING
pickup__created_at STRING
pickup__id STRING
pickup__instructions STRING
pickup__is_account_address BOOL
pickup__max_datetime STRING
pickup__min_datetime STRING
pickup__mode STRING
pickup__object STRING
pickup__reference STRING
pickup__status STRING
pickup__updated_at STRING
scan_form__batch_id STRING
scan_form__created_at STRING
scan_form__id STRING
scan_form__message STRING
scan_form__object STRING
scan_form__status STRING
scan_form__updated_at STRING
state STRING
status__created FLOAT64
status__creation_failed FLOAT64
status__postage_purchase_failed FLOAT64
status__postage_purchased FLOAT64
status__queued_for_purchase FLOAT64
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: batches__pickup__carrier_accounts

Section titled “Subtable: batches__pickup__carrier_accounts”
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: batches__scan_form__tracking_codes

Section titled “Subtable: batches__scan_form__tracking_codes”
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.
batch_status STRING
id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
carrier_accounts (41 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
billing_type STRING
clone BOOL
created_at STRING
credentials__address_city STRING
credentials__address_state STRING
credentials__address_street STRING
credentials__address_zip STRING
credentials__company_name STRING
credentials__phone STRING
credentials__shipper_id STRING
fields__credentials__address_city__label STRING
fields__credentials__address_city__value STRING
fields__credentials__address_city__visibility STRING
fields__credentials__address_state__label STRING
fields__credentials__address_state__value STRING
fields__credentials__address_state__visibility STRING
fields__credentials__address_street__label STRING
fields__credentials__address_street__value STRING
fields__credentials__address_street__visibility STRING
fields__credentials__address_zip__label STRING
fields__credentials__address_zip__value STRING
fields__credentials__address_zip__visibility STRING
fields__credentials__company_name__label STRING
fields__credentials__company_name__value STRING
fields__credentials__company_name__visibility STRING
fields__credentials__email__label STRING
fields__credentials__email__visibility STRING
fields__credentials__phone__label STRING
fields__credentials__phone__value STRING
fields__credentials__phone__visibility STRING
fields__credentials__shipper_id__label STRING
fields__credentials__shipper_id__value STRING
fields__credentials__shipper_id__visibility STRING
id STRING
object STRING
readable STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
end_shippers (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
city STRING
company STRING
country STRING
created_at STRING
email STRING
id STRING
mode STRING
name STRING
object STRING
phone STRING
state STRING
street1 STRING
updated_at STRING
zip STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
metadata_carriers (4 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
human_readable STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: metadata_carriers__predefined_packages

Section titled “Subtable: metadata_carriers__predefined_packages”
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.
description STRING
carrier STRING
human_readable STRING
max_weight FLOAT64
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: metadata_carriers__predefined_packages__dimensions

Section titled “Subtable: metadata_carriers__predefined_packages__dimensions”
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 STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: metadata_carriers__service_levels

Section titled “Subtable: metadata_carriers__service_levels”
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.
description STRING
carrier STRING
human_readable STRING
max_weight FLOAT64
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: metadata_carriers__service_levels__dimensions

Section titled “Subtable: metadata_carriers__service_levels__dimensions”
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 STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: metadata_carriers__shipment_options

Section titled “Subtable: metadata_carriers__shipment_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.
type STRING
carrier STRING
deprecated BOOL
human_readable STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: metadata_carriers__supported_features

Section titled “Subtable: metadata_carriers__supported_features”
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.
description STRING
carrier STRING
name STRING
supported BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
trackers (21 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
carrier STRING
carrier_detail__destination_location STRING
carrier_detail__object STRING
carrier_detail__origin_location STRING
carrier_detail__origin_tracking_location__city STRING
carrier_detail__origin_tracking_location__object STRING
carrier_detail__origin_tracking_location__state STRING
carrier_detail__origin_tracking_location__zip STRING
carrier_detail__service STRING
created_at STRING
est_delivery_date STRING
id STRING
mode STRING
object STRING
public_url STRING
status STRING
status_detail STRING
tracking_code STRING
updated_at 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.
type STRING
amount STRING
charged BOOL
object STRING
refunded BOOL
_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.
description STRING
carrier_code STRING
datetime STRING
message STRING
object STRING
source STRING
status STRING
status_detail STRING
tracking_location__city STRING
tracking_location__object STRING
tracking_location__state STRING
tracking_location__zip STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
users_children (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING
id STRING
name STRING
object STRING
parent_id STRING
phone_number STRING
verified BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
webhooks (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING
id STRING
mode STRING
object STRING
url STRING
_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 EasyPost 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 EasyPost?

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

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

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

Use trackers and batches to track shipment volume over time.

Join carrier_accounts with trackers to compare delivery speed across carriers.

Use addresses and end_shippers to analyse where shipments go.

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