Cargoson

Cargoson is a freight and logistics management platform that helps businesses streamline shipping, compare carrier rates, track shipments, and manage transportation workflows.

Supported Features

Data Schema

Syncing Bookings

Unlike Cargoson's other objects, Bookings can't be synced from a fixed endpoint — the Cargoson API requires the unique booking references of the bookings you want to fetch. Because of this, syncing Bookings requires an extra setup step:

1. In your destination, prepare a table or model containing the unique booking references you want Weld to sync. This is typically a table you already sync or transform from another source, such as an order or shipment system that stores your Cargoson booking references.
2. In the Cargoson connector setup, attach this table/model as a source under the Bookings table configuration and pick the column with the booking references.
3. Optionally, pick an alias column if your Cargoson account has more than one company. See Multiple companies in Cargoson below.
4. Weld will use the booking references from the attached table/model to call the Cargoson API and sync the corresponding booking data.

Multiple companies in Cargoson

A single Cargoson account can hold more than one company. Each company is identified by an alias in Cargoson, and a booking reference is only valid within the company it belongs to. If your account has more than one company and the request does not tell Cargoson which company the booking belongs to, the request to Cargoson fails.

If your Cargoson account only has one company, you can skip this section — the alias column is optional and Weld looks up each booking without an alias. Weld still only fetches the bookings whose references are in the attached table/model; it does not discover bookings on its own.

If your account has more than one company:

1. Add a column to the table/model with the booking references that holds the Cargoson alias of the company each booking belongs to. The alias is the value Cargoson shows for the company under your account settings.
2. In the Cargoson connector setup, select that column as the Alias column under the Bookings table configuration. The dropdown lists the columns of the table/model you attached.
3. For every booking reference, Weld sends the alias from that row along with the request, so Cargoson resolves the booking within the right company.

SQL Templates

View all →

Carrier costs by month

Shipments, freight spend, weight moved and delivery performance per carrier and service, per month.

grain: month x cargoson_account x carrier_name x service_name x freight_currency · builds on 3 models

Lane costs

What it costs to move goods on each lane, by carrier: the table you take into a freight tender.

grain: cargoson_account x collection_country x delivery_country x carrier_name x freight_type x freight_currency · builds on 3 models

Shipments

Every booking as a shipment: lane, carrier, service, agreed freight price, goods weight, and how its transit went against the carrier's estimate.

grain: one row per cargoson_account x booking_reference · builds on 2 models