Endpoints

The OEC API is built on top of the Tesseract OLAP engine, providing a flexible set of endpoints to explore metadata and retrieve trade data. Below is a list of the core endpoints available:

/cubes

Returns a list of all available data cubes in the Tesseract server.

https://api-v2.oec.world/tesseract/cubes

/cubes/{name}

Returns the full schema of a specific cube, including its measures, dimensions, and levels.

Example: https://api-v2.oec.world/tesseract/cubes/trade_i_baci_a_96

/members?cube=<name>&level=<level>

Returns all members (distinct categorization values) for a selected level of a given cube. This is useful for populating filters or understanding the scope of available data in a dimension level.

Example: https://api-v2.oec.world/tesseract/members?cube=trade_i_baci_a_96&level=HS2

/data.{format}

This is the main endpoint used to fetch the data itself. You can query specific dimensions, measures, and filters to retrieve the dataset you're interested in.

The data.{format} endpoint allows you to choose the desired format of the response. Supported formats are:

• csv Comma-separated values
• tsv Tab-separated values
• parquet Apache Parquet columnar binary format (for big data processing)
• xlsx Microsoft Excel spreadsheet
• jsonarrays JSON array of arrays (compact)
• jsonrecords JSON array of objects (more readable)