POST api/Data/linkBIExecSQL

Request Information

URI Parameters

None.

Body Parameters

Name	Description	Type	Additional information
loginID		string	None.
par		parExecSql	None.

Request Formats

application/json, text/json

Sample:

{
  "loginID": "sample string 1",
  "par": {
    "connStr": "sample string 1",
    "cmdType": 1,
    "cmdText": "sample string 2"
  }
}

text/html

Sample:

{"loginID":"sample string 1","par":{"connStr":"sample string 1","cmdType":1,"cmdText":"sample string 2"}}

application/xml, text/xml

Sample:

<plkExecSql xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/MultiSoft">
  <loginID>sample string 1</loginID>
  <par>
    <cmdText>sample string 2</cmdText>
    <cmdType>Text</cmdType>
    <connStr>sample string 1</connStr>
  </par>
</plkExecSql>

application/x-www-form-urlencoded

Sample:

Failed to generate the sample for media type 'application/x-www-form-urlencoded'. Cannot use formatter 'JQueryMvcFormUrlEncodedFormatter' to write type 'plkExecSql'.

Response Information

Resource Description

linkResult

Name	Type	Additional information
isSuccess	string	None.
message	string	None.
dataType	string	None.
data	Object	None.

Response Formats

application/json, text/json

Sample:

{
  "isSuccess": "sample string 1",
  "message": "sample string 2",
  "dataType": "sample string 3",
  "data": {}
}

text/html

Sample:

{"isSuccess":"sample string 1","message":"sample string 2","dataType":"sample string 3","data":{}}

application/xml, text/xml

Sample:

<linkResult xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/MultiSoft">
  <data />
  <dataType>sample string 3</dataType>
  <isSuccess>sample string 1</isSuccess>
  <message>sample string 2</message>
</linkResult>