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 valuestsv
Tab-separated valuesparquet
Apache Parquet columnar binary format (for big data processing)xlsx
Microsoft Excel spreadsheetjsonarrays
JSON array of arrays (compact)jsonrecords
JSON array of objects (more readable)