CKAN datu API

Piekļut resursu datiem izmantojot tīmekļa API ar spēcīgu vaicājumu atbalstu. Further information in the main CKAN Data API and DataStore documentation.

Data API var piekļūt, izmantojot sekojošas CKAN API darbības.

Izveidot https://dati.arpae.it/lv/api/3/action/datastore_create
Atjaunināt / Ievietot https://dati.arpae.it/lv/api/3/action/datastore_upsert
Vaicājums https://dati.arpae.it/lv/api/3/action/datastore_search
Vaicājums (caur SQL) https://dati.arpae.it/lv/api/3/action/datastore_search_sql

Vaicājumu piemērs (pirmie 5 rezultāti)

https://dati.arpae.it/lv/api/3/action/datastore_search?resource_id=5ade79d3-709a-4306-afcb-f58c8b4b42d0&limit=5

Vaicājumu piemērs (rezultāti, kas satur "Jones")

https://dati.arpae.it/lv/api/3/action/datastore_search?resource_id=5ade79d3-709a-4306-afcb-f58c8b4b42d0&q=jones

Vaicājumu piemērs (caur SQL apgalvojumu)

https://dati.arpae.it/lv/api/3/action/datastore_search_sql?sql=SELECT * from "5ade79d3-709a-4306-afcb-f58c8b4b42d0" WHERE title LIKE 'jones'

Vienkāršs ajax (JSONP) API datu pieprasījums, izmantojot jQuery.

          var data = {
            resource_id: '5ade79d3-709a-4306-afcb-f58c8b4b42d0', // the resource id
            limit: 5, // get 5 results
            q: 'jones' // query for 'jones'
          };
          $.ajax({
            url: 'https://dati.arpae.it/lv/api/3/action/datastore_search',
            data: data,
            dataType: 'jsonp',
            success: function(data) {
              alert('Total results found: ' + data.result.total)
            }
          });
        import urllib.request
        url = 'https://dati.arpae.it/lv/api/3/action/datastore_search?resource_id=5ade79d3-709a-4306-afcb-f58c8b4b42d0&limit=5&q=title:jones'  
        fileobj = urllib.request.urlopen(url)
        print(fileobj.read())