GET api/Data/Valve

Returns Valve Table data

Request Information

URI Parameters

None.

Body Parameters

Name	Description	Type	Additional information
Columns	The desired Filters for the query	Collection of string	Required
Filters	The desired Filters for the query	Collection of Filters	Required
SortBy	The desired Sort for the query	Collection of SortBy	None.

Request Formats

application/json, text/json

Sample:

{
  "Columns": [
    "sample string 1",
    "sample string 2"
  ],
  "Filters": [
    {
      "Column": "sample string 1",
      "Operator": "sample string 2",
      "Threshold": "sample string 3",
      "From_Threshold": "sample string 4",
      "To_Threshold": "sample string 5"
    },
    {
      "Column": "sample string 1",
      "Operator": "sample string 2",
      "Threshold": "sample string 3",
      "From_Threshold": "sample string 4",
      "To_Threshold": "sample string 5"
    }
  ],
  "SortBy": [
    {
      "Column": "sample string 1",
      "Direction": "sample string 2"
    },
    {
      "Column": "sample string 1",
      "Direction": "sample string 2"
    }
  ]
}

application/xml, text/xml

Sample:

<TableParameters xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/EQR_API_MVC.Controllers">
  <Columns xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>sample string 1</d2p1:string>
    <d2p1:string>sample string 2</d2p1:string>
  </Columns>
  <Filters>
    <Filters>
      <Column>sample string 1</Column>
      <From_Threshold>sample string 4</From_Threshold>
      <Operator>sample string 2</Operator>
      <Threshold>sample string 3</Threshold>
      <To_Threshold>sample string 5</To_Threshold>
    </Filters>
    <Filters>
      <Column>sample string 1</Column>
      <From_Threshold>sample string 4</From_Threshold>
      <Operator>sample string 2</Operator>
      <Threshold>sample string 3</Threshold>
      <To_Threshold>sample string 5</To_Threshold>
    </Filters>
  </Filters>
  <SortBy>
    <SortBy>
      <Column>sample string 1</Column>
      <Direction>sample string 2</Direction>
    </SortBy>
    <SortBy>
      <Column>sample string 1</Column>
      <Direction>sample string 2</Direction>
    </SortBy>
  </SortBy>
</TableParameters>

application/x-www-form-urlencoded

Sample:

Sample not available.

Response Information

Resource Description

RequestValve

Name	Type	Additional information
Message	string	None.
Status	string	None.
NumberOfRecords	integer	None.
Data	Collection of Valve	None.

Response Formats

application/json, text/json

Sample:

{
  "Message": "sample string 1",
  "Status": "sample string 2",
  "NumberOfRecords": 3,
  "Data": [
    {
      "V_ID": 1,
      "V_Eq_ID": 1,
      "V_TagNumber": "sample string 1",
      "V_SAPNumber": "sample string 2",
      "V_Location": "sample string 3",
      "V_Contents": "sample string 4",
      "V_Type": "sample string 5",
      "V_Manufacturer": "sample string 6",
      "V_ModelNumber": "sample string 7",
      "V_SerialNumber": "sample string 8",
      "V_SetPressure": "sample string 9",
      "V_ReqCapacity": "sample string 10",
      "V_Capacity": "sample string 11",
      "V_Size": "sample string 12",
      "V_LastTestDate": "sample string 13",
      "V_NextTestDate": "sample string 14",
      "V_LastRepairDate": "sample string 15",
      "V_NextRepairDate": "sample string 16",
      "V_LastChangeOutDate": "sample string 17",
      "V_Notes": "sample string 18",
      "V_Import_EqName": "sample string 19",
      "V_Import_EqNumber": "sample string 20",
      "V_CompanyID": 1,
      "V_FacilityID": 1,
      "V_OwnerArea": 1,
      "V_TestFrequency": "sample string 21",
      "V_RepairFrequency": "sample string 22",
      "V_Delete_Flag": true,
      "V_Date_Created": "sample string 23",
      "V_Date_Modified": "sample string 24",
      "V_Created_By": "sample string 25",
      "V_Modified_By": "sample string 26"
    },
    {
      "V_ID": 1,
      "V_Eq_ID": 1,
      "V_TagNumber": "sample string 1",
      "V_SAPNumber": "sample string 2",
      "V_Location": "sample string 3",
      "V_Contents": "sample string 4",
      "V_Type": "sample string 5",
      "V_Manufacturer": "sample string 6",
      "V_ModelNumber": "sample string 7",
      "V_SerialNumber": "sample string 8",
      "V_SetPressure": "sample string 9",
      "V_ReqCapacity": "sample string 10",
      "V_Capacity": "sample string 11",
      "V_Size": "sample string 12",
      "V_LastTestDate": "sample string 13",
      "V_NextTestDate": "sample string 14",
      "V_LastRepairDate": "sample string 15",
      "V_NextRepairDate": "sample string 16",
      "V_LastChangeOutDate": "sample string 17",
      "V_Notes": "sample string 18",
      "V_Import_EqName": "sample string 19",
      "V_Import_EqNumber": "sample string 20",
      "V_CompanyID": 1,
      "V_FacilityID": 1,
      "V_OwnerArea": 1,
      "V_TestFrequency": "sample string 21",
      "V_RepairFrequency": "sample string 22",
      "V_Delete_Flag": true,
      "V_Date_Created": "sample string 23",
      "V_Date_Modified": "sample string 24",
      "V_Created_By": "sample string 25",
      "V_Modified_By": "sample string 26"
    }
  ]
}

