API Info
Market data can be retrieved through the API.
API docs
Each game server has its own API and its own docs. The docs cover every endpoint and parameter, host URLs, rate limits, and compression, and let you try requests and copy them as curl, Python, Node, or Ruby.
- Americas (West): https://west.albion-online-data.com/api-docs
- Asia (East): https://east.albion-online-data.com/api-docs
- Europe: https://europe.albion-online-data.com/api-docs
Item and location IDs
The Items page lets you search item IDs by name in any supported language. Item IDs can also 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.
Common locations (these are also the default when locations is left out). Use the name or the ID:
- Black Market (
3003) - Bridgewatch (
2004) - Brecilien (
5003) - Caerleon (
3005) - Fort Sterling (
4002) - Lymhurst (
1002) - Martlock (
3008) - Thetford (
7)
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.