# 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/cloud/report-create-custom-report.html) in the VIEWNAME field to retrieve the required report.

## Endpoints

`POST /{CRVIEW_VIEWNAME}.ec`

## Request URL

https://[*{serverurl}*](https://www.manageengine.com/products/desktop-central/help/api/cloud/oauth-authentication-endpoint-domain.html)/{CRVIEW_VIEWNAME}.ec

## Scope

`DesktopCentralCloud.CustomReport.READ`

### Header

`Authorization: Zoho-oauthtoken d92d4xxxxxxxxxxxxx15f52`

## Request Parameters

### Path Parameters

**CRVIEW_VIEWNAME** `string` **Mandatory**

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

### Query Parameters

**_FI** `string` Optional

First index - 1st record index (index starts from 1)[inclusive] ,Increment this param according to page limit to fetch next set/page of records

**_PL** `string` Optional

Page length - number of records fetched per page (defaulted to 25),Max limit - 500

## Sample Request

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

## Response Parameters

### 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.