POST v2/summaryGrid/excel/export/{gridID}

Request Information

URI Parameters

Name	Description	Type	Additional information
gridID		integer	Required

Body Parameters

SummaryGridExportRequestModel

Name	Description	Type	Additional information
Search	Report Center Filter	string	None.
Date	Report Center Filter	string	None.
FromDate	Report Center Filter	string	None.
ToDate	Report Center Filter	string	None.
LocationID	Report Center Filter	integer	None.
LocationIDs	Report Center Filter	string	None.
SKUID	Report Center Filter	integer	None.
SKUIDs	Report Center Filter	string	None.
LocationZoneIDs		string	None.
FilterID		integer	None.
SubFilterID		integer	None.
OperationID		integer	None.
CompanyID		integer	None.
ShipmentID		integer	None.
SKUCategoryID		integer	None.
FlagTypeID		integer	None.
SortCriteria		Collection of GridSortModel	None.
Filters		Collection of GridFilterModel	None.
GridName		string	None.
FileName		string	None.
ColumnSettings		Collection of ExcelColumnModel	None.
IsExcelExport		boolean	None.
RecordCount		integer	None.

Request Formats

application/json, text/json

Sample:

{
  "search": "sample string 1",
  "date": "sample string 2",
  "fromDate": "sample string 3",
  "toDate": "sample string 4",
  "locationID": 5,
  "locationIDs": "sample string 6",
  "skuid": 7,
  "skuiDs": "sample string 8",
  "locationZoneIDs": "sample string 9",
  "filterID": 10,
  "subFilterID": 11,
  "operationID": 12,
  "companyID": 13,
  "shipmentID": 14,
  "skuCategoryID": 15,
  "flagTypeID": 16,
  "sortCriteria": [
    {
      "columnName": "sample string 1",
      "sortDirection": "sample string 2"
    },
    {
      "columnName": "sample string 1",
      "sortDirection": "sample string 2"
    }
  ],
  "filters": [
    {
      "columnName": "sample string 1",
      "operator": "sample string 2",
      "searchValue": "sample string 3",
      "combinationLogic": "sample string 4"
    },
    {
      "columnName": "sample string 1",
      "operator": "sample string 2",
      "searchValue": "sample string 3",
      "combinationLogic": "sample string 4"
    }
  ],
  "gridName": "sample string 17",
  "fileName": "sample string 18",
  "columnSettings": [
    {
      "columnOrder": 1,
      "columnHeader": "sample string 2",
      "fieldName": "sample string 3",
      "dataType": "sample string 4",
      "isHidden": true,
      "cellValueDataType": 0,
      "cellInstance": null,
      "maxString": "sample string 6"
    },
    {
      "columnOrder": 1,
      "columnHeader": "sample string 2",
      "fieldName": "sample string 3",
      "dataType": "sample string 4",
      "isHidden": true,
      "cellValueDataType": 0,
      "cellInstance": null,
      "maxString": "sample string 6"
    }
  ],
  "isExcelExport": true,
  "recordCount": 20
}

Response Information

Resource Description

IHttpActionResult

None.

Response Formats

application/json, text/json

Sample:

Sample not available.