GET api/Asset/GetSparePartsUsageReport?FacilityIDs={FacilityIDs}&SubFacilityIDs={SubFacilityIDs}&AssetGroupIDs={AssetGroupIDs}&DepartmentIDs={DepartmentIDs}&StartDate={StartDate}&EndDate={EndDate}&PageSize={PageSize}&PageNumber={PageNumber}

Request Information

URI Parameters

Name	Type	Additional information
FacilityIDs	string	None.
SubFacilityIDs	string	None.
AssetGroupIDs	string	None.
DepartmentIDs	string	None.
StartDate	date	None.
EndDate	date	None.
PageSize	integer	None.
PageNumber	integer	None.

Body Parameters

None.

Response Information

Resource Description

SparePartsUsageReportResult

Name	Type	Additional information
Summary	SparePartsUsageReportSummary	None.
Rows	Collection of SparePartsUsageReportRow	None.
Facilities	Collection of FilterOptionDataModel	None.
SubFacilities	Collection of FilterOptionDataModel	None.
AssetGroups	Collection of FilterOptionDataModel	None.
Departments	Collection of FilterOptionDataModel	None.
ReturnID	integer	Required
Message	string	Required
Successful	boolean	Required
Code	integer	None.
TotalRecord	integer	None.

Response Formats

application/json, text/json, text/plain, text/html

Sample:

{
  "summary": {
    "totalQtyUsed": 1.0,
    "totalValue": 2.0
  },
  "rows": [
    {
      "partsName": "sample string 1",
      "partsCode": "sample string 2",
      "facilityName": "sample string 3",
      "subFacilityName": "sample string 4",
      "assetGroupName": "sample string 5",
      "departmentName": "sample string 6",
      "dateUsed": "sample string 7",
      "workOrderCode": "sample string 8",
      "assetName": "sample string 9",
      "usedQty": 10.0,
      "unitPrice": 11.0,
      "netTotal": 12.0
    },
    {
      "partsName": "sample string 1",
      "partsCode": "sample string 2",
      "facilityName": "sample string 3",
      "subFacilityName": "sample string 4",
      "assetGroupName": "sample string 5",
      "departmentName": "sample string 6",
      "dateUsed": "sample string 7",
      "workOrderCode": "sample string 8",
      "assetName": "sample string 9",
      "usedQty": 10.0,
      "unitPrice": 11.0,
      "netTotal": 12.0
    }
  ],
  "facilities": [
    {
      "id": 1,
      "name": "sample string 2"
    },
    {
      "id": 1,
      "name": "sample string 2"
    }
  ],
  "subFacilities": [
    {
      "id": 1,
      "name": "sample string 2"
    },
    {
      "id": 1,
      "name": "sample string 2"
    }
  ],
  "assetGroups": [
    {
      "id": 1,
      "name": "sample string 2"
    },
    {
      "id": 1,
      "name": "sample string 2"
    }
  ],
  "departments": [
    {
      "id": 1,
      "name": "sample string 2"
    },
    {
      "id": 1,
      "name": "sample string 2"
    }
  ],
  "returnID": 1,
  "message": "sample string 2",
  "successful": true,
  "code": 4,
  "totalRecord": 5
}

application/xml, text/xml

Sample:

