Date API CKAN

You can access resource data via a web API with powerful query support. 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.

Crează https://data.wprdc.org/ro/api/3/action/datastore_create
Actualizează / Introduce https://data.wprdc.org/ro/api/3/action/datastore_upsert
Query https://data.wprdc.org/ro/api/3/action/datastore_search
Query (via SQL) https://data.wprdc.org/ro/api/3/action/datastore_search_sql
OData https://data.wprdc.org/en/datastore/odata3.0/0b520f07-3f9d-48ce-8e9e-039cddd28417

Query example (first 5 results)

https://data.wprdc.org/ro/api/3/action/datastore_search?resource_id=0b520f07-3f9d-48ce-8e9e-039cddd28417&limit=5

Query example (results containing 'jones')

https://data.wprdc.org/ro/api/3/action/datastore_search?resource_id=0b520f07-3f9d-48ce-8e9e-039cddd28417&q=jones

Query example (via SQL statement)

https://data.wprdc.org/ro/api/3/action/datastore_search_sql?sql=SELECT * from "0b520f07-3f9d-48ce-8e9e-039cddd28417" WHERE title LIKE 'jones'

OData example (first 5 results, skip 1)

https://data.wprdc.org/en/datastore/odata3.0/0b520f07-3f9d-48ce-8e9e-039cddd28417?$top=5&$skip=1

OData example (first 5 results, return as OData JSON)

https://data.wprdc.org/en/datastore/odata3.0/0b520f07-3f9d-48ce-8e9e-039cddd28417?$top=5&$format=json

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

          var data = {
            resource_id: '0b520f07-3f9d-48ce-8e9e-039cddd28417', // the resource id
            limit: 5, // get 5 results
            q: 'jones' // query for 'jones'
          };
          $.ajax({
            url: 'https://data.wprdc.org/ro/api/3/action/datastore_search',
            data: data,
            dataType: 'jsonp',
            success: function(data) {
              alert('Total results found: ' + data.result.total)
            }
          });
        import urllib.request
        url = 'https://data.wprdc.org/ro/api/3/action/datastore_search?resource_id=0b520f07-3f9d-48ce-8e9e-039cddd28417&limit=5&q=title:jones'  
        fileobj = urllib.request.urlopen(url)
        print(fileobj.read())