POST api/v1/ConfigSQLScriptRelease/List

Request Information

URI Parameters

None.

Body Parameters

Name	Type	Additional information
Id	string	None.
DateFrom	decimal number	None.
DateTo	decimal number	None.
DateFrom_Created	decimal number	None.
DateTo_Created	decimal number	None.
IsRunSuccess	boolean	None.
DBTargetType	string	None.
IsBackupStore	boolean	None.
IsIgnore	boolean	None.
FilterQuery	Dictionary of string [key] and Object [value]	None.
ScreenGUID	string	None.
DocumentWidth	integer	None.
Url	string	None.
OptionConfigsMore	Dictionary of string [key] and Object [value]	None.
QuerySearch	Dictionary of string [key] and Object [value]	None.
IsTestCase	boolean	None.

Request Formats

application/json, text/json

Sample:

{
  "Id": "sample string 1",
  "DateFrom": 1.1,
  "DateTo": 1.1,
  "DateFrom_Created": 1.1,
  "DateTo_Created": 1.1,
  "IsRunSuccess": true,
  "DBTargetType": "sample string 2",
  "IsBackupStore": true,
  "IsIgnore": true,
  "FilterQuery": null,
  "ScreenGUID": "sample string 3",
  "DocumentWidth": 4,
  "Url": "sample string 5",
  "OptionConfigsMore": null,
  "QuerySearch": null,
  "IsTestCase": true
}

application/xml, text/xml

Sample:

<ConfigSQLScriptReleaseParamModel xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Ezy.ApiService.ReleaseService.Models">
  <DocumentWidth xmlns="http://schemas.datacontract.org/2004/07/Ezy.Module.BaseData.Models">4</DocumentWidth>
  <FilterQuery xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" i:nil="true" xmlns="http://schemas.datacontract.org/2004/07/Ezy.Module.BaseData.Models" />
  <IsTestCase xmlns="http://schemas.datacontract.org/2004/07/Ezy.Module.BaseData.Models">true</IsTestCase>
  <OptionConfigsMore xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" i:nil="true" xmlns="http://schemas.datacontract.org/2004/07/Ezy.Module.BaseData.Models" />
  <QuerySearch xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" i:nil="true" xmlns="http://schemas.datacontract.org/2004/07/Ezy.Module.BaseData.Models" />
  <ScreenGUID xmlns="http://schemas.datacontract.org/2004/07/Ezy.Module.BaseData.Models">sample string 3</ScreenGUID>
  <Url xmlns="http://schemas.datacontract.org/2004/07/Ezy.Module.BaseData.Models">sample string 5</Url>
  <DBTargetType>sample string 2</DBTargetType>
  <DateFrom>1.1</DateFrom>
  <DateFrom_Created>1.1</DateFrom_Created>
  <DateTo>1.1</DateTo>
  <DateTo_Created>1.1</DateTo_Created>
  <Id>sample string 1</Id>
  <IsBackupStore>true</IsBackupStore>
  <IsIgnore>true</IsIgnore>
  <IsRunSuccess>true</IsRunSuccess>
</ConfigSQLScriptReleaseParamModel>

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

Response Information

Resource Description

EzyResultObjectOfEzyDataSourceResultOfConfigSQLScriptReleaseModel

