---
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 | 25 | 26 | 27 | 28, 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 | 25 | 26 | 27 | 28, 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
    - `attribution_start_date` string, date-time, nullable
    - `attribution_end_date` string, date-time, nullable
  - `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

## Changes

- **2026-08-25** `64fc5b1ea2a2` — 8 warning
  - added the new `25.00` enum value to the `items/items/resource_type` response property for the response status `200`
  - added the new `25.00` enum value to the `items/items/resources/items/resource_type` response property for the response status `200`
  - added the new `26.00` enum value to the `items/items/resource_type` response property for the response status `200`
  - added the new `26.00` enum value to the `items/items/resources/items/resource_type` response property for the response status `200`
  - …4 more
- **2026-08-12** `a71fce1f5c26` — 2 info
  - added the optional property `items/items/attribution_end_date` to the response with the `200` status
  - added the optional property `items/items/attribution_start_date` to the response with the `200` status
- **2026-08-08** `103580dad816` — 1 info
  - added the optional property `items/items/redirect_url` to the response with the `200` status

[Change history](https://skmtc.dev/myaltimate/apis/fastapi/changes/opportunities/implemented/get.md)

---

[API](https://skmtc.dev/myaltimate/apis/fastapi.md) · [All operations](https://skmtc.dev/myaltimate/apis/fastapi/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/myaltimate/fastapi/revisions/82206441f16e/schema)