API de datos do CKAN

Acceso ao recurso de datos mediante unha API web con servizo completo de consulta. Further information in the main CKAN Data API and DataStore documentation.

Puntos de acceso »

A API de Datos é accesíbel mediante as seguintes accións da API de acción do CKAN.

Crear https://data.santamonica.gov/gl/api/3/action/datastore_create
Actualizar / Inserir https://data.santamonica.gov/gl/api/3/action/datastore_upsert
Consulta https://data.santamonica.gov/gl/api/3/action/datastore_search
Consulta (con SQL) https://data.santamonica.gov/gl/api/3/action/datastore_search_sql

OData https://data.santamonica.gov/it/datastore/odata3.0/f3a4e0d3-1cbb-4f97-9e52-fa178a133ebe
Consultando »
Exemplo de consulta (primeiros cinco resultados)

https://data.santamonica.gov/gl/api/3/action/datastore_search?resource_id=f3a4e0d3-1cbb-4f97-9e52-fa178a133ebe&limit=5

Exemplo de consulta (resultados contendo «jones»)

https://data.santamonica.gov/gl/api/3/action/datastore_search?resource_id=f3a4e0d3-1cbb-4f97-9e52-fa178a133ebe&q=jones

Consulta exemplo (con sentencia SQL)

https://data.santamonica.gov/gl/api/3/action/datastore_search_sql?sql=SELECT * from "f3a4e0d3-1cbb-4f97-9e52-fa178a133ebe" WHERE "title" LIKE 'jones'

OData example (first 5 results, skip 1)

https://data.santamonica.gov/it/datastore/odata3.0/f3a4e0d3-1cbb-4f97-9e52-fa178a133ebe?$top=5&$skip=1

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

https://data.santamonica.gov/it/datastore/odata3.0/f3a4e0d3-1cbb-4f97-9e52-fa178a133ebe?$top=5&$format=json

Exemplo: Javascript »

Unha consulta ajax (JSONP) sinxela á API de datos usando jQuery.

var data = {
  resource_id: 'f3a4e0d3-1cbb-4f97-9e52-fa178a133ebe', // the resource id
  limit: 5, // get 5 results
  q: 'jones' // query for 'jones'
};
$.ajax({
  url: 'https://data.santamonica.gov/gl/api/3/action/datastore_search',
  data: data,
  dataType: 'jsonp',
  success: function(data) {
    alert('Total results found: ' + data.result.total)
  }
});
Exemplo: Python » 
import json
import urllib.request
url = 'https://data.santamonica.gov/gl/api/3/action/datastore_search?resource_id=f3a4e0d3-1cbb-4f97-9e52-fa178a133ebe&limit=5&q=title:jones'  
fileobj = urllib.request.urlopen(url)
response_dict = json.loads(fileobj.read())
print(response_dict)