---
title: "Get Implemented Opportunities Data"
method: GET
path: "/opportunities/implemented"
tags: ["OPPORTUNITIES"]
---

# Get Implemented Opportunities Data

`GET /opportunities/implemented`

List opportunities that were marked IMPLEMENTED.

Reads from the dedicated `implemented_opportunities` ClickHouse table
that survives the 1-month TTL on `individual_opportunities`. The main
GET `/opportunities/` endpoint is untouched — it still serves the
Active/Dismissed view from the original tables.

## Query parameters

- `page` integer, required
- `size` integer, required
- `effort` string[]
- `resource_name` string[]
- `resource_type` string[]
- `owner` integer[]
- `opportunity_name` string[]
- `start_date` string, date-time, nullable
- `end_date` string, date-time, nullable
- `sort` string
- `sort_order` string
- `instance_id` string[]
- `user` string[]
- `warehouse` string[]
- `database` string[]
- `schema` string[]
- `workspace_id` string[] — Databricks workspace IDs (multi-value). Sourced from the More-Filters Workspace chip; ignored on non-Databricks tenants.
- `navigationSource` string, nullable

## Headers

- `x-tenant` string, required

## Response `200`

Successful Response

- PageGetImplementedOpportunitiesDataResponse
  - `items` GetImplementedOpportunitiesDataResponse[], required
    - `opportunity_id` string, required
    - `instance_id` integer, required
    - `resource_name` string, required
    - `resource_type` 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24, required
    - `resource_uri` string, required
    - `opportunity_name` string, required
    - `description` string, nullable
    - `last_seen` string, date-time, required
    - `first_seen` string, date-time, required
    - `count` integer, required
    - `total_count` integer, nullable
    - `resources` AppSchemasOpportunitiesResource[], required
      - `resource_name` string, required
      - `resource_uri` string, required
      - `resource_type` 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24, required
    - `money_savings` object, required
    - `time_savings` string, required
    - `effort` 1 | 2 | 3, required
    - `owner` string, nullable
    - `status` 1 | 2 | 3 | 4, required
    - `redirect_url` string, nullable
    - `implemented_at` string, date-time, required
  - `total` integer, nullable, required
  - `page` integer, nullable, required
  - `size` integer, nullable, required
  - `pages` integer, nullable

## Other responses

- `400` — Not supported for public user
- `403` — Not supported for public user
- `422` — Validation Error

---

[API](https://skmtc.net/myaltimate/apis/fastapi.md) · [All operations](https://skmtc.net/myaltimate/apis/fastapi/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/myaltimate/fastapi/versions/aab3fe5c9f05/schema)