POST api/v1/SQLExecItem/Update

Request Information

URI Parameters

None.

Body Parameters

Name	Type	Additional information
Id	string	None.
Name	string	None.
SQLCommand	string	None.
btn_RunSQLExec	string	None.
SaveHistoryLog	boolean	None.
IsCompress	boolean	None.
Note	string	None.
UI_DefaultShowExpand	boolean	None.

Request Formats

application/json, text/json

Sample:

{
  "Id": "sample string 1",
  "Name": "sample string 2",
  "SQLCommand": "sample string 3",
  "btn_RunSQLExec": "sample string 4",
  "SaveHistoryLog": true,
  "IsCompress": true,
  "Note": "sample string 7",
  "UI_DefaultShowExpand": true
}

application/xml, text/xml

Sample:

<SQLExecItemModel xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/AllianceSolidAPI.Shared.Models">
  <Id>sample string 1</Id>
  <IsCompress>true</IsCompress>
  <Name>sample string 2</Name>
  <Note>sample string 7</Note>
  <SQLCommand>sample string 3</SQLCommand>
  <SaveHistoryLog>true</SaveHistoryLog>
  <UI_DefaultShowExpand>true</UI_DefaultShowExpand>
  <btn_RunSQLExec>sample string 4</btn_RunSQLExec>
</SQLExecItemModel>

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

Response Information

Resource Description

EzyResultObjectOfSQLExecItemModel

Name	Type	Additional information
Data	SQLExecItemModel	None.
ExtraData	Dictionary of string [key] and Object [value]	None.
StartTime	decimal number	None.
EndTime	decimal number	None.
TotalMili	decimal number	None.
StatusCode	integer	None.
Msg	string	None.
MsgShowInUI	string	None.

Response Formats

application/json, text/json

Sample:

{
  "Data": {
    "Id": "sample string 1",
    "Name": "sample string 2",
    "SQLCommand": "sample string 3",
    "btn_RunSQLExec": "sample string 4",
    "SaveHistoryLog": true,
    "IsCompress": true,
    "Note": "sample string 7",
    "UI_DefaultShowExpand": true
  },
  "ExtraData": null,
  "StartTime": 1.1,
  "EndTime": 2.1,
  "TotalMili": 3.1,
  "StatusCode": 4,
  "Msg": "sample string 5",
  "MsgShowInUI": "sample string 6"
}

application/xml, text/xml

Sample:

<EzyResultObjectOfSQLExecItemModel3BwjWE5f xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Ezy.Module.Library.Message">
  <Msg>sample string 5</Msg>
  <MsgShowInUI>sample string 6</MsgShowInUI>
  <StatusCode>4</StatusCode>
  <Data xmlns:d2p1="http://schemas.datacontract.org/2004/07/AllianceSolidAPI.Shared.Models">
    <d2p1:Id>sample string 1</d2p1:Id>
    <d2p1:IsCompress>true</d2p1:IsCompress>
    <d2p1:Name>sample string 2</d2p1:Name>
    <d2p1:Note>sample string 7</d2p1:Note>
    <d2p1:SQLCommand>sample string 3</d2p1:SQLCommand>
    <d2p1:SaveHistoryLog>true</d2p1:SaveHistoryLog>
    <d2p1:UI_DefaultShowExpand>true</d2p1:UI_DefaultShowExpand>
    <d2p1:btn_RunSQLExec>sample string 4</d2p1:btn_RunSQLExec>
  </Data>
  <EndTime>2.1</EndTime>
  <ExtraData xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" i:nil="true" />
  <StartTime>1.1</StartTime>
  <TotalMili>3.1</TotalMili>
</EzyResultObjectOfSQLExecItemModel3BwjWE5f>