Flexport Lite
Flexport is a freight forwarder and logistics platform.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | BOOKING_LINE_ITEM, COMMERCIAL_INVOICE, COMPANY_ENTITY, COMPANY, CONTACT, CONTAINER_LEG, CONTAINER, CUSTOM_ENTRY, LOCATION, PORT, PRODUCT, PURCHASE_ORDER_LINE_ITEM, and SHIPMENT_LEG tables. |
| History mode | ||
| Custom data | ||
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
Setup guide
Follow our step-by-step Flexport setup guide to connect Flexport with your destination using Fivetran connectors.
Sync overview
To capture new records, we incrementally sync the following tables and their child tables:
BOOKINGDOCUMENTINVOICEPURCHASE_ORDERSHIPMENT
To capture updates and deletes, we re-import the following tables in every sync:
BOOKING_LINE_ITEMCOMMERCIAL_INVOICECOMPANY_ENTITYCOMPANYCONTACTCONTAINER_LEGCONTAINERCUSTOM_ENTRYLOCATIONPORTPRODUCTPURCHASE_ORDER_LINE_ITEMSHIPMENT_LEG
We also re-import the INVOICE table once a week to capture updates.
Schema information
This schema applies to all Flexport connectors.
Explore Flexport schema ERD
Flexport API limitation
Flexport imposes a limit of 10 requests per day. To avoid exceeding this limit and causing the connector to fail, set the connector sync frequency to more than 2 hours and 24 minutes.