Connect Colorado Information Marketplace to Ortto

Both apps 19Colorado Information Marketplace 5Ortto 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
  Fields Updated

  Triggers when the specified field(s) of a record have been updated in your Ortto account.

• Trigger
  New Activity Occurred

  Triggers when a new Ortto activity occurs.

• Trigger
  New Record Created

  Triggers when a new record (contact or organization) has been added to your Ortto account.

• Trigger
  Tag Added/Removed

  Triggers when a tag has beed added to, or removed from, a record.

• Action
  Add Custom Field

  Create a new custom field on the person or organization schema in Ortto. Endpoint: POST /v1/custom-field/create. Vendor doc: https://help.ortto.com/developer/latest/api-reference/custom-field/

• Action
  Create Record

  Create a new record (person, organization), or update an existing record in your Ortto account.

• Action
  Delete Record

  Archive, restore, or permanently delete a person or organization record in Ortto. Endpoint: POST /v1/person/delete (and /v1/organization/delete for accounts). Vendor doc: https://help.ortto.com/a-260-archive-restore-and-delete-people-archive-restore-delete

• Action
  Get Record

  Fetches one or more people, or one or more accounts, by their Ortto ids, returning whichever fields you ask for.

• Action
  List Activities

  Retrieve the activity feed for a given contact in Ortto. Endpoint: POST /v1/person/activities/list (activity log for a contact ID). Vendor doc: https://help.ortto.com/a-773-retrieve-activity-feed-for-a-given-contact

• Action
  Opt Out From SMS

  Opt out a person from all SMS communications.

• Action
  Search or Create Records

  Search your Ortto data for a record based on the provided field or optionally create one if none is found.

• Action
  Tag/Untag Records

  Adds or removes tags on a person or an account in Ortto, matching the record by email address or account name.

• Action
  Unsubscribe a Person

  Unsubscribe a person from all emails.

• Action
  Update Audience Subscription

  Subscribe or unsubscribe a person to/from an Ortto audience. Endpoint: POST /v1/audience/subscribe. Vendor doc: https://help.ortto.com/developer/latest/api-reference/audiences/

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