# Retrieves available values for a dynamic custom group criteria column

Returns distinct values for the specified criteria column. Use the returned values in the `criteriaList[].criteriaValue` array when calling [Create Dynamic CG](https://www.manageengine.com/products/desktop-central/help/api/cloud/custom-groups-create-dynamic-cg.html) or [Update Dynamic CG](https://www.manageengine.com/products/desktop-central/help/api/cloud/custom-groups-update-dynamic-cg.html). Fetch valid `columnId` values from [Get Dynamic CG Criteria Pattern](https://www.manageengine.com/products/desktop-central/help/api/cloud/custom-groups-get-dynamic-cgcriteria-pattern.html). Supports pagination via `rangeIndex`/`limit` and text filtering via `searchChar`. For software version columns, filter by software name using `softwareNameForVersion`.

## Endpoint

`GET /api/1.4/customgroup/dynamic/columnValues`

## Request URL

`https://`[{serverurl}](https://www.manageengine.com/products/desktop-central/help/api/cloud/oauth-authentication-endpoint-domain.html)`/api/1.4/customgroup/dynamic/columnValues`

## Scope

`DesktopCentralCloud.Common.READ`

## Header

`Authorization: Zoho-oauthtoken d92d4xxxxxxxxxxxxx15f52`

## Request Parameters

### Request Headers

- **Accept** (`string`, Mandatory): `application/json`
  - Must be `application/json`. Only JSON responses are supported.

### Query Parameters

- **columnId** (`long`, Mandatory)
  - ID of the criteria column whose values to retrieve. Fetch from [Get Dynamic CG Criteria Pattern](https://www.manageengine.com/products/desktop-central/help/api/cloud/custom-groups-get-dynamic-cgcriteria-pattern.html). Column IDs are instance-specific auto-generated values.
- **softwareNameForVersion** (`string`, Optional)
  - Software name to filter version values. Used when `columnId` refers to a software version column.
- **searchChar** (`string`, Optional)
  - Text filter applied to column values. Only values containing this string are returned.
- **rangeIndex** (`string`, Optional)
  - Pagination start index (1-based). Default: `1`
- **limit** (`string`, Optional)
  - Maximum number of values to return per page. Default: `30`

## Sample Request

```curl
curl --request GET \
  --url 'https://appdomains/api/1.4/customgroup/dynamic/columnValues?columnId=SOME_INTEGER_VALUE' \
  --header 'Accept: application/json' \
  --header 'Authorization: Zoho-oauthtoken  d92d4xxxxxxxxxxxxx15f52'
```

## Response Parameters

### HTTP Code 200

Response Body: `application/json`

- `message_type` (`string`): Always `'dynamic'` for this endpoint.
- `message_response` (`JSON Object`): Response payload container.
- `message_version` (`string`): API version: `'1.4'`.
- `status` (`string`): `'success'` when the request completed without errors.

### HTTP Code 500

Response Body: `application/json`

- `message_type` (`string`): Always `'dynamic'` for this endpoint.
- `message_version` (`string`): API version: `'1.4'`.
- `status` (`string`): Always `'error'` for error responses.
- `error_code` (`string`): Internal error code: `'1003'` (`INTERNAL_ERROR`).
- `error_description` (`string`): Resolved I18N message, typically: An internal error occurred while processing the request.

## Possible Response Codes

- **200**: HTTP code
- **500**: HTTP code

## Sample Response: HTTP 200

OS name values for `columnId` for `OS_NAME` (instance-specific).

```json
{
  "message_type": "dynamic",
  "message_response": {
    "dynamic": {
      "0": {
        "label": "Windows 11 Enterprise",
        "value": "Windows 11 Enterprise"
      },
      "1": {
        "label": "Windows 10 Pro",
        "value": "Windows 10 Pro"
      },
      "2": {
        "label": "Windows Server 2022 Standard",
        "value": "Windows Server 2022 Standard"
      },
      "3": {
        "label": "Ubuntu 22.04 LTS",
        "value": "Ubuntu 22.04 LTS"
      }
    }
  },
  "message_version": "1.4",
  "status": "success"
}
```

Software version values filtered by `softwareNameForVersion=Google Chrome`.

```json
{
  "message_type": "dynamic",
  "message_response": {
    "dynamic": {
      "0": {
        "label": "120.0.6099.130",
        "value": "120.0.6099.130"
      },
      "1": {
        "label": "119.0.6045.200",
        "value": "119.0.6045.200"
      }
    }
  },
  "message_version": "1.4",
  "status": "success"
}
```

No matching values found for the column and filters.

```json
{
  "message_type": "dynamic",
  "message_response": {
    "dynamic": {}
  },
  "message_version": "1.4",
  "status": "success"
}
```

## Sample Response: HTTP 500

Unexpected server-side failure retrieving column values.

```json
{
  "error_description": "An internal error occurred while processing the request.",
  "message_type": "dynamic",
  "error_code": "1003",
  "message_version": "1.4",
  "status": "error"
}
```

![](https://www.zohowebstatic.com/sites/zweb/images/people/ico-help.png)

**Duration:** 1 minute | **Threshold:** 30 | **Lock period:** 5 minutes

Duration - Time window for the threshold.
Threshold - Number of API calls allowed within the specified duration.
Lock Period - Wait time before consecutive API requests.