Connect Colorado Information Marketplace to Freedcamp

Both apps 25Colorado Information Marketplace 5Freedcamp 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
  New Issue

  Triggers when a new issue is filed in Freedcamp's issue tracker. The project must have the Issue Tracker app enabled.

• Trigger
  New Milestone

  Triggers when a new milestone is created in Freedcamp. The project must have the Milestones app enabled.

• Trigger
  New Project Created

  Triggers when a new project is created in your Freedcamp account.

• Trigger
  Task Assigned to Me

  Triggers when a task assigned to you appears in Freedcamp.

• Trigger
  Task Completed

  Triggers when a Freedcamp task is marked completed.

• Action
  Add Comment

  Adds a comment to a Freedcamp task and returns the created comment, including its direct link.

• Action
  Add Discussion Comment

  Adds a comment to a Freedcamp discussion and returns the created comment, including its direct link.

• Action
  Create Project

  Creates a new Freedcamp project and returns it. Put it in an existing project group by ID, or name a group and Freedcamp creates it.

• Action
  Create Task

  Creates a task in a Freedcamp project and returns it, including its direct link. Optionally set the list, priority, assignee, dates, a parent task or a recurrence rule.

• Action
  Get Current User

  Returns the Freedcamp account the connection belongs to: the signed-in user's ID and profile, plus the projects and project groups they can see.

• Action
  Get Project

  Returns one Freedcamp project by ID, including its group, your role, the apps enabled on it, its members and any custom fields.

• Action
  Get Task

  Returns one Freedcamp task by ID, including its list, priority, status, assignee, dates and comments.

• Action
  Get Tasks

  Returns Freedcamp tasks, optionally filtered by project, status, assignee or due-date range. Custom field values are included.

• Action
  List Issues

  Returns issues from a Freedcamp project's issue tracker, optionally filtered by type, priority, status, assignee or due-date range. The project must have the Issue Tracker app enabled.

• Action
  List Milestones

  Returns milestones from Freedcamp, optionally filtered by project, status, assignee or due-date range. The project must have the Milestones app enabled.

• Action
  List Time Records

  Returns logged time records from Freedcamp, optionally filtered by project, user or date range. The project must have the Time Tracking app enabled.

• Action
  List Users

  Returns the Freedcamp users you share projects with, or just the members of one project when you supply a project ID.

• Action
  Notifications

  Returns the unread notifications for a Freedcamp project, optionally limited to items you follow.

• Action
  Show Projects

  Returns every Freedcamp project you can see, with its group, color, permissions and enabled apps.

• Action
  Update Task

  Updates an existing Freedcamp task. Only the fields you fill in are changed.

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