Connect Colorado Information Marketplace to SendGrid

Both apps 19Colorado Information Marketplace 5SendGrid 14

• 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 bounce

  Polls the v3 Suppression Bounces API for bounced email addresses. Emits one record per bounce.

• Trigger
  New global suppression

  Polls the v3 Suppressions API for globally-suppressed (unsubscribed) email addresses. Emits one record per suppressed email.

• Trigger
  New or updated recipient

  Triggered when a recipient is created or updated.

• Trigger
  New suppressed email

  Triggered when a new email is suppressed.

• Action
  Add to suppression group

  Add a recipient's email to a SendGrid suppression group (unsubscribe group). POST /v3/asm/groups/{group_id}/suppressions.

• Action
  Create custom field

  Creates a new custom field.

• Action
  Create list

  Creates a new marketing contact list via the v3 Marketing Lists API.

• Action
  Create or update contact

  Adds or updates a marketing contact (upsert by email) via the v3 Marketing Contacts API. Optionally assigns to lists.

• Action
  Create or update recipient

  Creates a new recipient if the email does not exist, otherwise updates the existing recipient.

• Action
  Delete contacts

  Deletes one or more marketing contacts by their contact IDs via the v3 Marketing Contacts API.

• Action
  Get contact by email

  Looks up a marketing contact by email address via the v3 Marketing Contacts search-by-emails endpoint.

• Action
  Remove from suppression group

  Remove a recipient's email from a SendGrid suppression group (unsubscribe group). DELETE /v3/asm/groups/{group_id}/suppressions/{email}. Returns 204 No Content on success.

• Action
  Send an email

  Sends an email via the v3 Mail Send API to a single recipient with subject and plain-text or HTML body.

• Action
  Send an email using template

  Sends an email via the v3 Mail Send API using a dynamic template ID. Dynamic template data is passed as a JSON object.

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