application/xml, text/xml

Sample:

<ApiDataModels.Requests.RequestValve xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/EQR_API_MVC.Models">
  <Data>
    <ApiDataModels.Data.Valve>
      <V_Capacity>sample string 11</V_Capacity>
      <V_CompanyID>1</V_CompanyID>
      <V_Contents>sample string 4</V_Contents>
      <V_Created_By>sample string 25</V_Created_By>
      <V_Date_Created>sample string 23</V_Date_Created>
      <V_Date_Modified>sample string 24</V_Date_Modified>
      <V_Delete_Flag>true</V_Delete_Flag>
      <V_Eq_ID>1</V_Eq_ID>
      <V_FacilityID>1</V_FacilityID>
      <V_ID>1</V_ID>
      <V_Import_EqName>sample string 19</V_Import_EqName>
      <V_Import_EqNumber>sample string 20</V_Import_EqNumber>
      <V_LastChangeOutDate>sample string 17</V_LastChangeOutDate>
      <V_LastRepairDate>sample string 15</V_LastRepairDate>
      <V_LastTestDate>sample string 13</V_LastTestDate>
      <V_Location>sample string 3</V_Location>
      <V_Manufacturer>sample string 6</V_Manufacturer>
      <V_ModelNumber>sample string 7</V_ModelNumber>
      <V_Modified_By>sample string 26</V_Modified_By>
      <V_NextRepairDate>sample string 16</V_NextRepairDate>
      <V_NextTestDate>sample string 14</V_NextTestDate>
      <V_Notes>sample string 18</V_Notes>
      <V_OwnerArea>1</V_OwnerArea>
      <V_RepairFrequency>sample string 22</V_RepairFrequency>
      <V_ReqCapacity>sample string 10</V_ReqCapacity>
      <V_SAPNumber>sample string 2</V_SAPNumber>
      <V_SerialNumber>sample string 8</V_SerialNumber>
      <V_SetPressure>sample string 9</V_SetPressure>
      <V_Size>sample string 12</V_Size>
      <V_TagNumber>sample string 1</V_TagNumber>
      <V_TestFrequency>sample string 21</V_TestFrequency>
      <V_Type>sample string 5</V_Type>
    </ApiDataModels.Data.Valve>
    <ApiDataModels.Data.Valve>
      <V_Capacity>sample string 11</V_Capacity>
      <V_CompanyID>1</V_CompanyID>
      <V_Contents>sample string 4</V_Contents>
      <V_Created_By>sample string 25</V_Created_By>
      <V_Date_Created>sample string 23</V_Date_Created>
      <V_Date_Modified>sample string 24</V_Date_Modified>
      <V_Delete_Flag>true</V_Delete_Flag>
      <V_Eq_ID>1</V_Eq_ID>
      <V_FacilityID>1</V_FacilityID>
      <V_ID>1</V_ID>
      <V_Import_EqName>sample string 19</V_Import_EqName>
      <V_Import_EqNumber>sample string 20</V_Import_EqNumber>
      <V_LastChangeOutDate>sample string 17</V_LastChangeOutDate>
      <V_LastRepairDate>sample string 15</V_LastRepairDate>
      <V_LastTestDate>sample string 13</V_LastTestDate>
      <V_Location>sample string 3</V_Location>
      <V_Manufacturer>sample string 6</V_Manufacturer>
      <V_ModelNumber>sample string 7</V_ModelNumber>
      <V_Modified_By>sample string 26</V_Modified_By>
      <V_NextRepairDate>sample string 16</V_NextRepairDate>
      <V_NextTestDate>sample string 14</V_NextTestDate>
      <V_Notes>sample string 18</V_Notes>
      <V_OwnerArea>1</V_OwnerArea>
      <V_RepairFrequency>sample string 22</V_RepairFrequency>
      <V_ReqCapacity>sample string 10</V_ReqCapacity>
      <V_SAPNumber>sample string 2</V_SAPNumber>
      <V_SerialNumber>sample string 8</V_SerialNumber>
      <V_SetPressure>sample string 9</V_SetPressure>
      <V_Size>sample string 12</V_Size>
      <V_TagNumber>sample string 1</V_TagNumber>
      <V_TestFrequency>sample string 21</V_TestFrequency>
      <V_Type>sample string 5</V_Type>
    </ApiDataModels.Data.Valve>
  </Data>
  <Message>sample string 1</Message>
  <NumberOfRecords>3</NumberOfRecords>
  <Status>sample string 2</Status>
</ApiDataModels.Requests.RequestValve>