Name	Type	Additional information
Data	EzyDataSourceResultOfConfigSQLScriptReleaseModel	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": {
    "Data": [
      {
        "Id": "sample string 1",
        "DBTargetType": "sample string 2",
        "ScriptName": "sample string 3",
        "ScriptContent": "sample string 4",
        "RunAt": 1.1,
        "RunBy": "sample string 5",
        "RunResult": "sample string 6",
        "Note": "sample string 7",
        "btn_RunScript": "sample string 8",
        "ColorStatus": "sample string 9",
        "IsBackUpStore": true,
        "ObjectName": "sample string 11",
        "IsRunSuccess": true,
        "IsIgnore": true,
        "Log_CreatedDate": 1.1,
        "Log_CreatedBy": "sample string 14",
        "ScriptFormated": "sample string 15",
        "IsLocked": true,
        "btn_ForceSuccess": "sample string 17"
      },
      {
        "Id": "sample string 1",
        "DBTargetType": "sample string 2",
        "ScriptName": "sample string 3",
        "ScriptContent": "sample string 4",
        "RunAt": 1.1,
        "RunBy": "sample string 5",
        "RunResult": "sample string 6",
        "Note": "sample string 7",
        "btn_RunScript": "sample string 8",
        "ColorStatus": "sample string 9",
        "IsBackUpStore": true,
        "ObjectName": "sample string 11",
        "IsRunSuccess": true,
        "IsIgnore": true,
        "Log_CreatedDate": 1.1,
        "Log_CreatedBy": "sample string 14",
        "ScriptFormated": "sample string 15",
        "IsLocked": true,
        "btn_ForceSuccess": "sample string 17"
      }
    ],
    "DataTotal": [
      {
        "Id": "sample string 1",
        "DBTargetType": "sample string 2",
        "ScriptName": "sample string 3",
        "ScriptContent": "sample string 4",
        "RunAt": 1.1,
        "RunBy": "sample string 5",
        "RunResult": "sample string 6",
        "Note": "sample string 7",
        "btn_RunScript": "sample string 8",
        "ColorStatus": "sample string 9",
        "IsBackUpStore": true,
        "ObjectName": "sample string 11",
        "IsRunSuccess": true,
        "IsIgnore": true,
        "Log_CreatedDate": 1.1,
        "Log_CreatedBy": "sample string 14",
        "ScriptFormated": "sample string 15",
        "IsLocked": true,
        "btn_ForceSuccess": "sample string 17"
      },
      {
        "Id": "sample string 1",
        "DBTargetType": "sample string 2",
        "ScriptName": "sample string 3",
        "ScriptContent": "sample string 4",
        "RunAt": 1.1,
        "RunBy": "sample string 5",
        "RunResult": "sample string 6",
        "Note": "sample string 7",
        "btn_RunScript": "sample string 8",
        "ColorStatus": "sample string 9",
        "IsBackUpStore": true,
        "ObjectName": "sample string 11",
        "IsRunSuccess": true,
        "IsIgnore": true,
        "Log_CreatedDate": 1.1,
        "Log_CreatedBy": "sample string 14",
        "ScriptFormated": "sample string 15",
        "IsLocked": true,
        "btn_ForceSuccess": "sample string 17"
      }
    ],
    "ExtraData": {},
    "Errors": {},
    "Total": 2
  },
  "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:

