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

# Get Opportunities Data

`GET /opportunities/`

Get opportunities data.
:param db: The database session for accessing the database.
:param auth: The authorization token for the request.
:param opportunities_data_request: opportunities data request.
:return: ok status and optional message.

## Query parameters

- `page` integer, required
- `size` integer, required
- `override_global_opportunties_fetch_size` integer, nullable
- `effort` string[]
- `resource_name` string[]
- `resource_type` string[]
- `owner` integer[]
- `user` string[]
- `status` string[]
- `opportunity_name` string[]
- `secondary_resource` string[]
- `warehouse` string[]
- `start_date` string, date-time, required — Start date for filtering opportunities (ISO format)
- `end_date` string, date-time, required — End date for filtering opportunities (ISO format)
- `sort` string
- `sort_order` string
- `instance_id` 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

- PageGetOpportunitiesDataResponse
  - `items` GetOpportunitiesDataResponse[], 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
  - `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)