POST api/select
Request Information
URI Parameters
None.
Body Parameters
Parameter1| Name | Description | Type | Additional information |
|---|---|---|---|
| connection | Connection |
None. |
|
| queryMeta | QueryMeta |
None. |
Request Formats
application/json, text/json
Sample:
{
"connection": {
"DataSource": "sample string 1",
"InitialCatalog": "sample string 2",
"UserID": "sample string 3",
"Password": "sample string 4"
},
"queryMeta": {
"ProcedureType": 1,
"TableName": "sample string 2",
"FieldList": "sample string 3",
"Where": "sample string 4"
}
}
application/xml, text/xml
Sample:
<Parameter1 xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/WS_ORKESTER">
<connection>
<DataSource>sample string 1</DataSource>
<InitialCatalog>sample string 2</InitialCatalog>
<Password>sample string 4</Password>
<UserID>sample string 3</UserID>
</connection>
<queryMeta>
<FieldList>sample string 3</FieldList>
<ProcedureType>1</ProcedureType>
<TableName>sample string 2</TableName>
<Where>sample string 4</Where>
</queryMeta>
</Parameter1>
application/x-www-form-urlencoded
Sample:
Sample not available.
Response Information
Resource Description
DataTable| Name | Description | Type | Additional information |
|---|---|---|---|
| CaseSensitive | boolean |
None. |
|
| IsInitialized | boolean |
None. |
|
| RemotingFormat | SerializationFormat |
None. |
|
| ChildRelations | Collection of Object |
None. |
|
| Columns | Collection of Object |
None. |
|
| Constraints | Collection of Object |
None. |
|
| DataSet | DataSet |
None. |
|
| DefaultView | Collection of Object |
None. |
|
| DisplayExpression | string |
None. |
|
| ExtendedProperties | Dictionary of Object [key] and Object [value] |
None. |
|
| HasErrors | boolean |
None. |
|
| Locale | CultureInfo |
None. |
|
| MinimumCapacity | integer |
None. |
|
| ParentRelations | Collection of Object |
None. |
|
| PrimaryKey | Collection of DataColumn |
None. |
|
| Rows | Collection of Object |
None. |
|
| TableName | string |
None. |
|
| Namespace | string |
None. |
|
| Prefix | string |
None. |
|
| Site | ISite |
None. |
|
| Container | IContainer |
None. |
|
| DesignMode | boolean |
None. |
Response Formats
application/json, text/json, application/xml, text/xml
Sample:
Sample not available.