Windsor brings all your Flexport data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Flexport Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| companies___object | TEXT | companies._object | companies._object | companies |
| companies__contacts | OBJECT | companies.contacts | companies.contacts | companies |
| companies__editable | BOOLEAN | companies.editable | companies.editable | companies |
| companies__entities | OBJECT | companies.entities | companies.entities | companies |
| companies__id | TEXT | companies.id | companies.id | companies |
| companies__locations | OBJECT | companies.locations | companies.locations | companies |
| companies__metadata | OBJECT | companies.metadata | companies.metadata | companies |
| companies__name | TEXT | companies.name | companies.name | companies |
| companies__ref | TEXT | companies.ref | companies.ref | companies |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| invoices___object | TEXT | invoices._object | invoices._object | invoices |
| invoices__balance | OBJECT | invoices.balance | invoices.balance | invoices |
| invoices__credit_memos | OBJECT | invoices.credit_memos | invoices.credit_memos | invoices |
| invoices__due_date | TEXT | invoices.due_date | invoices.due_date | invoices |
| invoices__id | TEXT | invoices.id | invoices.id | invoices |
| invoices__issued_at | TEXT | invoices.issued_at | invoices.issued_at | invoices |
| invoices__issuer | OBJECT | invoices.issuer | invoices.issuer | invoices |
| invoices__items | OBJECT | invoices.items | invoices.items | invoices |
| invoices__last_updated_at | TEXT | invoices.last_updated_at | invoices.last_updated_at | invoices |
| invoices__name | TEXT | invoices.name | invoices.name | invoices |
| invoices__notes | OBJECT | invoices.notes | invoices.notes | invoices |
| invoices__recipient | OBJECT | invoices.recipient | invoices.recipient | invoices |
| invoices__shipments | OBJECT | invoices.shipments | invoices.shipments | invoices |
| invoices__status | TEXT | invoices.status | invoices.status | invoices |
| invoices__total | OBJECT | invoices.total | invoices.total | invoices |
| invoices__type | TEXT | invoices.type | invoices.type | invoices |
| invoices__voided_at | TEXT | invoices.voided_at | invoices.voided_at | invoices |
| locations___object | TEXT | locations._object | locations._object | locations |
| locations__address | OBJECT | locations.address | locations.address | locations |
| locations__company | OBJECT | locations.company | locations.company | locations |
| locations__contacts | OBJECT | locations.contacts | locations.contacts | locations |
| locations__editable | BOOLEAN | locations.editable | locations.editable | locations |
| locations__id | TEXT | locations.id | locations.id | locations |
| locations__metadata | OBJECT | locations.metadata | locations.metadata | locations |
| locations__name | TEXT | locations.name | locations.name | locations |
| locations__ref | TEXT | locations.ref | locations.ref | locations |
| products___object | TEXT | products._object | products._object | products |
| products__archived_at | TEXT | products.archived_at | products.archived_at | products |
| products__classifications | OBJECT | products.classifications | products.classifications | products |
| products__client_verified | BOOLEAN | products.client_verified | products.client_verified | products |
| products__country_of_origin | TEXT | products.country_of_origin | products.country_of_origin | products |
| products__description | TEXT | products.description | products.description | products |
| products__hs_codes | OBJECT | products.hs_codes | products.hs_codes | products |
| products__id | NUMERIC | products.id | products.id | products |
| products__name | TEXT | products.name | products.name | products |
| products__product_category | TEXT | products.product_category | products.product_category | products |
| products__product_properties | OBJECT | products.product_properties | products.product_properties | products |
| products__sku | TEXT | products.sku | products.sku | products |
| products__suppliers | OBJECT | products.suppliers | products.suppliers | products |
| shipments___object | TEXT | shipments._object | shipments._object | shipments |
| shipments__actual_arrival_date | TEXT | shipments.actual_arrival_date | shipments.actual_arrival_date | shipments |
| shipments__actual_delivered_in_full_date | TEXT | shipments.actual_delivered_in_full_date | shipments.actual_delivered_in_full_date | shipments |
| shipments__actual_departure_date | TEXT | shipments.actual_departure_date | shipments.actual_departure_date | shipments |
| shipments__actual_picked_up_in_full_date | TEXT | shipments.actual_picked_up_in_full_date | shipments.actual_picked_up_in_full_date | shipments |
| shipments__air_shipment | TEXT | shipments.air_shipment | shipments.air_shipment | shipments |
| shipments__archived_at | TEXT | shipments.archived_at | shipments.archived_at | shipments |
| shipments__arrival_date | TEXT | shipments.arrival_date | shipments.arrival_date | shipments |
| shipments__booking | TEXT | shipments.booking | shipments.booking | shipments |
| shipments__buyers | OBJECT | shipments.buyers | shipments.buyers | shipments |
| shipments__calculated_volume | OBJECT | shipments.calculated_volume | shipments.calculated_volume | shipments |
| shipments__calculated_weight | OBJECT | shipments.calculated_weight | shipments.calculated_weight | shipments |
| shipments__cargo_ready_date | TEXT | shipments.cargo_ready_date | shipments.cargo_ready_date | shipments |
| shipments__commercial_invoices | OBJECT | shipments.commercial_invoices | shipments.commercial_invoices | shipments |
| shipments__consignees | OBJECT | shipments.consignees | shipments.consignees | shipments |
| shipments__created_date | TEXT | shipments.created_date | shipments.created_date | shipments |
| shipments__customs_entries | OBJECT | shipments.customs_entries | shipments.customs_entries | shipments |
| shipments__dangerous_goods | OBJECT | shipments.dangerous_goods | shipments.dangerous_goods | shipments |
| shipments__delivered_in_full_date | TEXT | shipments.delivered_in_full_date | shipments.delivered_in_full_date | shipments |
| shipments__departure_date | TEXT | shipments.departure_date | shipments.departure_date | shipments |
| shipments__documents | OBJECT | shipments.documents | shipments.documents | shipments |
| shipments__estimated_arrival_date | TEXT | shipments.estimated_arrival_date | shipments.estimated_arrival_date | shipments |
| shipments__estimated_delivered_in_full_date | TEXT | shipments.estimated_delivered_in_full_date | shipments.estimated_delivered_in_full_date | shipments |
| shipments__estimated_departure_date | TEXT | shipments.estimated_departure_date | shipments.estimated_departure_date | shipments |
| shipments__estimated_picked_up_in_full_date | TEXT | shipments.estimated_picked_up_in_full_date | shipments.estimated_picked_up_in_full_date | shipments |
| shipments__freight_type | TEXT | shipments.freight_type | shipments.freight_type | shipments |
| shipments__id | NUMERIC | shipments.id | shipments.id | shipments |
| shipments__importers_of_record | OBJECT | shipments.importers_of_record | shipments.importers_of_record | shipments |
| shipments__incoterm | TEXT | shipments.incoterm | shipments.incoterm | shipments |
| shipments__it_number | TEXT | shipments.it_number | shipments.it_number | shipments |
| shipments__items | OBJECT | shipments.items | shipments.items | shipments |
| shipments__legs | OBJECT | shipments.legs | shipments.legs | shipments |
| shipments__metadata | OBJECT | shipments.metadata | shipments.metadata | shipments |
| shipments__name | TEXT | shipments.name | shipments.name | shipments |
| shipments__ocean_shipment | TEXT | shipments.ocean_shipment | shipments.ocean_shipment | shipments |
| shipments__picked_up_in_full_date | TEXT | shipments.picked_up_in_full_date | shipments.picked_up_in_full_date | shipments |
| shipments__pieces | NUMERIC | shipments.pieces | shipments.pieces | shipments |
| shipments__priority | TEXT | shipments.priority | shipments.priority | shipments |
| shipments__sellers | OBJECT | shipments.sellers | shipments.sellers | shipments |
| shipments__shippers | OBJECT | shipments.shippers | shipments.shippers | shipments |
| shipments__status | TEXT | shipments.status | shipments.status | shipments |
| shipments__target_delivery_date | TEXT | shipments.target_delivery_date | shipments.target_delivery_date | shipments |
| shipments__transportation_mode | TEXT | shipments.transportation_mode | shipments.transportation_mode | shipments |
| shipments__updated_at | TEXT | shipments.updated_at | shipments.updated_at | shipments |
| shipments__visibility_only | BOOLEAN | shipments.visibility_only | shipments.visibility_only | shipments |
| shipments__wants_commercial_invoice_transcription | BOOLEAN | shipments.wants_commercial_invoice_transcription | shipments.wants_commercial_invoice_transcription | shipments |
| shipments__wants_delivery_service | BOOLEAN | shipments.wants_delivery_service | shipments.wants_delivery_service | shipments |
| shipments__wants_export_customs_service | BOOLEAN | shipments.wants_export_customs_service | shipments.wants_export_customs_service | shipments |
| shipments__wants_flexport_freight | BOOLEAN | shipments.wants_flexport_freight | shipments.wants_flexport_freight | shipments |
| shipments__wants_flexport_insurance | BOOLEAN | shipments.wants_flexport_insurance | shipments.wants_flexport_insurance | shipments |
| shipments__wants_freight_management_bco | BOOLEAN | shipments.wants_freight_management_bco | shipments.wants_freight_management_bco | shipments |
| shipments__wants_import_customs_service | BOOLEAN | shipments.wants_import_customs_service | shipments.wants_import_customs_service | shipments |
| shipments__wants_pickup_service | BOOLEAN | shipments.wants_pickup_service | shipments.wants_pickup_service | shipments |
| shipments__wants_trade_declaration_service | BOOLEAN | shipments.wants_trade_declaration_service | shipments.wants_trade_declaration_service | shipments |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date |