Connect Colorado Information Marketplace to Freshworks CRM

Both apps 28Colorado Information Marketplace 5Freshworks CRM 23

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

  Polling trigger: fires when a new sales account is created. Sorted by created_at descending.

• Trigger
  New Contact

  Polling trigger: fires when a new contact is created. Sorted by created_at descending.

• Trigger
  New Deal

  Polling trigger: fires when a new deal is created. Sorted by created_at descending.

• Trigger
  New or Updated Account

  Polling trigger: fires when a sales account is created or updated. Sorted by updated_at descending.

• Trigger
  New or Updated Contact

  Polling trigger: fires when a contact is created or updated. Sorted by updated_at descending.

• Trigger
  New or Updated Deal

  Polling trigger: fires when a deal is created or updated. Sorted by updated_at descending.

• Action
  Add Note to Contact

  Adds a note to a contact (targetable_type=Contact) in Freshworks CRM.

• Action
  Create Account

  Creates a new sales account in Freshworks CRM.

• Action
  Create Appointment

  Creates an appointment in Freshworks CRM. from_date/end_date are ISO8601.

• Action
  Create Contact

  Creates a new contact in Freshworks CRM.

• Action
  Create Deal

  Creates a new deal in Freshworks CRM.

• Action
  Create Task

  Creates a task in Freshworks CRM. due_date is epoch milliseconds; targetable_type e.g. Contact/Deal/SalesAccount.

• Action
  Find Account by Name

  Looks up a sales account by name using the lookup endpoint.

• Action
  Find Contact by Email

  Looks up a contact by email address using the lookup endpoint.

• Action
  Find deal by custom field

  Searches for a deal by the selected custom field. If a single match is found, emits the deal's details. If none or multiple match, an error occurs.

• Action
  Find deal by name

  Searches for a deal by name. If a single match is found, emits the deal's details. If none or multiple match, an error occurs.

• Action
  Find deal stage by name

  Searches for a deal stage by name. If a single match is found, emits the stage's details. If none or multiple match, an error occurs.

• Action
  Find pipeline by name

  Searches for a pipeline by name. If a single match is found, emits the pipeline's details. If none or multiple match, an error occurs.

• Action
  Get Account

  Retrieves a sales account by ID in Freshworks CRM.

• Action
  Get Contact

  Retrieves a contact by ID in Freshworks CRM.

• Action
  Get Deal

  Retrieves a deal by ID in Freshworks CRM.

• Action
  Update Contact

  Updates an existing contact by ID in Freshworks CRM.

• Action
  Update Deal

  Updates an existing deal by ID in Freshworks CRM.

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