Connect Colorado Information Marketplace to Open Government, Spain

Both apps 21Colorado Information Marketplace 5Open Government, Spain 16

• Trigger
  New record

  Polling trigger: fires when a new row appears in a specified Colorado Information Marketplace (Socrata SODA API) dataset. GET https://data.colorado.gov/resource/{dataset_id}.json ordered by a rowid/created/updated system field ($order=:id DESC or an updated_at column) with $limit, dedup by the row's system id (:id) or an updated_at watermark since datasets vary in whether they expose a stable update timestamp column.

• Action
  Find datasets

  Search the Colorado Information Marketplace open-data catalog for datasets by keyword/category. GET https://data.colorado.gov/api/catalog/v1?q={query}&limit=... (Socrata Discovery API) returning dataset id, name, description, category, and update timestamps. Used to locate the dataset identifier that other ops (List/Get/Find records) require as input.

• Action
  Find records by criteria

  Query a Colorado Information Marketplace (Socrata SODA API) dataset with a SoQL $where/$select/$order filter. GET https://data.colorado.gov/api/v3/views/{dataset_id}/query.json (or resource/{dataset_id}.json on older SODA2 endpoints) with SoQL query params ($where, $select, $order, $limit, $offset). Requires the dataset identifier (8-char alphanumeric, e.g. ydr8-5enu) as input plus the SoQL clauses.

• Action
  Get record

  Get a single row from a Colorado Information Marketplace (Socrata SODA API) dataset by its row identifier. GET https://data.colorado.gov/resource/{dataset_id}/{row_id}.json (or a $where=:id='{row_id}' query when the dataset has no explicit row identifier). Requires dataset_id and row_id.

• Action
  List records

  List all rows in a Colorado Information Marketplace (Socrata SODA API) dataset, paginated. GET https://data.colorado.gov/resource/{dataset_id}.json with $limit/$offset params. Requires the dataset identifier (8-char alphanumeric, e.g. ydr8-5enu).

• Trigger
  New dataset

  Poll for datasets newly added to the catalogue.

• Action
  Find datasets by format

  Search datasets that have a distribution in a specific file format (e.g. csv).

• Action
  Find datasets by geographic scope

  Search datasets covering a specific geographic area.

• Action
  Find datasets by keyword

  Search datasets tagged with a specific keyword.

• Action
  Find datasets by publisher

  Search datasets published by a specific government publisher identifier.

• Action
  Find datasets by theme

  Search datasets belonging to a specific category or topic.

• Action
  Find datasets by title

  Search datasets whose title matches or contains the given text.

• Action
  Find datasets modified between dates

  Search datasets that were last modified within a given date range.

• Action
  Find distributions by dataset

  Retrieve the distributions belonging to a specific dataset.

• Action
  Find distributions by format

  Search distributions available in a specific file format.

• Action
  Get dataset

  Retrieve a single dataset by its unique catalogue identifier.

• Action
  List categories

  List all categories/topics that have datasets in the catalogue.

• Action
  List datasets

  List all datasets in the Spain open government data catalogue, with sorting and pagination.

• Action
  List distributions

  List all data distributions (downloadable files/resources) in the catalogue.

• Action
  List geographic scopes

  List all geographic coverage areas that have datasets in the catalogue.

• Action
  List publishers

  List all publishing organizations present in the catalogue.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.