CKAN Data API

You can access resource data via a web API with powerful query support. Further information in the main CKAN Data API and DataStore documentation.

De Data API kan worden benaderd via de volgende acties van de CKAN action API.

Creƫer https://data.wprdc.org/nl/api/3/action/datastore_create
Updaten / toevoegen https://data.wprdc.org/nl/api/3/action/datastore_upsert
Query https://data.wprdc.org/nl/api/3/action/datastore_search
Query (via SQL) https://data.wprdc.org/nl/api/3/action/datastore_search_sql
OData https://data.wprdc.org/pt_BR/datastore/odata3.0/6571ab50-5ad8-491a-8fc0-cd93e680b80e

Query voorbeeld (eerste 5 resultaten)

https://data.wprdc.org/nl/api/3/action/datastore_search?resource_id=6571ab50-5ad8-491a-8fc0-cd93e680b80e&limit=5

Query voorbeeld (resultaten die 'jones' bevatten)

https://data.wprdc.org/nl/api/3/action/datastore_search?resource_id=6571ab50-5ad8-491a-8fc0-cd93e680b80e&q=jones

Query voorbeeld (via SQL statement)

https://data.wprdc.org/nl/api/3/action/datastore_search_sql?sql=SELECT * from "6571ab50-5ad8-491a-8fc0-cd93e680b80e" WHERE title LIKE 'jones'

OData example (first 5 results, skip 1)

https://data.wprdc.org/pt_BR/datastore/odata3.0/6571ab50-5ad8-491a-8fc0-cd93e680b80e?$top=5&$skip=1

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

https://data.wprdc.org/pt_BR/datastore/odata3.0/6571ab50-5ad8-491a-8fc0-cd93e680b80e?$top=5&$format=json

Een eenvoudige ajax (JSONP) aanvraag naar de data API met jQuery.

          var data = {
            resource_id: '6571ab50-5ad8-491a-8fc0-cd93e680b80e', // the resource id
            limit: 5, // get 5 results
            q: 'jones' // query for 'jones'
          };
          $.ajax({
            url: 'https://data.wprdc.org/nl/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/nl/api/3/action/datastore_search?resource_id=6571ab50-5ad8-491a-8fc0-cd93e680b80e&limit=5&q=title:jones'  
        fileobj = urllib.request.urlopen(url)
        print(fileobj.read())