API Info

Market data can be retrieved through the API.

API host URLs

These are the base URLs—the beginning of every API request. Choose the host for the game server you want (Americas, Asia, or Europe), then append one of the endpoint paths from the section below to get the data you need.

For example: https://west.albion-online-data.com + /api/v2/stats/prices/T4_BAG.json?locations=Caerleon → https://west.albion-online-data.com/api/v2/stats/prices/T4_BAG.json?locations=Caerleon

  • Americas (West): https://west.albion-online-data.com
  • Asia (East): https://east.albion-online-data.com
  • Europe: https://europe.albion-online-data.com

API endpoints

Swagger documentation is available for the API. Item IDs can be found in the formatted metadata items.txt or items.json files. Location IDs or string names can be found in world.txt or world.json.

For the URLs below, .json is optional and is the default. For XML, replace .json with .xml.

Supported date formats are YYYY-MM-DD (prefered) and MM-DD-YYYY.

Current prices

Table view
/api/v2/stats/view/{item_ids}?locations=Caerleon,Bridgewatch&qualities=2
JSON
/api/v2/stats/prices/{item_ids}.json?locations=Caerleon,Bridgewatch&qualities=2

Historical prices (sell orders only)

Use time-scale to choose aggregation: 1 = hourly, 6 = 6-hour, 24 = daily.

Date range (e.g. 6-hour buckets)
/api/v2/stats/history/{item_ids}.json?date=2-5-2020&end_date=2-12-2020&locations=Caerleon&qualities=2&time-scale=6
Hourly
/api/v2/stats/history/{item_ids}.json?time-scale=1
Daily
/api/v2/stats/history/{item_ids}.json?time-scale=24
Charts (date range)
/api/v2/stats/charts/{item_ids}.json?date=2-5-2020&end_date=2-12-2020&locations=Caerleon&qualities=2&time-scale=6

Gold prices

Over time (date range)
/api/v2/stats/gold.json?date=2-5-2020&end_date=2-12-2020
Most recent X prices
/api/v2/stats/gold.json?count=2

Rate limits

  • 180 requests per 1 minute
  • 300 requests per 5 minutes

Getting all the data

You can request a lot of data in a single call by combining the items and locations you need. Keep in mind:

  • There is a 4096 character limit for the URL length—you can fit many items and all locations in one request if you stay under this limit.
  • If you run a service that continually hits the API, please use Gzip compression. Server and bandwidth are not free, and using compression helps keep the project sustainable as usage grows.

Spreadsheets

Many people find it useful to load these APIs in spreadsheets such as Microsoft Excel or Google Sheets. There is no single best way to do this, but some of the common ways are as follows:

  • Excel Power Query — Use Power Query to connect to the API URLs and pull data into Excel.
  • Google Sheets IMPORTXML — For XML endpoints. Example: =IMPORTXML("https://west.albion-online-data.com/api/v2/stats/prices/T4_BAG.xml?locations=Caerleon&qualities=2","//ArrayOfMarketResponse/MarketResponse")
  • Google Sheets ImportJSON (third-party script) — For JSON endpoints. Example: =ImportJSON("https://west.albion-online-data.com/api/v2/stats/prices/T4_BAG.json?locations=Caerleon&qualities=2", "", "noHeaders").
    Note: Some people have noticed issues with ImportJSON and repeating rows.