Connect Roam to Colorado Information Marketplace

Both apps 17Roam 12Colorado Information Marketplace 5

• Trigger
  Lobby Booked

  Triggers when a lobby is booked.

• Trigger
  New Recording

  Triggers when a new meeting recording is saved in your Roam.

• Trigger
  New Transcript

  Triggers when a new transcript is saved in your Roam.

• Trigger
  On-Air: Event Created

  Triggers when a new On-Air event is created.

• Trigger
  On-Air: Guest Added

  Triggers when a guest is added to an On-Air event.

• Trigger
  On-Air: Guest RSVP Changed

  Triggers when a guest changes their RSVP status on an On-Air event.

• Action
  Create Meeting Link

  Creates a new Roam meeting link and returns its ID and shareable URL. Optionally set the host's email and the meeting's start and end times.

• Action
  Find User by Email

  Looks up a member of your Roam organization by their email address and returns their profile, including user ID, name, photo and admin status.

• Action
  On-Air: Add Guest

  Adds a guest to a Roam On-Air event by email, optionally setting their name, phone and RSVP status, and returns the created guest.

• Action
  On-Air: Find Event

  Returns the On-Air events whose title contains the text you search for, taken from your most recent events. Returns an empty list when nothing matches.

• Action
  Send Channel Message

  Posts a message to a Roam channel and returns the message's timestamp, which you can reuse to reply in the same thread.

• Action
  Send Direct Message

  Sends a direct message to one person in Roam and returns the conversation ID plus the message's timestamp, which you can reuse to reply in the same thread.

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

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