POST api/sendsql

Request Information

URI Parameters

None.

Body Parameters

Name	Type	Additional information
table	string	None.
type	integer	None.
id	integer	None.
sql_statement	string	None.

Request Formats

application/json, text/json

Sample:

{
  "table": "sample string 1",
  "type": 2,
  "id": 3,
  "sql_statement": "sample string 4"
}

text/xml

Sample:

<sql_data xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Cards_api">
  <id>3</id>
  <sql_statement>sample string 4</sql_statement>
  <table>sample string 1</table>
  <type>2</type>
</sql_data>

application/x-www-form-urlencoded

Sample:

Sample not available.

Response Information

Resource Description

outdata

Name	Description	Type	Additional information
data		DataTable	None.
rowcount	if get data then return count row else return the id row affected	integer	None.
status		boolean	None.
msg_error		string	None.

Response Formats

application/json, text/json

Sample:

{
  "data": null,
  "rowcount": 1,
  "status": true,
  "msg_error": "sample string 3"
}

text/xml

Sample:

<outdata xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Cards_api">
  <data i:nil="true" />
  <msg_error>sample string 3</msg_error>
  <rowcount>1</rowcount>
  <status>true</status>
</outdata>