Connect Colorado Information Marketplace to HappyFox Chat

Both apps 16Colorado Information Marketplace 5HappyFox Chat 11

• 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
  Finished Chat

  Triggered when a chat in HappyFox Chat ends and its transcript is created.

• Trigger
  New Missed Chat

  Triggered when a chat in HappyFox Chat ends without an agent answering it.

• Trigger
  New Offline Message

  Triggered when a visitor leaves an offline message in HappyFox Chat.

• Action
  Get agent

  Returns one HappyFox Chat agent by ID, with their name, display name, email, timezone and permissions.

• Action
  Get department

  Returns one HappyFox Chat department by ID, with its name, chat profile and assigned agents.

• Action
  List agents

  Returns the agents on your HappyFox Chat account, with their names, emails, timezones and permissions.

• Action
  List canned responses

  Returns the canned responses on your HappyFox Chat account, with their text and the shortcuts agents type to insert them.

• Action
  List departments

  Returns the departments on your HappyFox Chat account, with their names and the agents assigned to each.

• Action
  List offline messages

  Returns the offline messages visitors left in HappyFox Chat while no agent was available.

• Action
  List transcripts

  Returns chat transcripts from HappyFox Chat, optionally narrowed by agent, visitor, department, chat profile or date range.

• Action
  List visitors

  Returns the visitors known to your HappyFox Chat account, with their contact details and browsing information.

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