POST api/Values/ProcessSqlQuery

Request Information

URI Parameters

None.

Body Parameters

Name	Description	Type	Additional information
SQLQuery		string	None.

Request Formats

application/json, text/json

Sample:

{
  "SQLQuery": "sample string 1"
}

text/html

Sample:

{"SQLQuery":"sample string 1"}

application/xml, text/xml

Sample:

<dbmlSqlQueryLog xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/TimkenOrderService.Models">
  <SQLQuery>sample string 1</SQLQuery>
</dbmlSqlQueryLog>

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

Response Information

Resource Description

ReturndbmlSqlQueryResult

Name	Description	Type	Additional information
objdbmlSQLQuery		dbmlSqlQueryLog	None.
objdbmlStatus		dbmlStatus	None.

Response Formats

application/json, text/json

Sample:

{
  "objdbmlStatus": {
    "StatusId": 1,
    "Status": "sample string 2",
    "PKId": 3,
    "Remark": "sample string 4"
  },
  "objdbmlSQLQuery": {
    "SQLQuery": "sample string 1"
  }
}

text/html

Sample:

{"objdbmlStatus":{"StatusId":1,"Status":"sample string 2","PKId":3,"Remark":"sample string 4"},"objdbmlSQLQuery":{"SQLQuery":"sample string 1"}}

application/xml, text/xml

Sample:

<ReturndbmlSqlQueryResult xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/TimkenOrderService.Models">
  <objdbmlSQLQuery>
    <SQLQuery>sample string 1</SQLQuery>
  </objdbmlSQLQuery>
  <objdbmlStatus xmlns:d2p1="http://schemas.datacontract.org/2004/07/TimkenOrderService.TimkenSchema">
    <d2p1:PKId>3</d2p1:PKId>
    <d2p1:Remark>sample string 4</d2p1:Remark>
    <d2p1:Status>sample string 2</d2p1:Status>
    <d2p1:StatusId>1</d2p1:StatusId>
  </objdbmlStatus>
</ReturndbmlSqlQueryResult>