POST api/v1/SQLExecItem/RunSQLExec/{id}

Request Information

URI Parameters

Name	Description	Type	Additional information
id		string	Required

Body Parameters

None.

Response Information

Resource Description

EzyResultObjectOfSQLExecItemRSData

Name	Type	Additional information
Data	SQLExecItemRSData	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": 1,
    "SQLExecItemId": 1,
    "RunAt": "2026-03-06T07:20:23.1542483+07:00",
    "RSData": "sample string 2",
    "IsDeleted": true,
    "Log_CreatedDate": "2026-03-06T07:20:23.1542483+07:00",
    "Log_CreatedBy": "sample string 4",
    "Log_UpdatedDate": "2026-03-06T07:20:23.1542483+07:00",
    "Log_UpdatedBy": "sample string 5",
    "IsDisable": true,
    "Note": "sample string 7",
    "Timestamp": "QEA=",
    "IsCompress": 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:

<EzyResultObjectOfSQLExecItemRSData5zEgb4bv 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.Core.Data.AppSystem">
    <d2p1:Id>1</d2p1:Id>
    <d2p1:IsCompress>true</d2p1:IsCompress>
    <d2p1:IsDeleted>true</d2p1:IsDeleted>
    <d2p1:IsDisable>true</d2p1:IsDisable>
    <d2p1:Log_CreatedBy>sample string 4</d2p1:Log_CreatedBy>
    <d2p1:Log_CreatedDate>2026-03-06T07:20:23.1542483+07:00</d2p1:Log_CreatedDate>
    <d2p1:Log_UpdatedBy>sample string 5</d2p1:Log_UpdatedBy>
    <d2p1:Log_UpdatedDate>2026-03-06T07:20:23.1542483+07:00</d2p1:Log_UpdatedDate>
    <d2p1:Note>sample string 7</d2p1:Note>
    <d2p1:RSData>sample string 2</d2p1:RSData>
    <d2p1:RunAt>2026-03-06T07:20:23.1542483+07:00</d2p1:RunAt>
    <d2p1:SQLExecItemId>1</d2p1:SQLExecItemId>
    <d2p1:Timestamp>QEA=</d2p1:Timestamp>
  </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>
</EzyResultObjectOfSQLExecItemRSData5zEgb4bv>