GET api/Data/ActionItems
Returns ActionItems Table data
Request Information
URI Parameters
None.
Body Parameters
TableParameters| 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
RequestActionItems| Name | Description | Type | Additional information |
|---|---|---|---|
| Message | string |
None. |
|
| Status | string |
None. |
|
| NumberOfRecords | integer |
None. |
|
| Data | Collection of ActionItems |
None. |
Response Formats
application/json, text/json
Sample:
{
"Message": "sample string 1",
"Status": "sample string 2",
"NumberOfRecords": 3,
"Data": [
{
"Act_ID": 1,
"Act_Ins_ID": 1,
"Act_Date_Due": "sample string 1",
"Act_Completed_Date": "sample string 2",
"Act_Estimated_Cost": "sample string 3",
"Act_Notes": "sample string 4",
"Act_Schedule_Note_Date": "sample string 5",
"Act_Completed": true,
"Act_Confirmed": true,
"Act_Short": "sample string 6",
"Act_Type": "sample string 7",
"Act_Scheduling": "sample string 8",
"Act_Category": "sample string 9",
"Act_Work_Order": "sample string 10",
"Act_Priority": "sample string 11",
"Act_PO_Number": "sample string 12",
"Eq_ID": 1,
"Act_Delete_Flag": true,
"Act_Date_Created": "sample string 13",
"Act_Date_Modified": "sample string 14",
"Act_Created_By": "sample string 15",
"Act_Modified_By": "sample string 16"
},
{
"Act_ID": 1,
"Act_Ins_ID": 1,
"Act_Date_Due": "sample string 1",
"Act_Completed_Date": "sample string 2",
"Act_Estimated_Cost": "sample string 3",
"Act_Notes": "sample string 4",
"Act_Schedule_Note_Date": "sample string 5",
"Act_Completed": true,
"Act_Confirmed": true,
"Act_Short": "sample string 6",
"Act_Type": "sample string 7",
"Act_Scheduling": "sample string 8",
"Act_Category": "sample string 9",
"Act_Work_Order": "sample string 10",
"Act_Priority": "sample string 11",
"Act_PO_Number": "sample string 12",
"Eq_ID": 1,
"Act_Delete_Flag": true,
"Act_Date_Created": "sample string 13",
"Act_Date_Modified": "sample string 14",
"Act_Created_By": "sample string 15",
"Act_Modified_By": "sample string 16"
}
]
}
application/xml, text/xml
Sample:
<ApiDataModels.Requests.RequestActionItems xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/EQR_API_MVC.Models">
<Data>
<ApiDataModels.Data.ActionItems>
<Act_Category>sample string 9</Act_Category>
<Act_Completed>true</Act_Completed>
<Act_Completed_Date>sample string 2</Act_Completed_Date>
<Act_Confirmed>true</Act_Confirmed>
<Act_Created_By>sample string 15</Act_Created_By>
<Act_Date_Created>sample string 13</Act_Date_Created>
<Act_Date_Due>sample string 1</Act_Date_Due>
<Act_Date_Modified>sample string 14</Act_Date_Modified>
<Act_Delete_Flag>true</Act_Delete_Flag>
<Act_Estimated_Cost>sample string 3</Act_Estimated_Cost>
<Act_ID>1</Act_ID>
<Act_Ins_ID>1</Act_Ins_ID>
<Act_Modified_By>sample string 16</Act_Modified_By>
<Act_Notes>sample string 4</Act_Notes>
<Act_PO_Number>sample string 12</Act_PO_Number>
<Act_Priority>sample string 11</Act_Priority>
<Act_Schedule_Note_Date>sample string 5</Act_Schedule_Note_Date>
<Act_Scheduling>sample string 8</Act_Scheduling>
<Act_Short>sample string 6</Act_Short>
<Act_Type>sample string 7</Act_Type>
<Act_Work_Order>sample string 10</Act_Work_Order>
<Eq_ID>1</Eq_ID>
</ApiDataModels.Data.ActionItems>
<ApiDataModels.Data.ActionItems>
<Act_Category>sample string 9</Act_Category>
<Act_Completed>true</Act_Completed>
<Act_Completed_Date>sample string 2</Act_Completed_Date>
<Act_Confirmed>true</Act_Confirmed>
<Act_Created_By>sample string 15</Act_Created_By>
<Act_Date_Created>sample string 13</Act_Date_Created>
<Act_Date_Due>sample string 1</Act_Date_Due>
<Act_Date_Modified>sample string 14</Act_Date_Modified>
<Act_Delete_Flag>true</Act_Delete_Flag>
<Act_Estimated_Cost>sample string 3</Act_Estimated_Cost>
<Act_ID>1</Act_ID>
<Act_Ins_ID>1</Act_Ins_ID>
<Act_Modified_By>sample string 16</Act_Modified_By>
<Act_Notes>sample string 4</Act_Notes>
<Act_PO_Number>sample string 12</Act_PO_Number>
<Act_Priority>sample string 11</Act_Priority>
<Act_Schedule_Note_Date>sample string 5</Act_Schedule_Note_Date>
<Act_Scheduling>sample string 8</Act_Scheduling>
<Act_Short>sample string 6</Act_Short>
<Act_Type>sample string 7</Act_Type>
<Act_Work_Order>sample string 10</Act_Work_Order>
<Eq_ID>1</Eq_ID>
</ApiDataModels.Data.ActionItems>
</Data>
<Message>sample string 1</Message>
<NumberOfRecords>3</NumberOfRecords>
<Status>sample string 2</Status>
</ApiDataModels.Requests.RequestActionItems>