CKAN Data API

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.gov.ua/en/api/3/action/datastore_create

Update / Insert

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

Query

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

Query (via SQL)

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

Querying

Query example (first 5 results)

https://data.gov.ua/en/api/3/action/datastore_search?resource_id=001cb8b1-7100-4332-8ec2-3066586a23ba&limit=5

Query example (results containing 'jones')

https://data.gov.ua/en/api/3/action/datastore_search?resource_id=001cb8b1-7100-4332-8ec2-3066586a23ba&q=jones

Query example (via SQL statement)

https://data.gov.ua/en/api/3/action/datastore_search_sql?sql=SELECT * from "001cb8b1-7100-4332-8ec2-3066586a23ba" WHERE title LIKE 'jones'

Example: Javascript

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

  var data = {
    resource_id: '001cb8b1-7100-4332-8ec2-3066586a23ba', // the resource id
    limit: 5, // get 5 results
    q: 'jones' // query for 'jones'
  };
  $.ajax({
    url: 'https://data.gov.ua/en/api/3/action/datastore_search',
    data: data,
    dataType: 'jsonp',
    success: function(data) {
      alert('Total results found: ' + data.result.total)
    }
  });

Example: Python

import urllib
url = 'https://data.gov.ua/en/api/3/action/datastore_search?resource_id=001cb8b1-7100-4332-8ec2-3066586a23ba&limit=5&q=title:jones'  
fileobj = urllib.urlopen(url)
print fileobj.read()