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