CKAN Data API

Further information in the main CKAN Data API and DataStore documentation.

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

Create

https://test.data.gov.ua/en/api/3/action/datastore_create

Update / Insert

https://test.data.gov.ua/en/api/3/action/datastore_upsert

Query

https://test.data.gov.ua/en/api/3/action/datastore_search

Query (via SQL)

https://test.data.gov.ua/en/api/3/action/datastore_search_sql

Query example (first 5 results)

https://test.data.gov.ua/en/api/3/action/datastore_search?resource_id=66ed71d9-e901-4e2e-aae6-bfa04b77799e&limit=5

Query example (results containing 'jones')

https://test.data.gov.ua/en/api/3/action/datastore_search?resource_id=66ed71d9-e901-4e2e-aae6-bfa04b77799e&q=jones

Query example (via SQL statement)

https://test.data.gov.ua/en/api/3/action/datastore_search_sql?sql=SELECT * from "66ed71d9-e901-4e2e-aae6-bfa04b77799e" WHERE title LIKE 'jones'

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

  var data = {
    resource_id: '66ed71d9-e901-4e2e-aae6-bfa04b77799e', // the resource id
    limit: 5, // get 5 results
    q: 'jones' // query for 'jones'
  };
  $.ajax({
    url: 'https://test.data.gov.ua/en/api/3/action/datastore_search',
    data: data,
    dataType: 'jsonp',
    success: function(data) {
      alert('Total results found: ' + data.result.total)
    }
  });
import urllib
url = 'https://test.data.gov.ua/en/api/3/action/datastore_search?resource_id=66ed71d9-e901-4e2e-aae6-bfa04b77799e&limit=5&q=title:jones'  
fileobj = urllib.urlopen(url)
print fileobj.read()