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.
Create | https://opendata.portdebarcelona.cat/en/api/3/action/datastore_create |
---|---|
Update / Insert | https://opendata.portdebarcelona.cat/en/api/3/action/datastore_upsert |
Query | https://opendata.portdebarcelona.cat/en/api/3/action/datastore_search |
Query (via SQL) | https://opendata.portdebarcelona.cat/en/api/3/action/datastore_search_sql |
https://opendata.portdebarcelona.cat/en/api/3/action/datastore_search?resource_id=8a553734-35ef-499d-a894-46b2a64bd489&limit=5
https://opendata.portdebarcelona.cat/en/api/3/action/datastore_search?q=jones&resource_id=8a553734-35ef-499d-a894-46b2a64bd489
https://opendata.portdebarcelona.cat/en/api/3/action/datastore_search_sql?sql=SELECT * from "8a553734-35ef-499d-a894-46b2a64bd489" WHERE title LIKE 'jones'
A simple ajax (JSONP) request to the data API using jQuery.
var data = { resource_id: '8a553734-35ef-499d-a894-46b2a64bd489', // the resource id limit: 5, // get 5 results q: 'jones' // query for 'jones' }; $.ajax({ url: 'https://opendata.portdebarcelona.cat/en/api/3/action/datastore_search', data: data, dataType: 'jsonp', success: function(data) { alert('Total results found: ' + data.result.total) } });
import urllib url = 'https://opendata.portdebarcelona.cat/en/api/3/action/datastore_search?resource_id=8a553734-35ef-499d-a894-46b2a64bd489&limit=5&q=title:jones' fileobj = urllib.urlopen(url) print fileobj.read()