POST api/Common/GetData

Request Information

URI Parameters

None.

Body Parameters

SQLRequestData
NameDescriptionTypeAdditional 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
NameDescriptionTypeAdditional 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>