CKAN資料API

透過一擁有強大查詢功能支援的網路API來存取資源之資料. 進一步的資訊位於 CKAN Data API 及 DataStore 文件.

終端點 »

可使用下列之CKAN action API所提供的功能來存取資料API。

建立 https://data.santamonica.gov/zh_Hant_TW/api/3/action/datastore_create
更新 / 插入 https://data.santamonica.gov/zh_Hant_TW/api/3/action/datastore_upsert
查詢 https://data.santamonica.gov/zh_Hant_TW/api/3/action/datastore_search
查詢 (透過SQL) https://data.santamonica.gov/zh_Hant_TW/api/3/action/datastore_search_sql

OData https://data.santamonica.gov/zh_Hant_TW/datastore/odata3.0/8870b481-c698-4d10-b4f6-9fc0b8a7387b
查詢 »
查詢之範例 (前5個結果)

https://data.santamonica.gov/zh_Hant_TW/api/3/action/datastore_search?resource_id=8870b481-c698-4d10-b4f6-9fc0b8a7387b&limit=5

查詢之範例 (包含字串 'jones' 的結果)

https://data.santamonica.gov/zh_Hant_TW/api/3/action/datastore_search?resource_id=8870b481-c698-4d10-b4f6-9fc0b8a7387b&q=jones

查詢之範例 (透過SQL指令敘述)

https://data.santamonica.gov/zh_Hant_TW/api/3/action/datastore_search_sql?sql=SELECT * from "8870b481-c698-4d10-b4f6-9fc0b8a7387b" WHERE "title" LIKE 'jones'

OData example (first 5 results, skip 1)

https://data.santamonica.gov/zh_Hant_TW/datastore/odata3.0/8870b481-c698-4d10-b4f6-9fc0b8a7387b?$top=5&$skip=1

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

https://data.santamonica.gov/zh_Hant_TW/datastore/odata3.0/8870b481-c698-4d10-b4f6-9fc0b8a7387b?$top=5&$format=json

範例：Javascript »

使用jQuery對資料API發出一個簡單的ajax(JSONP)請求。

var data = {
  resource_id: '8870b481-c698-4d10-b4f6-9fc0b8a7387b', // the resource id
  limit: 5, // get 5 results
  q: 'jones' // query for 'jones'
};
$.ajax({
  url: 'https://data.santamonica.gov/zh_Hant_TW/api/3/action/datastore_search',
  data: data,
  dataType: 'jsonp',
  success: function(data) {
    alert('Total results found: ' + data.result.total)
  }
});
範例：Python » 
import json
import urllib.request
url = 'https://data.santamonica.gov/zh_Hant_TW/api/3/action/datastore_search?resource_id=8870b481-c698-4d10-b4f6-9fc0b8a7387b&limit=5&q=title:jones'  
fileobj = urllib.request.urlopen(url)
response_dict = json.loads(fileobj.read())
print(response_dict)