<EzyResultObjectOfEzyDataSourceResultOfConfigSQLScriptReleaseModelny0pkP0fUXXDg0Sb 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/Ezy.Module.Library.UI">
    <d2p1:Errors />
    <d2p1:ExtraData xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" />
    <d2p1:Total>2</d2p1:Total>
    <d2p1:Data xmlns:d3p1="http://schemas.datacontract.org/2004/07/Ezy.ApiService.ReleaseService.Models">
      <d3p1:ConfigSQLScriptReleaseModel>
        <d3p1:ColorStatus>sample string 9</d3p1:ColorStatus>
        <d3p1:DBTargetType>sample string 2</d3p1:DBTargetType>
        <d3p1:Id>sample string 1</d3p1:Id>
        <d3p1:IsBackUpStore>true</d3p1:IsBackUpStore>
        <d3p1:IsIgnore>true</d3p1:IsIgnore>
        <d3p1:IsLocked>true</d3p1:IsLocked>
        <d3p1:IsRunSuccess>true</d3p1:IsRunSuccess>
        <d3p1:Log_CreatedBy>sample string 14</d3p1:Log_CreatedBy>
        <d3p1:Log_CreatedDate>1.1</d3p1:Log_CreatedDate>
        <d3p1:Note>sample string 7</d3p1:Note>
        <d3p1:ObjectName>sample string 11</d3p1:ObjectName>
        <d3p1:RunAt>1.1</d3p1:RunAt>
        <d3p1:RunBy>sample string 5</d3p1:RunBy>
        <d3p1:RunResult>sample string 6</d3p1:RunResult>
        <d3p1:ScriptContent>sample string 4</d3p1:ScriptContent>
        <d3p1:ScriptFormated>sample string 15</d3p1:ScriptFormated>
        <d3p1:ScriptName>sample string 3</d3p1:ScriptName>
        <d3p1:btn_ForceSuccess>sample string 17</d3p1:btn_ForceSuccess>
        <d3p1:btn_RunScript>sample string 8</d3p1:btn_RunScript>
      </d3p1:ConfigSQLScriptReleaseModel>
      <d3p1:ConfigSQLScriptReleaseModel>
        <d3p1:ColorStatus>sample string 9</d3p1:ColorStatus>
        <d3p1:DBTargetType>sample string 2</d3p1:DBTargetType>
        <d3p1:Id>sample string 1</d3p1:Id>
        <d3p1:IsBackUpStore>true</d3p1:IsBackUpStore>
        <d3p1:IsIgnore>true</d3p1:IsIgnore>
        <d3p1:IsLocked>true</d3p1:IsLocked>
        <d3p1:IsRunSuccess>true</d3p1:IsRunSuccess>
        <d3p1:Log_CreatedBy>sample string 14</d3p1:Log_CreatedBy>
        <d3p1:Log_CreatedDate>1.1</d3p1:Log_CreatedDate>
        <d3p1:Note>sample string 7</d3p1:Note>
        <d3p1:ObjectName>sample string 11</d3p1:ObjectName>
        <d3p1:RunAt>1.1</d3p1:RunAt>
        <d3p1:RunBy>sample string 5</d3p1:RunBy>
        <d3p1:RunResult>sample string 6</d3p1:RunResult>
        <d3p1:ScriptContent>sample string 4</d3p1:ScriptContent>
        <d3p1:ScriptFormated>sample string 15</d3p1:ScriptFormated>
        <d3p1:ScriptName>sample string 3</d3p1:ScriptName>
        <d3p1:btn_ForceSuccess>sample string 17</d3p1:btn_ForceSuccess>
        <d3p1:btn_RunScript>sample string 8</d3p1:btn_RunScript>
      </d3p1:ConfigSQLScriptReleaseModel>
    </d2p1:Data>
    <d2p1:DataTotal xmlns:d3p1="http://schemas.datacontract.org/2004/07/Ezy.ApiService.ReleaseService.Models">
      <d3p1:ConfigSQLScriptReleaseModel>
        <d3p1:ColorStatus>sample string 9</d3p1:ColorStatus>
        <d3p1:DBTargetType>sample string 2</d3p1:DBTargetType>
        <d3p1:Id>sample string 1</d3p1:Id>
        <d3p1:IsBackUpStore>true</d3p1:IsBackUpStore>
        <d3p1:IsIgnore>true</d3p1:IsIgnore>
        <d3p1:IsLocked>true</d3p1:IsLocked>
        <d3p1:IsRunSuccess>true</d3p1:IsRunSuccess>
        <d3p1:Log_CreatedBy>sample string 14</d3p1:Log_CreatedBy>
        <d3p1:Log_CreatedDate>1.1</d3p1:Log_CreatedDate>
        <d3p1:Note>sample string 7</d3p1:Note>
        <d3p1:ObjectName>sample string 11</d3p1:ObjectName>
        <d3p1:RunAt>1.1</d3p1:RunAt>
        <d3p1:RunBy>sample string 5</d3p1:RunBy>
        <d3p1:RunResult>sample string 6</d3p1:RunResult>
        <d3p1:ScriptContent>sample string 4</d3p1:ScriptContent>
        <d3p1:ScriptFormated>sample string 15</d3p1:ScriptFormated>
        <d3p1:ScriptName>sample string 3</d3p1:ScriptName>
        <d3p1:btn_ForceSuccess>sample string 17</d3p1:btn_ForceSuccess>
        <d3p1:btn_RunScript>sample string 8</d3p1:btn_RunScript>
      </d3p1:ConfigSQLScriptReleaseModel>
      <d3p1:ConfigSQLScriptReleaseModel>
        <d3p1:ColorStatus>sample string 9</d3p1:ColorStatus>
        <d3p1:DBTargetType>sample string 2</d3p1:DBTargetType>
        <d3p1:Id>sample string 1</d3p1:Id>
        <d3p1:IsBackUpStore>true</d3p1:IsBackUpStore>
        <d3p1:IsIgnore>true</d3p1:IsIgnore>
        <d3p1:IsLocked>true</d3p1:IsLocked>
        <d3p1:IsRunSuccess>true</d3p1:IsRunSuccess>
        <d3p1:Log_CreatedBy>sample string 14</d3p1:Log_CreatedBy>
        <d3p1:Log_CreatedDate>1.1</d3p1:Log_CreatedDate>
        <d3p1:Note>sample string 7</d3p1:Note>
        <d3p1:ObjectName>sample string 11</d3p1:ObjectName>
        <d3p1:RunAt>1.1</d3p1:RunAt>
        <d3p1:RunBy>sample string 5</d3p1:RunBy>
        <d3p1:RunResult>sample string 6</d3p1:RunResult>
        <d3p1:ScriptContent>sample string 4</d3p1:ScriptContent>
        <d3p1:ScriptFormated>sample string 15</d3p1:ScriptFormated>
        <d3p1:ScriptName>sample string 3</d3p1:ScriptName>
        <d3p1:btn_ForceSuccess>sample string 17</d3p1:btn_ForceSuccess>
        <d3p1:btn_RunScript>sample string 8</d3p1:btn_RunScript>
      </d3p1:ConfigSQLScriptReleaseModel>
    </d2p1:DataTotal>
  </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>
</EzyResultObjectOfEzyDataSourceResultOfConfigSQLScriptReleaseModelny0pkP0fUXXDg0Sb>