API de données CKAN

Accédez aux données de la ressource via une API web supportant des requêtes puissantes. Pour plus d'information, consulter notre page API. CKAN offre aussi de la documentation sur l'API et le DataStore.

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

Create https://www.donneesquebec.ca/recherche/api/3/action/datastore_create
Update / Insert https://www.donneesquebec.ca/recherche/api/3/action/datastore_upsert
Query https://www.donneesquebec.ca/recherche/api/3/action/datastore_search
Query (via SQL) https://www.donneesquebec.ca/recherche/api/3/action/datastore_search_sql
Exemple de requête (5 premiers résultats)

https://www.donneesquebec.ca/recherche/api/3/action/datastore_search?resource_id=d2cf4211-5400-46a3-9186-a81e6cd41de9&limit=5

Exemple de requête (résultats contenant 'jones')

https://www.donneesquebec.ca/recherche/api/3/action/datastore_search?resource_id=d2cf4211-5400-46a3-9186-a81e6cd41de9&q=jones

Exemple de requête (via commande SQL)

https://www.donneesquebec.ca/recherche/api/3/action/datastore_search_sql?sql=SELECT * from "d2cf4211-5400-46a3-9186-a81e6cd41de9" WHERE title LIKE 'jones'

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

        var data = {
          resource_id: 'd2cf4211-5400-46a3-9186-a81e6cd41de9', // the resource id
          limit: 5, // get 5 results
          q: 'jones' // query for 'jones'
        };
        $.ajax({
          url: 'https://www.donneesquebec.ca/recherche/api/3/action/datastore_search',
          data: data,
          dataType: 'jsonp',
          success: function(data) {
            alert('Total results found: ' + data.result.total)
          }
        });
      import urllib
      url = 'https://www.donneesquebec.ca/recherche/api/3/action/datastore_search?resource_id=d2cf4211-5400-46a3-9186-a81e6cd41de9&limit=5&q=title:jones'  
      fileobj = urllib.urlopen(url)
      print fileobj.read()