CKAN Dados API

O acesso ao recurso dados através de um API na internet é um apoio de consulta poderoso. 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://dados.sidekickhero.co/pt_PT/api/3/action/datastore_create
Update / Insert https://dados.sidekickhero.co/pt_PT/api/3/action/datastore_upsert
Query https://dados.sidekickhero.co/pt_PT/api/3/action/datastore_search
Query (via SQL) https://dados.sidekickhero.co/pt_PT/api/3/action/datastore_search_sql

Query exemplo (os 5 primeiros resultados)

https://dados.sidekickhero.co/pt_PT/api/3/action/datastore_search?resource_id=2236d75a-403c-476c-b3a1-13d9f242dae6&limit=5

Query exemplo (resultados que contenham 'jones')

https://dados.sidekickhero.co/pt_PT/api/3/action/datastore_search?resource_id=2236d75a-403c-476c-b3a1-13d9f242dae6&q=jones

Query exemplo (via instrução SQL)

https://dados.sidekickhero.co/pt_PT/api/3/action/datastore_search_sql?sql=SELECT * from "2236d75a-403c-476c-b3a1-13d9f242dae6" WHERE title LIKE 'jones'

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

          var data = {
            resource_id: '2236d75a-403c-476c-b3a1-13d9f242dae6', // the resource id
            limit: 5, // get 5 results
            q: 'jones' // query for 'jones'
          };
          $.ajax({
            url: 'https://dados.sidekickhero.co/pt_PT/api/3/action/datastore_search',
            data: data,
            dataType: 'jsonp',
            success: function(data) {
              alert('Total results found: ' + data.result.total)
            }
          });
        import urllib.request
        url = 'https://dados.sidekickhero.co/pt_PT/api/3/action/datastore_search?resource_id=2236d75a-403c-476c-b3a1-13d9f242dae6&limit=5&q=title:jones'  
        fileobj = urllib.request.urlopen(url)
        print(fileobj.read())