ImportYeti
PowerQuery
GET

Search Mexico export declarations

1 per 10 records

PowerQuery over Mexico export customs declarations (pedimentos).

Parameters#

Query parameters

27 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.

  • company_namestringoptional
  • supplier_namestringoptional
  • product_descriptionstringoptional

    Supports boolean operators and wildcards

    AND / OR / NOTwildcards * ?
  • weightstringoptional

    Supports ranges

    ranges [a TO b]
  • company_total_shipmentsstringoptional

    Supports ranges

    ranges [a TO b]
  • supplier_total_shipmentsstringoptional

    Supports ranges

    ranges [a TO b]
  • who_pays_freightstringoptionaldefault Foreign entity

    Foreign entity / Mexico entity

    one ofForeign entityMexico entity

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

Response#

A page of matching Mexico export customs declarations.

Response shape
{
  "requestCost": 1,
  "creditsRemaining": 9998.5,
  "data": {
    "data": [
      {
        "declaration_id": "6002390-b187b8ff9969608eb75ba3adc1d5926f",
        "declaration_number": "6002390",
        "rfc_number": "AHE070309N12",
        "pedimento_number": "26_37_AHE070309N12_6002390",
        "export_date": "02/28/2026",
        "company_name": "Importaciones Re Re Sa",
        "company_country": "Estados Unidos De America",
        "company_country_code": "US"
        // …24 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
32 fields
  • declaration_idstring6002390-b187b8ff9969608eb75ba3adc1d5926f
  • declaration_numberstring6002390
  • rfc_numberstringAHE070309N12

    Registro Federal de Contribuyentes — the Mexican tax ID of the filing company.

  • pedimento_numberstring26_37_AHE070309N12_6002390

    Line-level pedimento identifier, combining year, customs office, RFC, and declaration number.

  • export_datestring02/28/2026
  • company_namestringImportaciones Re Re Sa
  • company_countrystringEstados Unidos De America
  • company_country_codestringUS
  • company_total_shipmentsnumber13071
  • supplier_namestringAksi Herramientas Sa De Cv
  • supplier_statestringMexico
  • supplier_addressstringAvenida Universidad Sin Numero Avenida La Joya Y Avenida La Palma, 54879, Cuautitlan, Mexico

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.