POST api/JoinFilter/Getjoin_filters
Request Information
URI Parameters
None.
Body Parameters
JoinFilterParamsFilters| Name | Description | Type | Additional information |
|---|---|---|---|
| displaystart | string |
None. |
|
| displayend | string |
None. |
|
| sortcol | string |
None. |
|
| sortdir | string |
None. |
|
| SOR | string |
None. |
|
| Target_database | string |
None. |
|
| Source_database | string |
None. |
|
| Logic_code | string |
None. |
|
| Status | string |
None. |
|
| Target_table | string |
None. |
|
| Source_read_orders | string |
None. |
|
| Logic_title | string |
None. |
|
| Source_table | string |
None. |
|
| Join_condition | string |
None. |
|
| Filter_condition | string |
None. |
|
| Comments | string |
None. |
|
| Created_by | string |
None. |
|
| Last_modified_by | string |
None. |
Request Formats
application/json, text/json
Sample:
{
"displaystart": "sample string 1",
"displayend": "sample string 2",
"sortcol": "sample string 3",
"sortdir": "sample string 4",
"SOR": "sample string 5",
"Target_database": "sample string 6",
"Source_database": "sample string 7",
"Logic_code": "sample string 8",
"Status": "sample string 9",
"Target_table": "sample string 10",
"Source_read_orders": "sample string 11",
"Logic_title": "sample string 12",
"Source_table": "sample string 13",
"Join_condition": "sample string 14",
"Filter_condition": "sample string 15",
"Comments": "sample string 16",
"Created_by": "sample string 17",
"Last_modified_by": "sample string 18"
}
application/xml, text/xml
Sample:
<JoinFilterParamsFilters xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/OauthApi.Controllers"> <Comments>sample string 16</Comments> <Created_by>sample string 17</Created_by> <Filter_condition>sample string 15</Filter_condition> <Join_condition>sample string 14</Join_condition> <Last_modified_by>sample string 18</Last_modified_by> <Logic_code>sample string 8</Logic_code> <Logic_title>sample string 12</Logic_title> <SOR>sample string 5</SOR> <Source_database>sample string 7</Source_database> <Source_read_orders>sample string 11</Source_read_orders> <Source_table>sample string 13</Source_table> <Status>sample string 9</Status> <Target_database>sample string 6</Target_database> <Target_table>sample string 10</Target_table> <displayend>sample string 2</displayend> <displaystart>sample string 1</displaystart> <sortcol>sample string 3</sortcol> <sortdir>sample string 4</sortdir> </JoinFilterParamsFilters>
application/x-www-form-urlencoded
Sample:
Sample not available.
Response Information
Resource Description
DataTableResponse| Name | Description | Type | Additional information |
|---|---|---|---|
| draw | integer |
None. |
|
| recordsTotal | integer |
None. |
|
| recordsFiltered | integer |
None. |
|
| data | Collection of Object |
None. |
|
| error | string |
None. |
Response Formats
application/json, text/json
Sample:
{
"draw": 1,
"recordsTotal": 2,
"recordsFiltered": 3,
"data": [
{},
{}
],
"error": "sample string 4"
}
application/xml, text/xml
Sample:
<DataTableResponse xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/OauthApi.Controllers">
<data xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
<d2p1:anyType />
<d2p1:anyType />
</data>
<draw>1</draw>
<error>sample string 4</error>
<recordsFiltered>3</recordsFiltered>
<recordsTotal>2</recordsTotal>
</DataTableResponse>