Skip to content

jqnatividad/ckanext-odata

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

43 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

ckanext-odata

This CKAN extension provides a basic OData 3.0 endpoint for CKAN. This allows it to talk to tools like Microsoft Power BI and the FREE Tableau Public for awesome visualizations using data from CKAN!

The endpoint requires data to be held in the CKAN Datastore. An OData Endpoint link is added to resources, showing up as an additional endpoint when the Data API button is pressed.

Usage

This fork supports the following OData parameters:

  • $skip - number of records to skip from top (default: 0)
  • $top - number of records to return (default:500)

The OData standard also specifies support for the $filter clause. However, implementing one is non-trivial as its a dialect that doesn't directly map to PostgreSQL.

Instead, we implemented a $sqlfiter clause, where the user can specify a PostgreSQL where clause. In our view, this is actually a more powerful implementation as the user has full access to PostgreSQL's filtering capabilities which is a superset of the OData $filter clause.

Note: $sqlfilter is mutually exclusive to the $skip and $top parameters, as you can specify skip/top functionality using SQL primitives (e.g. $top -> limit in SQL; $skip -> offset in SQL)

Installation

Installation as standard for CKAN. This extension can be enabled by adding odata to the plugin line in the CKAN configuration file.

About

CKAN OData support to connect to tools like Tableau

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Python 54.1%
  • HTML 45.9%