# Retrieves custom report data for a particular custom report id

This API returns the metadata and data for a specific custom report. Include the [report viewname](https://www.manageengine.com/products/desktop-central/help/api/onpremise/report-create-custom-report.html) in the VIEWNAME field to retrieve the required report.

## Endpoint

`POST /{CRVIEW_VIEWNAME}.ec`

## Request

### Request URL

```text
https://{server-hostname}:8383/{CRVIEW_VIEWNAME}.ec
```

### Scope

```text
CustomReport.READ
```

### Header

```text
Authorization: d92d4xxxxxxxxxxxxx15f52
```

### Request Parameters

#### Path Parameters

- **CRVIEW_VIEWNAME** `string` — Mandatory

  The [unique viewName](https://www.manageengine.com/products/desktop-central/help/api/onpremise/createcustomreport.html) of the created custom report.

### Sample Request

```curl
curl --request POST \
  --url https://appdomain/{CRVIEW_VIEWNAME}.ec \
  --header 'Authorization:  d92d4xxxxxxxxxxxxx15f52'
```

## Response

### HTTP Code 200

#### Response Body

`application/json`

`JSON object`

- **headers** `JSON array` — Defines the column metadata for the table.
- **rowSelection** `string` — Specifies how rows can be selected.
- **data** `JSON array` — Holds the actual row data with values for each column.
- **isExportEnabled** `boolean` — Indicates whether the table can be exported.
- **showHeader** `boolean` — Determines if the column headers should be displayed.
- **numFixedColumns** `integer` — Number of fixed columns.
- **isAdvancedSearch** `boolean` — Shows whether advanced search is enabled.
- **showNavig** `boolean` — Specifies if navigation controls (pagination UI) are shown.
- **navigation** `JSON object` — Contains pagination and navigation-related information.
- **templateName** `string` — Template applied to render the table.
- **colList** `JSON array` — List of available columns with visibility, sortability, and display properties.
- **SQLTable** `boolean` — Indicates if the data originates from an SQL table.
- **isSearchPresent** `boolean` — Shows whether a search option is available.
- **rowHover** `boolean` — Enables highlighting when hovering over rows.
- **sortOrder** `boolean` — Specifies if sorting is enabled.
- **name** `string` — Unique identifier/name of the table view.
- **isScrollTable** `boolean` — Indicates if the table supports scrolling.
- **sortBy** `string` — Column name by which the table is currently sorted.
- **noRowMsg** `string` — Message displayed when no rows are found.
- **TableModel** `JSON object` — Structured representation of table rows, columns, and settings.

### Possible Response Codes

- **200** `HTTP code`

### Sample Response: HTTP 200

Custom report successfully executed

```json
{
  "headers": [
    {
      "sqlType": "CHAR",
      "savedWidth": -1,
      "displayName": "Computer Name",
      "colIndex": 0,
      "columnCss": "sortedColumn",
      "isSearchEnabled": false,
      "canAutoResize": true,
      "sqlTblColindex": 1,
      "disabled": false,
      "sortEnabled": true,
      "searchValue": "",
      "columnName": "Resource.NAME"
    }
  ],
  "rowSelection": "none",
  "data": [
    {
      "cells": [
        {
          "value": "AdamGallagher"
        }
      ],
      "rowIdx": 0
    }
  ],
  "isExportEnabled": true,
  "showHeader": true,
  "numFixedColumns": 0,
  "isAdvancedSearch": false,
  "showNavig": false,
  "navigation": {
    "startLinkIndex": 1,
    "showNextPage": false,
    "hasPaginationBottom": true,
    "range": [
      25,
      50
    ],
    "isNoCount": true,
    "type": "SELECT",
    "endLinkIndex": 1,
    "showFirstPage": false,
    "total": 6,
    "pages": 6,
    "hasPaginationTop": 6,
    "itemsPerPage": 6,
    "from": 1,
    "to": 6,
    "showLastPage": false,
    "currentPage": 1,
    "showPrevPage": false
  },
  "templateName": "tableTemplate",
  "colList": [
    {
      "isChoosable": true,
      "display": "Computer Name",
      "name": "Resource.NAME",
      "isSortable": true,
      "isVisible": true
    }
  ],
  "SQLTable": true,
  "isSearchPresent": false,
  "rowHover": true,
  "sortOrder": true,
  "name": "CRVIEW_1746711019739",
  "isScrollTable": false,
  "sortBy": "Resource.NAME",
  "noRowMsg": "Records not found",
  "TableModel": {
    "tableModelRows": [
      [
        "Machine-1"
      ]
    ],
    "viewColumns": [
      "Resource.NAME"
    ],
    "rowSelectionType": "NONE",
    "uniqueId": "CRVIEW_1746711019739"
  }
}
```

![](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.