All integrationsGovernment & Public Data
CKAN
Read open data from any CKAN portal, the software behind hundreds of government and city data sites: search and read datasets, files, organizations, groups and tags, and query table rows by search or SQL.
- actions
- 12
Actions
Steps a workflow can run in CKAN.
- Search datasetsFind datasets on a CKAN portal by words, publisher, tag, file format or group.
- Get a datasetGet a dataset's details and its resources: each file or link, with its download address.
- List datasetsList the names of all a portal's public datasets, in name order.
- List organizationsList the organizations that publish on a portal, such as a city's departments, with how many datasets each has.
- Get an organizationGet one organization's details and how many datasets it has.
- List groupsList a portal's groups: themed collections of datasets, such as Transportation or Health.
- Get a groupGet one group's details and how many datasets it has.
- List tagsList the tags used on a portal's datasets, or those containing some text.
- Get a resourceGet one of a dataset's resources (a file or link): its format, size, download address and whether its rows can be searched.
- Search a resource's recordsRead the rows of a table the portal holds in its DataStore: search them by words, match columns exactly, choose columns and sort. Not every portal has a DataStore.
- Run a SQL queryQuery a portal's DataStore tables with a read-only SQL SELECT, to count, group or join rows. Name a table by its resource id in double quotes. Many portals turn this off.
- Get portal infoCheck a portal is up and see its name, CKAN version and whether it has a DataStore for searching rows.
No actions match that.
Automate CKAN with Lodol.
Connect CKAN and ask your AI for your first workflow.
Free plan, no credit card