LCBO API

Follow on Twitter!

LCBO API Documentation

Dataset

URL Template: http://lcboapi.com/datasets/:dataset_id

Datasets represent snapshots of all stores, products, and inventories at a given time. They are created once per day and contain information such as the IDs of stores and products that were added and removed since the previous dataset.

Formats

.json	JSON (default format if no extension is supplied)
.js	Javascript (for use with JSON-P, requires `callback` parameter)
.csv	Comma Separated Values
.tsv	Tab Separated Values
.zip	ZIP archive of all data (performs a redirect to the actual file)

Fields

`id`	Dataset identifier
`total_products`	Total unique retail products across all stores
`total_stores`	Total stores
`total_inventories`	Total inventory items across all stores
`total_product_inventory_count`	Total product units across all stores
`total_product_inventory_volume_in_milliliters`	Total volume of all product units across all stores
`total_product_inventory_price_in_cents`	Total retail value of all product units across all stores
`created_at`	The time the dataset was created
`product_ids`	List of all active product IDs at the time the dataset was created
`store_ids`	List of all active store IDs at the time the dataset was created
`added_product_ids`	List of product IDs that were added since the previous update
`added_store_ids`	List of store IDs that were added since the previous update
`removed_product_ids`	List of product IDs that were removed since the previous update
`removed_store_ids`	List of store IDs that were removed since the previous update
`csv_dump`	Contains a path to a ZIP archive of CSV files for stores, products, and inventories.