Search US import bills of lading

1 per 10 records

PowerQuery over US import shipment documents. Filter by company/supplier slug, product description, HS code, ports, and more. Supports boolean operators, wildcards, and ranges on indicated fields.

curl -X GET "https://data.importyeti.com/v1.0/powerquery/us-import/bols?page_size=5&start_date=01%2F01%2F2024&product_description=furniture" \
  -H "IYApiKey: YOUR_API_KEY" \
  -H "Accept: application/json"

Try it

Runs a real request and spends real credits. Your key stays in this browser.

API key

Base URL

https://data.importyeti.com

Query parameters

page_sizeNumber of returned resultsstart_dateproduct_descriptionSupports boolean operators and wildcards

Request

GET https://data.importyeti.com/v1.0/powerquery/us-import/bols?page_size=5&start_date=01%2F01%2F2024&product_description=furniture

Add an API key above to send. Get a key →

Example responsesample

{
  "requestCost": 0.2,
  "creditsRemaining": 500,
  "data": {
    "data": [
      {
        "corporate_info_exists": true,
        "company_manifest_confidentiality": true,
        "supplier_manifest_confidentiality": true,
        "bol_number": "HLCUGDY251030849",
        "bol_type": "R",
        "master_bol_number": "HLCUGDY251030849",
        "arrival_date": "11/28/2025",
        "company_first_shipment_date": "01/01/2015",
        "supplier_first_shipment_date": "02/01/2015",
        "entry_port_geocode": {
          "lat": 39.21575,
          "lon": -76.5438
        },
        "exit_port_geocode": {
          "lat": 53.5615,
          "lon": 8.1235
        },
        "company_name": "Ikea Supply Ag",
        "company_basename": "Ikea Supply",
        "company_address": "100 Ikea Way 21903 Perryville Us Customs Department Tel 4848039015",
        "containers": [
          {
            "description": "Billy Bookcs W Fldbl Tbl X / X White,Gullaberg Shoe Cab Comp Idanaes Bed Frm W St/ Total Pieces / Total Pallets",
            "id": "GCXU6148826",
            "load_status": "L",
            "load_status_info": "Loaded - The container has cargo and will be delivered locally",
            "mark": null,
            "service_type": "HH",
            "service_type_info": "House to House",
            "size": "4000*900*800",
            "type": "4510",
            "type_info": {
              "desc": "Passive vents at upper part of cargo space - Total vent cross-section area < 25 cm2/m of nominal container length.",
              "group": "General Purpose Container (with ventilation)",
              "length": "40ft",
              "type": "4510",
              "width_x_height": "8ft x 9ft 6in"
            }
          }
        ],
        "containers_count": 1,
        "supplier_address_geocode": {
          "address_components": {
            "country": "SK"
          },
          "location": {
            "lat": 49.03742,
            "lon": 19.63442
          }
        },
        "company_address_geocode": {
          "address_components": {
            "city": "Perryville",
            "country": "US",
            "county": "Cecil County",
            "state": "MD",
            "zip": "21903"
          },
          "formatted_address": "Perryville, MD 21903",
          "location": {
            "lat": 39.57,
            "lon": -76.06
          }
        },
        "company_link": "/company/ikea-supply",
        "company_country": "United States",
        "company_country_code": "US"
      },
      {
        "corporate_info_exists": true,
        "company_manifest_confidentiality": false,
        "supplier_manifest_confidentiality": false,
        "bol_number": "FLXT00003516358A",
        "bol_type": "H",
        "master_bol_number": "EGLV146501100292",
        "arrival_date": "11/28/2025",
        "company_first_shipment_date": "02/01/2015",
        "supplier_first_shipment_date": "08/01/2015",
        "entry_port_geocode": {
          "lat": 33.7315,
          "lon": -118.265
        },
        "exit_port_geocode": {
          "lat": 24.50318,
          "lon": 118.0293
        },
        "company_name": "Genesco Inc",
        "company_basename": "Genesco",
        "company_address": "535 Marriott Dr Nashville Tn 37214 P: 615-367-7559 Attn:Lindsay Lanham/Karlene Ramnath E",
        "containers": [
          {
            "description": "Shoes ( Men S Shoes & Women S Shoes ) Po# A Th Dk Ath Ath Ath Dk Dk",
            "id": "TXGU4081586",
            "load_status": "L",
            "load_status_info": "Loaded - The container has cargo and will be delivered locally",
            "mark": "P.O.No.: Cust Name: Cust Order: Style Name:",
            "service_type": "HH",
            "service_type_info": "House to House",
            "size": "4000*900*800",
            "type": "45G0",
            "type_info": {
              "desc": "Openings at one end or both ends",
              "group": "General Purpose Container (no ventilation)",
              "length": "40ft",
              "type": "45G0",
              "width_x_height": "8ft x 9ft 6in"
            }
          },
          {
            "description": "Shoes ( Men S Shoes & Women S Shoes ) Po# A Th Dk Ath Ath Ath Dk Dk",
            "id": "EGHU8310026",
            "load_status": "L",
            "load_status_info": "Loaded - The container has cargo and will be delivered locally",
            "mark": "P.O.No.: Cust Name: Cust Order: Style Name:",
            "service_type": "HH",
            "service_type_info": "House to House",
            "size": "4000*900*800",
            "type": "45G0",
            "type_info": {
              "desc": "Openings at one end or both ends",
              "group": "General Purpose Container (no ventilation)",
              "length": "40ft",
              "type": "45G0",
              "width_x_height": "8ft x 9ft 6in"
            }
          }
        ],
        "containers_count": 2,
        "supplier_address_geocode": {
          "address_components": {
            "country": "CN"
          },
          "location": {
            "lat": 25.4173,
            "lon": 106.558
          }
        },
        "company_address_geocode": {
          "address_components": {
            "city": "Nashville",
            "country": "US",
            "county": "Davidson County",
            "state": "TN",
            "zip": "37214"
          },
          "formatted_address": "Nashville, TN 37214",
          "location": {
            "lat": 36.16,
            "lon": -86.67
          }
        },
        "company_link": "/company/genesco",
        "company_country": "United States",
        "company_country_code": "US"
      }
    ],
    "totalCount": 59583
  },
  "executionTime": "0ms"
}

