CKAN Data API

Access resource data via a web API with powerful query support. Further information in the main CKAN Data API and DataStore documentation.

Endpoints »

The Data API can be accessed via the following actions of the CKAN action API.

Create https://data.ontario.ca/en/api/3/action/datastore_create
Update / Insert https://data.ontario.ca/en/api/3/action/datastore_upsert
Query https://data.ontario.ca/en/api/3/action/datastore_search
Querying »
Example: Javascript »

A simple ajax (JSONP) request to the data API using jQuery.

var data = {
  resource_id: 'dc378388-29de-46d5-9cfb-fe585da89aa0', // the resource id
  limit: 5, // get 5 results
  q: 'jones' // query for 'jones'
};
$.ajax({
  url: 'https://data.ontario.ca/en/api/3/action/datastore_search',
  data: data,
  dataType: 'jsonp',
  success: function(data) {
    alert('Total results found: ' + data.result.total)
  }
});
Example: Python »

A simple request to the data API using Python.

import urllib.request
url = 'https://data.ontario.ca/en/api/3/action/datastore_search?resource_id=dc378388-29de-46d5-9cfb-fe585da89aa0&limit=5'  
fileobj = urllib.request.urlopen(url)
print(fileobj.read())