Connect Colorado Information Marketplace to NHL Records and Stats

Both apps 18Colorado Information Marketplace 5NHL Records and Stats 13

• 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).

• Action
  Find draft picks

  Search historical NHL draft picks, filterable by draft year, drafting team, and round number.

• Action
  Find player milestones

  Find players meeting a career or single-season milestone (e.g. 1000-point career, 500-goal career, 100-point season, 50-goal season, 5-goal game).

• Action
  Find playoff series

  Search game-by-game data for a specific playoff round and season (e.g. Stanley Cup Final).

• Action
  Get attendance records

  Return league-wide season attendance records, split into regular-season and playoff attendance.

• Action
  Get franchise detail

  Return a franchise's captain history, coaching history, general manager history, and retired numbers.

• Action
  Get franchise record vs another franchise

  Return a franchise's all-time regular-season record against every other team in the league.

• Action
  Get franchise team totals

  Return cumulative all-time stats (wins, losses, ties, road/home splits, etc) for every franchise.

• Action
  Get playoff record vs another franchise

  Return a franchise's all-time playoff record against every other team in the league.

• Action
  List franchises

  List every franchise in NHL history with its id, name, and first/last season.

• Action
  List franchise season results

  List every season's win/loss result for a specific franchise, sortable by season.

• Action
  List officials

  List NHL officials, optionally filtered to only currently active officials.

• Action
  List players by team

  List every player who has played for a specified team.

• Action
  List trophies

  List every NHL trophy with its description and image.

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