POST api/Data/linkBIExecSqlTrans

Request Information

URI Parameters

None.

Body Parameters

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

Request Formats

application/json, text/json

Sample:

{
  "loginID": "sample string 1",
  "par": {
    "connStr": "sample string 1",
    "sqlCmd": [
      "sample string 1",
      "sample string 2"
    ]
  }
}

application/xml, text/xml

Sample:

<plkExecSqlTrans xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/MultiSoft">
  <loginID>sample string 1</loginID>
  <par>
    <connStr>sample string 1</connStr>
    <sqlCmd xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
      <d3p1:string>sample string 1</d3p1:string>
      <d3p1:string>sample string 2</d3p1:string>
    </sqlCmd>
  </par>
</plkExecSqlTrans>

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 'plkExecSqlTrans'.

Response Information

Resource Description

linkResult

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

Response Formats

application/json, text/json

Sample:

{
  "isSuccess": "sample string 1",
  "dataType": "sample string 2",
  "data": {},
  "message": "sample string 4",
  "action": "sample string 5"
}

application/xml, text/xml

Sample:

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