<SparePartsUsageReportResult xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/ArrowCMMS.Core.DataModel.Asset">
  <Code xmlns="http://schemas.datacontract.org/2004/07/Arrow.Core.DataModel">4</Code>
  <Message xmlns="http://schemas.datacontract.org/2004/07/Arrow.Core.DataModel">sample string 2</Message>
  <ReturnID xmlns="http://schemas.datacontract.org/2004/07/Arrow.Core.DataModel">1</ReturnID>
  <Successful xmlns="http://schemas.datacontract.org/2004/07/Arrow.Core.DataModel">true</Successful>
  <TotalRecord xmlns="http://schemas.datacontract.org/2004/07/Arrow.Core.DataModel">5</TotalRecord>
  <AssetGroups xmlns:d2p1="http://schemas.datacontract.org/2004/07/ArrowCMMS.Core.DataModel.Dashboard">
    <d2p1:FilterOptionDataModel>
      <d2p1:Id>1</d2p1:Id>
      <d2p1:Name>sample string 2</d2p1:Name>
    </d2p1:FilterOptionDataModel>
    <d2p1:FilterOptionDataModel>
      <d2p1:Id>1</d2p1:Id>
      <d2p1:Name>sample string 2</d2p1:Name>
    </d2p1:FilterOptionDataModel>
  </AssetGroups>
  <Departments xmlns:d2p1="http://schemas.datacontract.org/2004/07/ArrowCMMS.Core.DataModel.Dashboard">
    <d2p1:FilterOptionDataModel>
      <d2p1:Id>1</d2p1:Id>
      <d2p1:Name>sample string 2</d2p1:Name>
    </d2p1:FilterOptionDataModel>
    <d2p1:FilterOptionDataModel>
      <d2p1:Id>1</d2p1:Id>
      <d2p1:Name>sample string 2</d2p1:Name>
    </d2p1:FilterOptionDataModel>
  </Departments>
  <Facilities xmlns:d2p1="http://schemas.datacontract.org/2004/07/ArrowCMMS.Core.DataModel.Dashboard">
    <d2p1:FilterOptionDataModel>
      <d2p1:Id>1</d2p1:Id>
      <d2p1:Name>sample string 2</d2p1:Name>
    </d2p1:FilterOptionDataModel>
    <d2p1:FilterOptionDataModel>
      <d2p1:Id>1</d2p1:Id>
      <d2p1:Name>sample string 2</d2p1:Name>
    </d2p1:FilterOptionDataModel>
  </Facilities>
  <Rows>
    <SparePartsUsageReportRow>
      <AssetGroupName>sample string 5</AssetGroupName>
      <AssetName>sample string 9</AssetName>
      <DateUsed>sample string 7</DateUsed>
      <DepartmentName>sample string 6</DepartmentName>
      <FacilityName>sample string 3</FacilityName>
      <NetTotal>12</NetTotal>
      <PartsCode>sample string 2</PartsCode>
      <PartsName>sample string 1</PartsName>
      <SubFacilityName>sample string 4</SubFacilityName>
      <TotalRecord>13</TotalRecord>
      <UnitPrice>11</UnitPrice>
      <UsedQty>10</UsedQty>
      <WorkOrderCode>sample string 8</WorkOrderCode>
    </SparePartsUsageReportRow>
    <SparePartsUsageReportRow>
      <AssetGroupName>sample string 5</AssetGroupName>
      <AssetName>sample string 9</AssetName>
      <DateUsed>sample string 7</DateUsed>
      <DepartmentName>sample string 6</DepartmentName>
      <FacilityName>sample string 3</FacilityName>
      <NetTotal>12</NetTotal>
      <PartsCode>sample string 2</PartsCode>
      <PartsName>sample string 1</PartsName>
      <SubFacilityName>sample string 4</SubFacilityName>
      <TotalRecord>13</TotalRecord>
      <UnitPrice>11</UnitPrice>
      <UsedQty>10</UsedQty>
      <WorkOrderCode>sample string 8</WorkOrderCode>
    </SparePartsUsageReportRow>
  </Rows>
  <SubFacilities xmlns:d2p1="http://schemas.datacontract.org/2004/07/ArrowCMMS.Core.DataModel.Dashboard">
    <d2p1:FilterOptionDataModel>
      <d2p1:Id>1</d2p1:Id>
      <d2p1:Name>sample string 2</d2p1:Name>
    </d2p1:FilterOptionDataModel>
    <d2p1:FilterOptionDataModel>
      <d2p1:Id>1</d2p1:Id>
      <d2p1:Name>sample string 2</d2p1:Name>
    </d2p1:FilterOptionDataModel>
  </SubFacilities>
  <Summary>
    <TotalQtyUsed>1</TotalQtyUsed>
    <TotalValue>2</TotalValue>
  </Summary>
</SparePartsUsageReportResult>

multipart/form-data

Sample:

