Connect Colorado Information Marketplace to Hellotracks

Both apps 25Colorado Information Marketplace 5Hellotracks 20

• 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
  Alert triggered

  Fires when a configured alert (late arrival, idle, zone entry/exit, low battery, etc.) triggers. Webhook key alert_triggered via /v1/webhooks or /api/setwebhooks (Hellotracks API).

• Trigger
  Completed Job

  Triggers when a job reaches a completed state.

• Trigger
  Member clocked in or out

  Fires when a worker turns location tracking on (clock-in) or off (clock-out) from the mobile app. Webhook key clock_in_out via /v1/webhooks or /api/setwebhooks (Hellotracks API).

• Trigger
  New Job

  Triggers when a job is created.

• Trigger
  Updated Job

  Triggers when a job is created, assigned, completed, archived, or otherwise updated.

• Action
  Add member

  Create a new team member (worker) account. POST /api/createaccount (Hellotracks API).

• Action
  Add place

  Create a new saved place/geofence. POST /api/createplace (Hellotracks API).

• Action
  Archive Job

  Archives a job by ID.

• Action
  Auto-assign jobs

  Automatically assign a set of unassigned jobs to available members. POST /api/autoassign (Hellotracks API).

• Action
  Create Job

  Creates or updates a job. If External ID matches an existing job, the existing job is updated.

• Action
  Delete Job

  Deletes a job by ID.

• Action
  Delete member

  Delete a team member account. POST /api/deleteaccount (Hellotracks API).

• Action
  Distribute job

  Assign/distribute one or more jobs to members for dispatch. POST /api/distributejobs (Hellotracks API).

• Action
  Find Member

  Finds a member by exact email, username, name, or UID.

• Action
  Generate report

  Generate a report (e.g. timesheet/activity) for a date range. POST /api/createreport (Hellotracks API); RPC-style call returning report data.

• Action
  Optimize route

  Compute an optimized route ordering for a member's assigned jobs. POST /api/routeoptimization (Hellotracks API); RPC-style call returning route data.

• Action
  Restore job

  Restore a previously archived job. POST /api/restorejobs (Hellotracks API).

• Action
  Update Job

  Updates a job by ID.

• Action
  Update member

  Edit an existing team member's fields. POST /api/editaccount (Hellotracks API).

• Action
  Update place

  Edit an existing saved place/geofence. POST /api/editplace (Hellotracks API).

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