Flexport connector

Set up the Flexport connector in Kaivo: authentication, configuration, the 5 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 Flexport 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.

What is the Flexport connector

Sync your Flexport logistics data into BigQuery with Kaivo to analyse shipments, invoices, and freight cost.

Category	E-commerce
Authentication	API key
Setup	Self-service

Getting started with the Flexport connector

Sign up for Kaivo and create a workspace.
Connect your Flexport 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 Flexport

Authenticate with your API Key.

Field	Description
API Key

Configuring the Flexport connector

When you set up the connector, you provide:

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

Tables and columns synced from Flexport

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

companies (13 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`_object`	`STRING`	String representing the object's type. Always /network/company for this object.
`id`	`STRING`	Unique identifier for the object.
`name`	`STRING`	Name of the company.
`ref`	`STRING`	Your ref for this company entity, as set in the Network tab.
`editable`	`BOOL`	Whether or not you manage this company and can edit its attributes.
`locations___object`	`STRING`	String representing the object's type. Always /api/refs/collection for this object.
`locations__link`	`STRING`	API end point that points to a list of resources
`locations__ref_type`	`STRING`	The _object value of each individual element of the list that link points to.
`contacts___object`	`STRING`	String representing the object's type. Always /api/refs/collection for this object.
`contacts__link`	`STRING`	API end point that points to a list of resources
`contacts__ref_type`	`STRING`	The _object value of each individual element of the list that link points to.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: companies__entities

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.
`_object`	`STRING`	String representing the object's type. Always /company_entity for this object.
`id`	`INT64`	Unique identifier for the object.
`name`	`STRING`	Name of the company entity.
`ref`	`STRING`	Your reference for this company entity, as set in the Network tab.
`mailing_address`	`JSON`	Address of the company entity.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: companiesentitiesvat_numbers

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.
`_object`	`STRING`	String representing the object's type. Always /company_entity/vat_number for this object.
`country_code`	`STRING`	ISO 3166 two-letter country code of the VAT number's country
`number`	`STRING`	Full VAT number, including the country code
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

invoices (30 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`_object`	`STRING`	Type of the object. Always /invoice for this object.
`id`	`STRING`	Unique ID for the invoice
`name`	`STRING`	Unique name for the invoice
`issued_at`	`TIMESTAMP`	When the invoice was issued. In ISO8601 UTC format with timezone denoted by Z.
`due_date`	`DATE`	Due date of the invoice. Calendar date only, no time.
`total___object`	`STRING`	String representing the object's type. Always /money for this object.
`total__amount`	`STRING`	A string representing the decimal amount
`total__currency_code`	`STRING`	The currency of the amount
`balance___object`	`STRING`	String representing the object's type. Always /money for this object.
`balance__amount`	`STRING`	A string representing the decimal amount
`balance__currency_code`	`STRING`	The currency of the amount
`status`	`STRING`	Status of the invoice. One of:
`type`	`STRING`	What the invoice is being issued for. Shipment related charges are type Shipment and non-shipment related charges are type Client
`voided_at`	`TIMESTAMP`	When the invoice was voided (if applicable). In ISO8601 UTC format with timezone denoted by Z.
`last_updated_at`	`TIMESTAMP`	Time of the last adjustment to in invoice. In ISO8601 UTC format with timezone denoted by Z.
`recipient___object`	`STRING`	String representing the object's type. Always /company_entity for this object.
`recipient__id`	`INT64`	Unique identifier for the object.
`recipient__name`	`STRING`	Name of the company entity.
`recipient__ref`	`STRING`	Your reference for this company entity, as set in the Network tab.
`recipient__mailing_address`	`JSON`	Address of the company entity.
`issuer___object`	`STRING`	String representing the object's type. Always /company_entity for this object.
`issuer__id`	`INT64`	Unique identifier for the object.
`issuer__name`	`STRING`	Name of the company entity.
`issuer__ref`	`STRING`	Your reference for this company entity, as set in the Network tab.
`issuer__mailing_address`	`JSON`	Address of the company entity.
`shipments___object`	`STRING`	String representing the object's type. Always /api/refs/collection for this object.
`shipments__link`	`STRING`	API end point that points to a list of resources
`shipments__ref_type`	`STRING`	The _object value of each individual element of the list that link points to.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: invoicesrecipientvat_numbers

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.
`_object`	`STRING`	String representing the object's type. Always /company_entity/vat_number for this object.
`country_code`	`STRING`	ISO 3166 two-letter country code of the VAT number's country
`number`	`STRING`	Full VAT number, including the country code
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: invoicesissuervat_numbers

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.
`_object`	`STRING`	String representing the object's type. Always /company_entity/vat_number for this object.
`country_code`	`STRING`	ISO 3166 two-letter country code of the VAT number's country
`number`	`STRING`	Full VAT number, including the country code
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: invoices__items

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.
`_object`	`STRING`	String representing the object's type. Always /invoice_item for this object.
`name`	`STRING`	Line item name. Example: FCL 40' HQ
`slug`	`STRING`	Line item code. Example: fcl_40_hq
`category`	`STRING`	Category of the charge. Example freight
`amount___object`	`STRING`	String representing the object's type. Always /money for this object.
`amount__amount`	`STRING`	A string representing the decimal amount
`amount__currency_code`	`STRING`	The currency of the amount
`rate`	`JSON`	Describes the rate per unit used to calculate the price of a line item
`quantity`	`JSON`	Describes the number of units used to calculate the price of a line item
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: invoices__credit_memos

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.
`_object`	`STRING`	String representing the object's type. Always /credit_memo for this object.
`amount___object`	`STRING`	String representing the object's type. Always /money for this object.
`amount__amount`	`STRING`	A string representing the decimal amount
`amount__currency_code`	`STRING`	The currency of the amount
`credited_at`	`TIMESTAMP`	When the credit was applied. In ISO8601 UTC format with timezone denoted by Z.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: invoices__credit_memos__categories

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: invoices__credit_memos__reasons

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: invoices__notes

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.

locations (25 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`_object`	`STRING`	String representing the object's type. Always /network/location for this object.
`id`	`STRING`	Unique identifier for the location.
`name`	`STRING`	Name of the location.
`address___object`	`STRING`	String representing the object's type. Always /address for this object.
`address__street_address`	`STRING`	Address line 1 (Street address/PO Box).
`address__street_address2`	`STRING`	Address line 2 (Apartment/Suite/Unit/Building).
`address__city`	`STRING`	City/Town.
`address__state`	`STRING`	State/County/Province/Region.
`address__country`	`STRING`	Country.
`address__country_code`	`STRING`	Two-letter country code (ISO 3166-1 Alpha-2).
`address__zip`	`STRING`	ZIP or postal code.
`address__timezone`	`STRING`	Timezone for this address
`address__ref`	`STRING`	Your reference for the address, as set in your network tab
`address__unlocode`	`STRING`	If port, then UN/LOCODE (United Nations Code for Trade and Transport Locations).
`editable`	`BOOL`	Whether or not you manage this location and can edit its attributes.
`contacts___object`	`STRING`	String representing the object's type. Always /api/refs/collection for this object.
`contacts__link`	`STRING`	API end point that points to a list of resources
`contacts__ref_type`	`STRING`	The _object value of each individual element of the list that link points to.
`company___object`	`STRING`	String representing the object's type. Always /api/refs/object for this object.
`company__link`	`STRING`	API end point that points to a resource.
`company__ref_type`	`STRING`	The _object value of the object that the link points to.
`company__id`	`STRING`	The id value of the object that the link points to.
`ref`	`STRING`	Your custom ref to this location.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

products (11 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`_object`	`STRING`	String representing the object's type. Always /product for this object.
`id`	`INT64`	Unique identifier for the object.
`name`	`STRING`	Name of product.
`description`	`STRING`	Description of product.
`sku`	`STRING`	SKU of product.
`product_category`	`STRING`	The category of the product
`country_of_origin`	`STRING`	Nation in which the product is manufactured
`client_verified`	`BOOL`	Indicates whether Client has verified this Product.
`archived_at`	`TIMESTAMP`	A date string representing when the product was archived. Will be null if product is not archived. In ISO8601 UTC format with timezone denoted by Z.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: products__product_properties

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.
`_object`	`STRING`	String representing the object's type. Always /product/property for this object.
`type`	`STRING`	The property describing the product
`value`	`STRING`	The value associated with the product
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: products__hs_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.
`_object`	`STRING`	String representing the object's type. Always /hs_code for this object.
`description`	`STRING`	Description of HS or HTS code classification.
`code`	`STRING`	6 digit (international HS) or 10 digit (US HTS) code.
`country_code`	`STRING`	The country code that the HS code belongs to.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: products__classifications

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.
`_object`	`STRING`	String representing the object's type. Always /product/classification for this object.
`region`	`STRING`	The two letter code for the region of the classification
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: productsclassificationscodes

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: products__suppliers

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.
`_object`	`STRING`	String representing the object's type. Always /product/supplier for this object.
`id`	`INT64`
`ref`	`STRING`
`country_of_origin`	`STRING`
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

shipments (62 columns)

Column	Type	Description
`_kaivo_id`	`STRING`	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
`_object`	`STRING`	String representing the object's type. Always /shipment for this object.
`id`	`INT64`	Unique identifier for the object.
`name`	`STRING`	Name of the shipment.
`booking`	`JSON`	The booking associated with this shipment
`transportation_mode`	`STRING`	Transportation mode of the main carriage of the shipment.
`freight_type`	`STRING`	The type of freight service provided. One of:
`archived_at`	`TIMESTAMP`	Date when the shipment was archived, if applicable. In ISO8601 UTC format with timezone denoted by Z.
`incoterm`	`STRING`	The Incoterm of your shipment.
`calculated_weight___object`	`STRING`	String representing the object's type. Always /quantity/weight for this object.
`calculated_weight__value`	`FLOAT64`	Specifies the quantity of units as a float.
`calculated_weight__unit`	`STRING`	Specifies the unit of measure for this quantity.
`calculated_volume___object`	`STRING`	String representing the object's type. Always /quantity/volume for this object.
`calculated_volume__value`	`FLOAT64`	Specifies the quantity of units as a float.
`calculated_volume__unit`	`STRING`	Specifies the unit of measure for this quantity.
`pieces`	`INT64`	Total number of pieces in the shipment.
`it_number`	`STRING`	Inbond Transit number used for US Customs
`created_date`	`TIMESTAMP`	Date the user confirmed the Flexport quote for this Shipment.
`status`	`STRING`	Status of the shipment. One of:
`priority`	`STRING`	The level of attention Flexport should give to this shipment.
`updated_at`	`TIMESTAMP`	Date when the shipment object was last updated. In ISO8601 UTC format with timezone denoted by Z.
`estimated_departure_date`	`TIMESTAMP`	Estimated departure date from the first port of the main voyage. In ISO8601 format with timezone denoted by +/-HH:MM.
`actual_departure_date`	`TIMESTAMP`	Actual departure date from the first port of the main voyage. In ISO8601 format with timezone denoted by +/-HH:MM.
`estimated_arrival_date`	`TIMESTAMP`	Estimated arrival date to the last port of the main voyage. In ISO8601 format with timezone denoted by +/-HH:MM.
`actual_arrival_date`	`TIMESTAMP`	Actual arrival date to the last port of the main voyage. In ISO8601 format with timezone denoted by +/-HH:MM.
`cargo_ready_date`	`DATE`	Date when cargo is ready for pickup at the origin location. Calendar date only, no time.
`wants_freight_management_bco`	`BOOL`	Determines if a shipment bypasses a freight forwarder and is booked directly with a steamship line.
`wants_flexport_freight`	`BOOL`	Determines if a shipment is using Flexport services for a combination of import customs clearance or final leg delivery.
`wants_commercial_invoice_transcription`	`BOOL`
`wants_flexport_insurance`	`BOOL`
`wants_pickup_service`	`BOOL`
`wants_trade_declaration_service`	`BOOL`
`visibility_only`	`BOOL`	Indicates if a shipment was requested for tracking via the Flexport visibility-only service.
`wants_delivery_service`	`BOOL`	Determines if Flexport is responsible for door delivery on a shipment.
`estimated_picked_up_in_full_date`	`TIMESTAMP`	Estimated pickup date from the origin location. For ocean shipments with multiple containers, this is the date of last picked up container. In ISO8601 format with timezone denoted by +/-HH:MM.
`actual_picked_up_in_full_date`	`TIMESTAMP`	Actual pickup date from the origin location. For ocean shipments with multiple containers, this is the date of last picked up container. In ISO8601 format with timezone denoted by +/-HH:MM.
`target_delivery_date`	`DATE`	Target date for when the shipment will be fully delivered. This date is set when the shipment''s booking is confirmed. This value may be different from estimated_delivered_in_full_date, which is updated when there is new information about the progress of a shipment. Date only.
`estimated_delivered_in_full_date`	`TIMESTAMP`	Estimated delivery date to the destination location. For ocean shipments with multiple containers, this is the date of last delivered container. In ISO8601 format with timezone denoted by +/-HH:MM.
`actual_delivered_in_full_date`	`TIMESTAMP`	Actual delivery date to the destination location. For ocean shipments with multiple containers, this is the date of last delivered container. In ISO8601 format with timezone denoted by +/-HH:MM.
`wants_export_customs_service`	`BOOL`	Determines if the shipment requires Flexport to provide export customs service.
`wants_import_customs_service`	`BOOL`	Determines if the shipment requires Flexport to provide import customs service.
`ocean_shipment`	`JSON`	Ocean-specific Shipment information. Available only if this is an ocean shipment. null otherwise.
`air_shipment`	`JSON`	Air-specific Shipment information. Available only if this is an air shipment. null otherwise.
`dangerous_goods___object`	`STRING`	String representing the object's type. Always /shipment/dangerous_goods for this object.
`dangerous_goods__review_status`	`STRING`
`legs___object`	`STRING`	String representing the object's type. Always /api/refs/collection for this object.
`legs__link`	`STRING`	API end point that points to a list of resources
`legs__ref_type`	`STRING`	The _object value of each individual element of the list that link points to.
`customs_entries___object`	`STRING`	String representing the object's type. Always /api/refs/collection for this object.
`customs_entries__link`	`STRING`	API end point that points to a list of resources
`customs_entries__ref_type`	`STRING`	The _object value of each individual element of the list that link points to.
`commercial_invoices___object`	`STRING`	String representing the object's type. Always /api/refs/collection for this object.
`commercial_invoices__link`	`STRING`	API end point that points to a list of resources
`commercial_invoices__ref_type`	`STRING`	The _object value of each individual element of the list that link points to.
`documents___object`	`STRING`	String representing the object's type. Always /api/refs/collection for this object.
`documents__link`	`STRING`	API end point that points to a list of resources
`documents__ref_type`	`STRING`	The _object value of each individual element of the list that link points to.
`departure_date`	`TIMESTAMP`	Departure date from the first port of the main voyage.
`arrival_date`	`TIMESTAMP`	Arrival date to the last port of the main voyage.
`picked_up_in_full_date`	`TIMESTAMP`	Pickup date from the origin location. For ocean shipments with multiple containers, this is the date of last picked up container.
`delivered_in_full_date`	`TIMESTAMP`	Delivery date to the destination location. For ocean shipments with multiple containers, this is the date of last delivered container.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: shipments__dangerous_goods__classifications

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: shipments__shippers

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.
`_object`	`STRING`	String representing the object's type. Always /company_entity for this object.
`id`	`INT64`	Unique identifier for the object.
`name`	`STRING`	Name of the company entity.
`ref`	`STRING`	Your reference for this company entity, as set in the Network tab.
`mailing_address`	`JSON`	Address of the company entity.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: shipmentsshippersvat_numbers

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.
`_object`	`STRING`	String representing the object's type. Always /company_entity/vat_number for this object.
`country_code`	`STRING`	ISO 3166 two-letter country code of the VAT number's country
`number`	`STRING`	Full VAT number, including the country code
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: shipments__consignees

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.
`_object`	`STRING`	String representing the object's type. Always /company_entity for this object.
`id`	`INT64`	Unique identifier for the object.
`name`	`STRING`	Name of the company entity.
`ref`	`STRING`	Your reference for this company entity, as set in the Network tab.
`mailing_address`	`JSON`	Address of the company entity.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: shipmentsconsigneesvat_numbers

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.
`_object`	`STRING`	String representing the object's type. Always /company_entity/vat_number for this object.
`country_code`	`STRING`	ISO 3166 two-letter country code of the VAT number's country
`number`	`STRING`	Full VAT number, including the country code
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: shipments__buyers

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.
`_object`	`STRING`	String representing the object's type. Always /company_entity for this object.
`id`	`INT64`	Unique identifier for the object.
`name`	`STRING`	Name of the company entity.
`ref`	`STRING`	Your reference for this company entity, as set in the Network tab.
`mailing_address`	`JSON`	Address of the company entity.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: shipmentsbuyersvat_numbers

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.
`_object`	`STRING`	String representing the object's type. Always /company_entity/vat_number for this object.
`country_code`	`STRING`	ISO 3166 two-letter country code of the VAT number's country
`number`	`STRING`	Full VAT number, including the country code
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: shipments__sellers

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.
`_object`	`STRING`	String representing the object's type. Always /company_entity for this object.
`id`	`INT64`	Unique identifier for the object.
`name`	`STRING`	Name of the company entity.
`ref`	`STRING`	Your reference for this company entity, as set in the Network tab.
`mailing_address`	`JSON`	Address of the company entity.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: shipmentssellersvat_numbers

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.
`_object`	`STRING`	String representing the object's type. Always /company_entity/vat_number for this object.
`country_code`	`STRING`	ISO 3166 two-letter country code of the VAT number's country
`number`	`STRING`	Full VAT number, including the country code
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: shipments__importers_of_record

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.
`_object`	`STRING`	String representing the object's type. Always /company_entity for this object.
`id`	`INT64`	Unique identifier for the object.
`name`	`STRING`	Name of the company entity.
`ref`	`STRING`	Your reference for this company entity, as set in the Network tab.
`mailing_address`	`JSON`	Address of the company entity.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: shipments__importers_of_record__vat_numbers

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.
`_object`	`STRING`	String representing the object's type. Always /company_entity/vat_number for this object.
`country_code`	`STRING`	ISO 3166 two-letter country code of the VAT number's country
`number`	`STRING`	Full VAT number, including the country code
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: shipments__items

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.
`_object`	`STRING`	String representing the object's type. Always /shipment_item for this object.
`id`	`INT64`	Unique identifier for the object.
`total_units`	`STRING`	Total quantity of specific SKU within shipment.
`total_weight___object`	`STRING`	String representing the object's type. Always /quantity/weight for this object.
`total_weight__value`	`FLOAT64`	Specifies the quantity of units as a float.
`total_weight__unit`	`STRING`	Specifies the unit of measure for this quantity.
`total_volume___object`	`STRING`	String representing the object's type. Always /quantity/volume for this object.
`total_volume__value`	`FLOAT64`	Specifies the quantity of units as a float.
`total_volume__unit`	`STRING`	Specifies the unit of measure for this quantity.
`purchase_order_number`	`STRING`	Purchase order number associated with SKU within shipment.
`product___object`	`STRING`	String representing the object's type. Always /product for this object.
`product__id`	`INT64`	Unique identifier for the object.
`product__name`	`STRING`	Name of product.
`product__description`	`STRING`	Description of product.
`product__sku`	`STRING`	SKU of product.
`product__product_category`	`STRING`	The category of the product
`product__country_of_origin`	`STRING`	Nation in which the product is manufactured
`product__client_verified`	`BOOL`	Indicates whether Client has verified this Product.
`product__archived_at`	`TIMESTAMP`	A date string representing when the product was archived. Will be null if product is not archived. In ISO8601 UTC format with timezone denoted by Z.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: shipmentsitemsproduct__product_properties

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.
`_object`	`STRING`	String representing the object's type. Always /product/property for this object.
`type`	`STRING`	The property describing the product
`value`	`STRING`	The value associated with the product
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: shipmentsitemsproduct__hs_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.
`_object`	`STRING`	String representing the object's type. Always /hs_code for this object.
`description`	`STRING`	Description of HS or HTS code classification.
`code`	`STRING`	6 digit (international HS) or 10 digit (US HTS) code.
`country_code`	`STRING`	The country code that the HS code belongs to.
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: shipmentsitemsproduct__classifications

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.
`_object`	`STRING`	String representing the object's type. Always /product/classification for this object.
`region`	`STRING`	The two letter code for the region of the classification
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: shipmentsitemsproductclassificationscodes

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: shipmentsitemsproduct__suppliers

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.
`_object`	`STRING`	String representing the object's type. Always /product/supplier for this object.
`id`	`INT64`
`ref`	`STRING`
`country_of_origin`	`STRING`
`_kaivo_extracted_at`	`TIMESTAMP`	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

How the Flexport sync works

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Flexport 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 Flexport?

It depends on how much history is in your Flexport 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 Flexport'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 Flexport, 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 Flexport 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 Flexport connector in Kaivo and all of its synced data is deleted with it.

Common use cases for Flexport data

Shipment tracking

Use shipments to track freight volume and movement over time.

Freight cost

Join invoices with shipments to analyse logistics spend.

Supplier and location view

Use companies and locations to report on where goods move.

Use Flexport data in your AI and BI tools

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

Google Analytics: Sync Google Analytics to BigQuery.
Recharge: Sync Recharge to BigQuery.
Extensiv 3PL Warehouse Manager: Sync Extensiv 3PL Warehouse Manager to BigQuery.
WooCommerce: Sync WooCommerce to BigQuery.
Amazon Selling Partner: Sync Amazon Selling Partner to BigQuery.
Adobe Commerce: Sync Adobe Commerce to BigQuery.

Was this helpful?

Still need help? Share an idea