<SparePartsUsageReportResult xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/ArrowCMMS.Core.DataModel.Asset"><Code xmlns="http://schemas.datacontract.org/2004/07/Arrow.Core.DataModel">4</Code><Message xmlns="http://schemas.datacontract.org/2004/07/Arrow.Core.DataModel">sample string 2</Message><ReturnID xmlns="http://schemas.datacontract.org/2004/07/Arrow.Core.DataModel">1</ReturnID><Successful xmlns="http://schemas.datacontract.org/2004/07/Arrow.Core.DataModel">true</Successful><TotalRecord xmlns="http://schemas.datacontract.org/2004/07/Arrow.Core.DataModel">5</TotalRecord><AssetGroups xmlns:d2p1="http://schemas.datacontract.org/2004/07/ArrowCMMS.Core.DataModel.Dashboard"><d2p1:FilterOptionDataModel><d2p1:Id>1</d2p1:Id><d2p1:Name>sample string 2</d2p1:Name></d2p1:FilterOptionDataModel><d2p1:FilterOptionDataModel><d2p1:Id>1</d2p1:Id><d2p1:Name>sample string 2</d2p1:Name></d2p1:FilterOptionDataModel></AssetGroups><Departments xmlns:d2p1="http://schemas.datacontract.org/2004/07/ArrowCMMS.Core.DataModel.Dashboard"><d2p1:FilterOptionDataModel><d2p1:Id>1</d2p1:Id><d2p1:Name>sample string 2</d2p1:Name></d2p1:FilterOptionDataModel><d2p1:FilterOptionDataModel><d2p1:Id>1</d2p1:Id><d2p1:Name>sample string 2</d2p1:Name></d2p1:FilterOptionDataModel></Departments><Facilities xmlns:d2p1="http://schemas.datacontract.org/2004/07/ArrowCMMS.Core.DataModel.Dashboard"><d2p1:FilterOptionDataModel><d2p1:Id>1</d2p1:Id><d2p1:Name>sample string 2</d2p1:Name></d2p1:FilterOptionDataModel><d2p1:FilterOptionDataModel><d2p1:Id>1</d2p1:Id><d2p1:Name>sample string 2</d2p1:Name></d2p1:FilterOptionDataModel></Facilities><Rows><SparePartsUsageReportRow><AssetGroupName>sample string 5</AssetGroupName><AssetName>sample string 9</AssetName><DateUsed>sample string 7</DateUsed><DepartmentName>sample string 6</DepartmentName><FacilityName>sample string 3</FacilityName><NetTotal>12</NetTotal><PartsCode>sample string 2</PartsCode><PartsName>sample string 1</PartsName><SubFacilityName>sample string 4</SubFacilityName><TotalRecord>13</TotalRecord><UnitPrice>11</UnitPrice><UsedQty>10</UsedQty><WorkOrderCode>sample string 8</WorkOrderCode></SparePartsUsageReportRow><SparePartsUsageReportRow><AssetGroupName>sample string 5</AssetGroupName><AssetName>sample string 9</AssetName><DateUsed>sample string 7</DateUsed><DepartmentName>sample string 6</DepartmentName><FacilityName>sample string 3</FacilityName><NetTotal>12</NetTotal><PartsCode>sample string 2</PartsCode><PartsName>sample string 1</PartsName><SubFacilityName>sample string 4</SubFacilityName><TotalRecord>13</TotalRecord><UnitPrice>11</UnitPrice><UsedQty>10</UsedQty><WorkOrderCode>sample string 8</WorkOrderCode></SparePartsUsageReportRow></Rows><SubFacilities xmlns:d2p1="http://schemas.datacontract.org/2004/07/ArrowCMMS.Core.DataModel.Dashboard"><d2p1:FilterOptionDataModel><d2p1:Id>1</d2p1:Id><d2p1:Name>sample string 2</d2p1:Name></d2p1:FilterOptionDataModel><d2p1:FilterOptionDataModel><d2p1:Id>1</d2p1:Id><d2p1:Name>sample string 2</d2p1:Name></d2p1:FilterOptionDataModel></SubFacilities><Summary><TotalQtyUsed>1</TotalQtyUsed><TotalValue>2</TotalValue></Summary></SparePartsUsageReportResult>