CKAN 데이터 API

You can access resource data via a web API with powerful query support. 핵심 CKAN 데이터 API와 데이터스토어 문서참고.

데이터 API는 CKAN 액션 API의 다음 액션들을 통해 접근할 수 있습니다.

생성하기 https://data.wprdc.org/ko_KR/api/3/action/datastore_create
업데이트 / 추가 https://data.wprdc.org/ko_KR/api/3/action/datastore_upsert
질의 https://data.wprdc.org/ko_KR/api/3/action/datastore_search
질의 (via SQL) https://data.wprdc.org/ko_KR/api/3/action/datastore_search_sql
OData https://data.wprdc.org/es_AR/datastore/odata3.0/ecedb5a4-4e9d-469b-8cde-2673ee48c482

질의 예제 (첫 5개 결과)

https://data.wprdc.org/ko_KR/api/3/action/datastore_search?resource_id=ecedb5a4-4e9d-469b-8cde-2673ee48c482&limit=5

질의 예제 ('jones'을 포함하는 결과)

https://data.wprdc.org/ko_KR/api/3/action/datastore_search?resource_id=ecedb5a4-4e9d-469b-8cde-2673ee48c482&q=jones

질의 예제 (via SQL 문)

https://data.wprdc.org/ko_KR/api/3/action/datastore_search_sql?sql=SELECT * from "ecedb5a4-4e9d-469b-8cde-2673ee48c482" WHERE title LIKE 'jones'

OData example (first 5 results, skip 1)

https://data.wprdc.org/es_AR/datastore/odata3.0/ecedb5a4-4e9d-469b-8cde-2673ee48c482?$top=5&$skip=1

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

https://data.wprdc.org/es_AR/datastore/odata3.0/ecedb5a4-4e9d-469b-8cde-2673ee48c482?$top=5&$format=json

jQuery를 이용한 데이터 API에 간단한 ajax (JSONP) 요청.

          var data = {
            resource_id: 'ecedb5a4-4e9d-469b-8cde-2673ee48c482', // the resource id
            limit: 5, // get 5 results
            q: 'jones' // query for 'jones'
          };
          $.ajax({
            url: 'https://data.wprdc.org/ko_KR/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/ko_KR/api/3/action/datastore_search?resource_id=ecedb5a4-4e9d-469b-8cde-2673ee48c482&limit=5&q=title:jones'  
        fileobj = urllib.request.urlopen(url)
        print(fileobj.read())