Parameters#

Query parameters

29 parameters

page_sizenumberoptionaldefault 10
Number of returned results
offsetnumberoptionaldefault 0
Results starting position
start_datestringoptionaldefault 01/01/2021
end_datestringoptionaldefault 08/31/2026
pagenumberoptional
Page number (1-indexed). Takes precedence over offset.
companystringoptional
Company identifier
supplierstringoptional
Supplier identifier
product_descriptionstringoptional
Supports boolean operators and wildcards
AND / OR / NOTwildcards * ?
weightstringoptional
Supports ranges
ranges [a TO b]
teustringoptional
Supports ranges
ranges [a TO b]
company_total_shipmentsstringoptional
Supports ranges
ranges [a TO b]
supplier_total_shipmentsstringoptional
Supports ranges
ranges [a TO b]

fields, exclude, and format work the same way on every endpoint — Response shaping has worked examples.

Response#

A page of matching US import bills of lading.

Response shape

{
  "requestCost": 1,
  "creditsRemaining": 9998.5,
  "data": {
    "data": [
      {
        "bol_number": "CCLLMILS17011590",
        "bol_type": "H",
        "inbond_type": "61 - IT: Immediate Transportation",
        "master_bol_number": "NYKSMILT12616400",
        "has_master_data": true,
        "company_manifest_confidentiality": false,
        "supplier_manifest_confidentiality": false,
        "arrival_date": "08/21/2017"
        // …95 more fields
      }
    ],
    "totalCount": 59583
  },
  "executionTime": "224ms"
}

Rows are nested one level deeper

PowerQuery routes put the records at data.data — not at data. The total number of matches is on data.totalCount, which is the value you page against. Note that this key is named per route family (totalCount, totalCompanies, totalSuppliers, totalBrokers).

Top-level fields#

data — an object holding the result rows (data.data) and the match total (data.totalCount)
requestCost — Data credits used for this call (0 if none)
creditsRemaining — Your data credit balance after the call
executionTime — How long the request took
totalCount — Total matching records, not just this page

Fields on each row in data.data#

FieldExample

103 fields

bol_numberstringCCLLMILS17011590
bol_typestringH
Which filing this is: “R” for a regular (carrier-filed) bill, “H” for a house bill filed by a forwarder.
inbond_typestring61 - IT: Immediate Transportation
master_bol_numberstringNYKSMILT12616400
The carrier-level bill this house bill rolls up to. House bills covering one master shipment share this value.
has_master_databooleantrue
company_manifest_confidentialitybooleanfalse
supplier_manifest_confidentialitybooleanfalse
arrival_datestring08/21/2017
company_first_shipment_datestring07/04/2015
supplier_first_shipment_datestring08/01/2015
lat, lon
lat, lon

Errors#

Failures come back as JSON with a statusCode and message. The ones worth handling here are 401 (bad or missing key), 403 (out of credits), and 404 (no such record). See all error responses.