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.

Automate CKAN with Lodol.

Connect CKAN and ask your AI for your first workflow.

Free plan, no credit card