POST api/Common/GetData
Request Information
URI Parameters
None.
Body Parameters
SQLRequestData| Name | Description | Type | Additional information |
|---|---|---|---|
| SPName | string |
None. |
|
| SQLParameter | Collection of SQLPrameter |
None. |
Request Formats
application/json, text/json
Sample:
{
"SPName": "sample string 1",
"SQLParameter": [
{
"ParameterName": "sample string 1",
"ParameterValue": {},
"ParameterType": 0,
"ParameterDirection": 0
},
{
"ParameterName": "sample string 1",
"ParameterValue": {},
"ParameterType": 0,
"ParameterDirection": 0
}
]
}
application/xml, text/xml
Sample:
<SQLRequestData xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/WVAnalytics.Models">
<SPName>sample string 1</SPName>
<SQLParameter>
<SQLPrameter>
<ParameterDirection>AnsiString</ParameterDirection>
<ParameterName>sample string 1</ParameterName>
<ParameterType>AnsiString</ParameterType>
<ParameterValue />
</SQLPrameter>
<SQLPrameter>
<ParameterDirection>AnsiString</ParameterDirection>
<ParameterName>sample string 1</ParameterName>
<ParameterType>AnsiString</ParameterType>
<ParameterValue />
</SQLPrameter>
</SQLParameter>
</SQLRequestData>
application/x-www-form-urlencoded
Sample:
Sample not available.
Response Information
Resource Description
ResponseModelOfDataTable| Name | Description | Type | Additional information |
|---|---|---|---|
| IsSuccess | boolean |
None. |
|
| IsError | boolean |
None. |
|
| ErrorMessage | string |
None. |
|
| Message | string |
None. |
|
| ResponseItem | DataTable |
None. |
Response Formats
application/json, text/json
Sample:
{
"IsSuccess": true,
"IsError": true,
"ErrorMessage": "sample string 3",
"Message": "sample string 4",
"ResponseItem": null
}
application/xml, text/xml
Sample:
<ResponseModelOfDataTableymujubN2 xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/WVAnalytics.Models"> <ErrorMessage>sample string 3</ErrorMessage> <IsError>true</IsError> <IsSuccess>true</IsSuccess> <Message>sample string 4</Message> <ResponseItem i:nil="true" /> </ResponseModelOfDataTableymujubN2>