POST api/v1/SQLExecCompare/Options

Request Information

URI Parameters

None.

Body Parameters

Name	Type	Additional information
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:

{
  "FilterQuery": null,
  "ScreenGUID": "sample string 1",
  "DocumentWidth": 2,
  "Url": "sample string 3",
  "OptionConfigsMore": null,
  "QuerySearch": null,
  "IsTestCase": true
}

application/xml, text/xml

Sample:

<SQLExecCompareParamModel xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/AllianceSolidAPI.Shared.Models">
  <DocumentWidth xmlns="http://schemas.datacontract.org/2004/07/Ezy.Module.BaseData.Models">2</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 1</ScreenGUID>
  <Url xmlns="http://schemas.datacontract.org/2004/07/Ezy.Module.BaseData.Models">sample string 3</Url>
</SQLExecCompareParamModel>

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

Response Information

Resource Description

EzyResultObjectOfSQLExecCompareOptionModel

Name	Type	Additional information
Data	SQLExecCompareOptionModel	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": {
    "SQLExecItemList": [
      {
        "Value": "sample string 1",
        "Text": "sample string 2",
        "Text_Filter": "sample string 3",
        "Text_Display": "sample string 4"
      },
      {
        "Value": "sample string 1",
        "Text": "sample string 2",
        "Text_Filter": "sample string 3",
        "Text_Display": "sample string 4"
      }
    ],
    "Configs": null,
    "ButtonList": [
      {
        "Color_BG": "sample string 1",
        "Color": "sample string 2",
        "OpenMode": "sample string 3",
        "APIName": "sample string 4",
        "MethodType": "sample string 5",
        "NeedReload": true,
        "NeedReloadList": true,
        "Form": {
          "Title": "sample string 1",
          "ConfirmMsg": "sample string 2",
          "Direction": "sample string 3",
          "Data": [
            {
              "Type": "sample string 1",
              "Props": {},
              "Label": "sample string 3",
              "SubmitAfterChange": true,
              "FieldName": "sample string 4",
              "Source": "sample string 5",
              "SourceField": "sample string 6",
              "SourceList": {},
              "Hint": "sample string 8",
              "Required": true,
              "Disabled": true,
              "Style": {}
            },
            {
              "Type": "sample string 1",
              "Props": {},
              "Label": "sample string 3",
              "SubmitAfterChange": true,
              "FieldName": "sample string 4",
              "Source": "sample string 5",
              "SourceField": "sample string 6",
              "SourceList": {},
              "Hint": "sample string 8",
              "Required": true,
              "Disabled": true,
              "Style": {}
            }
          ]
        },
        "RequestData": null,
        "ConfirmMsg": "sample string 8",
        "More": null,
        "Type": "sample string 9",
        "Icon": "sample string 10",
        "Name": "sample string 11",
        "Code": "sample string 12",
        "Url": "sample string 13"
      },
      {
        "Color_BG": "sample string 1",
        "Color": "sample string 2",
        "OpenMode": "sample string 3",
        "APIName": "sample string 4",
        "MethodType": "sample string 5",
        "NeedReload": true,
        "NeedReloadList": true,
        "Form": {
          "Title": "sample string 1",
          "ConfirmMsg": "sample string 2",
          "Direction": "sample string 3",
          "Data": [
            {
              "Type": "sample string 1",
              "Props": {},
              "Label": "sample string 3",
              "SubmitAfterChange": true,
              "FieldName": "sample string 4",
              "Source": "sample string 5",
              "SourceField": "sample string 6",
              "SourceList": {},
              "Hint": "sample string 8",
              "Required": true,
              "Disabled": true,
              "Style": {}
            },
            {
              "Type": "sample string 1",
              "Props": {},
              "Label": "sample string 3",
              "SubmitAfterChange": true,
              "FieldName": "sample string 4",
              "Source": "sample string 5",
              "SourceField": "sample string 6",
              "SourceList": {},
              "Hint": "sample string 8",
              "Required": true,
              "Disabled": true,
              "Style": {}
            }
          ]
        },
        "RequestData": null,
        "ConfirmMsg": "sample string 8",
        "More": null,
        "Type": "sample string 9",
        "Icon": "sample string 10",
        "Name": "sample string 11",
        "Code": "sample string 12",
        "Url": "sample string 13"
      }
    ],
    "HeaderConfig": {
      "ButtonList": [
        {
          "Color_BG": "sample string 1",
          "Color": "sample string 2",
          "OpenMode": "sample string 3",
          "APIName": "sample string 4",
          "MethodType": "sample string 5",
          "NeedReload": true,
          "NeedReloadList": true,
          "Form": {
            "Title": "sample string 1",
            "ConfirmMsg": "sample string 2",
            "Direction": "sample string 3",
            "Data": [
              {
                "Type": "sample string 1",
                "Props": {},
                "Label": "sample string 3",
                "SubmitAfterChange": true,
                "FieldName": "sample string 4",
                "Source": "sample string 5",
                "SourceField": "sample string 6",
                "SourceList": {},
                "Hint": "sample string 8",
                "Required": true,
                "Disabled": true,
                "Style": {}
              },
              {
                "Type": "sample string 1",
                "Props": {},
                "Label": "sample string 3",
                "SubmitAfterChange": true,
                "FieldName": "sample string 4",
                "Source": "sample string 5",
                "SourceField": "sample string 6",
                "SourceList": {},
                "Hint": "sample string 8",
                "Required": true,
                "Disabled": true,
                "Style": {}
              }
            ]
          },
          "RequestData": null,
          "ConfirmMsg": "sample string 8",
          "More": null,
          "Type": "sample string 9",
          "Icon": "sample string 10",
          "Name": "sample string 11",
          "Code": "sample string 12",
          "Url": "sample string 13"
        },
        {
          "Color_BG": "sample string 1",
          "Color": "sample string 2",
          "OpenMode": "sample string 3",
          "APIName": "sample string 4",
          "MethodType": "sample string 5",
          "NeedReload": true,
          "NeedReloadList": true,
          "Form": {
            "Title": "sample string 1",
            "ConfirmMsg": "sample string 2",
            "Direction": "sample string 3",
            "Data": [
              {
                "Type": "sample string 1",
                "Props": {},
                "Label": "sample string 3",
                "SubmitAfterChange": true,
                "FieldName": "sample string 4",
                "Source": "sample string 5",
                "SourceField": "sample string 6",
                "SourceList": {},
                "Hint": "sample string 8",
                "Required": true,
                "Disabled": true,
                "Style": {}
              },
              {
                "Type": "sample string 1",
                "Props": {},
                "Label": "sample string 3",
                "SubmitAfterChange": true,
                "FieldName": "sample string 4",
                "Source": "sample string 5",
                "SourceField": "sample string 6",
                "SourceList": {},
                "Hint": "sample string 8",
                "Required": true,
                "Disabled": true,
                "Style": {}
              }
            ]
          },
          "RequestData": null,
          "ConfirmMsg": "sample string 8",
          "More": null,
          "Type": "sample string 9",
          "Icon": "sample string 10",
          "Name": "sample string 11",
          "Code": "sample string 12",
          "Url": "sample string 13"
        }
      ],
      "Avatar": {},
      "Title": "sample string 2"
    },
    "ChartConfig": {
      "Config": null,
      "Charts": [
        {
          "type": "sample string 1",
          "fX": "sample string 2",
          "fY": "sample string 3",
          "titleX": "sample string 4",
          "titleY": "sample string 5",
          "titleChart": "sample string 6",
          "options": "sample string 7",
          "more": "sample string 8"
        },
        {
          "type": "sample string 1",
          "fX": "sample string 2",
          "fY": "sample string 3",
          "titleX": "sample string 4",
          "titleY": "sample string 5",
          "titleChart": "sample string 6",
          "options": "sample string 7",
          "more": "sample string 8"
        }
      ]
    },
    "Signature": {
      "Config": null,
      "Items": [
        {
          "Id": "sample string 1",
          "Name": "sample string 2",
          "IsChecked": true,
          "OrderNo": 4,
          "OrderNoByTemplate": 5,
          "CanSign": true,
          "CanViewHistory": true,
          "SignedDate": 1.1,
          "SignedById": "sample string 8",
          "SignedById_Name": "sample string 9",
          "EntityId": "sample string 10"
        },
        {
          "Id": "sample string 1",
          "Name": "sample string 2",
          "IsChecked": true,
          "OrderNo": 4,
          "OrderNoByTemplate": 5,
          "CanSign": true,
          "CanViewHistory": true,
          "SignedDate": 1.1,
          "SignedById": "sample string 8",
          "SignedById_Name": "sample string 9",
          "EntityId": "sample string 10"
        }
      ]
    },
    "FormAddNewConfig": {
      "Config": null,
      "Form": null
    }
  },
  "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:

<EzyResultObjectOfSQLExecCompareOptionModel3BwjWE5f 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">
    <ButtonList xmlns="http://schemas.datacontract.org/2004/07/Ezy.Module.BaseData.Models">
      <EzyButtonLinkItem>
        <Code>sample string 12</Code>
        <Name>sample string 11</Name>
        <Url>sample string 13</Url>
        <APIName>sample string 4</APIName>
        <Color>sample string 2</Color>
        <Color_BG>sample string 1</Color_BG>
        <ConfirmMsg>sample string 8</ConfirmMsg>
        <Form>
          <ConfirmMsg>sample string 2</ConfirmMsg>
          <Data>
            <EzyButtonLinkItemData>
              <Disabled>true</Disabled>
              <FieldName>sample string 4</FieldName>
              <Hint>sample string 8</Hint>
              <Label>sample string 3</Label>
              <Props />
              <Required>true</Required>
              <Source>sample string 5</Source>
              <SourceField>sample string 6</SourceField>
              <SourceList />
              <Style />
              <SubmitAfterChange>true</SubmitAfterChange>
              <Type>sample string 1</Type>
            </EzyButtonLinkItemData>
            <EzyButtonLinkItemData>
              <Disabled>true</Disabled>
              <FieldName>sample string 4</FieldName>
              <Hint>sample string 8</Hint>
              <Label>sample string 3</Label>
              <Props />
              <Required>true</Required>
              <Source>sample string 5</Source>
              <SourceField>sample string 6</SourceField>
              <SourceList />
              <Style />
              <SubmitAfterChange>true</SubmitAfterChange>
              <Type>sample string 1</Type>
            </EzyButtonLinkItemData>
          </Data>
          <Direction>sample string 3</Direction>
          <Title>sample string 1</Title>
        </Form>
        <Icon>sample string 10</Icon>
        <MethodType>sample string 5</MethodType>
        <More xmlns:d5p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" i:nil="true" />
        <NeedReload>true</NeedReload>
        <NeedReloadList>true</NeedReloadList>
        <OpenMode>sample string 3</OpenMode>
        <RequestData xmlns:d5p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" i:nil="true" />
        <Type>sample string 9</Type>
      </EzyButtonLinkItem>
      <EzyButtonLinkItem>
        <Code>sample string 12</Code>
        <Name>sample string 11</Name>
        <Url>sample string 13</Url>
        <APIName>sample string 4</APIName>
        <Color>sample string 2</Color>
        <Color_BG>sample string 1</Color_BG>
        <ConfirmMsg>sample string 8</ConfirmMsg>
        <Form>
          <ConfirmMsg>sample string 2</ConfirmMsg>
          <Data>
            <EzyButtonLinkItemData>
              <Disabled>true</Disabled>
              <FieldName>sample string 4</FieldName>
              <Hint>sample string 8</Hint>
              <Label>sample string 3</Label>
              <Props />
              <Required>true</Required>
              <Source>sample string 5</Source>
              <SourceField>sample string 6</SourceField>
              <SourceList />
              <Style />
              <SubmitAfterChange>true</SubmitAfterChange>
              <Type>sample string 1</Type>
            </EzyButtonLinkItemData>
            <EzyButtonLinkItemData>
              <Disabled>true</Disabled>
              <FieldName>sample string 4</FieldName>
              <Hint>sample string 8</Hint>
              <Label>sample string 3</Label>
              <Props />
              <Required>true</Required>
              <Source>sample string 5</Source>
              <SourceField>sample string 6</SourceField>
              <SourceList />
              <Style />
              <SubmitAfterChange>true</SubmitAfterChange>
              <Type>sample string 1</Type>
            </EzyButtonLinkItemData>
          </Data>
          <Direction>sample string 3</Direction>
          <Title>sample string 1</Title>
        </Form>
        <Icon>sample string 10</Icon>
        <MethodType>sample string 5</MethodType>
        <More xmlns:d5p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" i:nil="true" />
        <NeedReload>true</NeedReload>
        <NeedReloadList>true</NeedReloadList>
        <OpenMode>sample string 3</OpenMode>
        <RequestData xmlns:d5p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" i:nil="true" />
        <Type>sample string 9</Type>
      </EzyButtonLinkItem>
    </ButtonList>
    <ChartConfig xmlns="http://schemas.datacontract.org/2004/07/Ezy.Module.BaseData.Models">
      <Charts>
        <ScreenChartConfigItem>
          <fX>sample string 2</fX>
          <fY>sample string 3</fY>
          <more>sample string 8</more>
          <options>sample string 7</options>
          <titleChart>sample string 6</titleChart>
          <titleX>sample string 4</titleX>
          <titleY>sample string 5</titleY>
          <type>sample string 1</type>
        </ScreenChartConfigItem>
        <ScreenChartConfigItem>
          <fX>sample string 2</fX>
          <fY>sample string 3</fY>
          <more>sample string 8</more>
          <options>sample string 7</options>
          <titleChart>sample string 6</titleChart>
          <titleX>sample string 4</titleX>
          <titleY>sample string 5</titleY>
          <type>sample string 1</type>
        </ScreenChartConfigItem>
      </Charts>
      <Config xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" i:nil="true" />
    </ChartConfig>
    <Configs xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" i:nil="true" xmlns="http://schemas.datacontract.org/2004/07/Ezy.Module.BaseData.Models" />
    <FormAddNewConfig xmlns="http://schemas.datacontract.org/2004/07/Ezy.Module.BaseData.Models">
      <Config xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" i:nil="true" />
      <Form xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" i:nil="true" />
    </FormAddNewConfig>
    <HeaderConfig xmlns="http://schemas.datacontract.org/2004/07/Ezy.Module.BaseData.Models">
      <Avatar />
      <ButtonList>
        <EzyButtonLinkItem>
          <Code>sample string 12</Code>
          <Name>sample string 11</Name>
          <Url>sample string 13</Url>
          <APIName>sample string 4</APIName>
          <Color>sample string 2</Color>
          <Color_BG>sample string 1</Color_BG>
          <ConfirmMsg>sample string 8</ConfirmMsg>
          <Form>
            <ConfirmMsg>sample string 2</ConfirmMsg>
            <Data>
              <EzyButtonLinkItemData>
                <Disabled>true</Disabled>
                <FieldName>sample string 4</FieldName>
                <Hint>sample string 8</Hint>
                <Label>sample string 3</Label>
                <Props />
                <Required>true</Required>
                <Source>sample string 5</Source>
                <SourceField>sample string 6</SourceField>
                <SourceList />
                <Style />
                <SubmitAfterChange>true</SubmitAfterChange>
                <Type>sample string 1</Type>
              </EzyButtonLinkItemData>
              <EzyButtonLinkItemData>
                <Disabled>true</Disabled>
                <FieldName>sample string 4</FieldName>
                <Hint>sample string 8</Hint>
                <Label>sample string 3</Label>
                <Props />
                <Required>true</Required>
                <Source>sample string 5</Source>
                <SourceField>sample string 6</SourceField>
                <SourceList />
                <Style />
                <SubmitAfterChange>true</SubmitAfterChange>
                <Type>sample string 1</Type>
              </EzyButtonLinkItemData>
            </Data>
            <Direction>sample string 3</Direction>
            <Title>sample string 1</Title>
          </Form>
          <Icon>sample string 10</Icon>
          <MethodType>sample string 5</MethodType>
          <More xmlns:d6p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" i:nil="true" />
          <NeedReload>true</NeedReload>
          <NeedReloadList>true</NeedReloadList>
          <OpenMode>sample string 3</OpenMode>
          <RequestData xmlns:d6p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" i:nil="true" />
          <Type>sample string 9</Type>
        </EzyButtonLinkItem>
        <EzyButtonLinkItem>
          <Code>sample string 12</Code>
          <Name>sample string 11</Name>
          <Url>sample string 13</Url>
          <APIName>sample string 4</APIName>
          <Color>sample string 2</Color>
          <Color_BG>sample string 1</Color_BG>
          <ConfirmMsg>sample string 8</ConfirmMsg>
          <Form>
            <ConfirmMsg>sample string 2</ConfirmMsg>
            <Data>
              <EzyButtonLinkItemData>
                <Disabled>true</Disabled>
                <FieldName>sample string 4</FieldName>
                <Hint>sample string 8</Hint>
                <Label>sample string 3</Label>
                <Props />
                <Required>true</Required>
                <Source>sample string 5</Source>
                <SourceField>sample string 6</SourceField>
                <SourceList />
                <Style />
                <SubmitAfterChange>true</SubmitAfterChange>
                <Type>sample string 1</Type>
              </EzyButtonLinkItemData>
              <EzyButtonLinkItemData>
                <Disabled>true</Disabled>
                <FieldName>sample string 4</FieldName>
                <Hint>sample string 8</Hint>
                <Label>sample string 3</Label>
                <Props />
                <Required>true</Required>
                <Source>sample string 5</Source>
                <SourceField>sample string 6</SourceField>
                <SourceList />
                <Style />
                <SubmitAfterChange>true</SubmitAfterChange>
                <Type>sample string 1</Type>
              </EzyButtonLinkItemData>
            </Data>
            <Direction>sample string 3</Direction>
            <Title>sample string 1</Title>
          </Form>
          <Icon>sample string 10</Icon>
          <MethodType>sample string 5</MethodType>
          <More xmlns:d6p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" i:nil="true" />
          <NeedReload>true</NeedReload>
          <NeedReloadList>true</NeedReloadList>
          <OpenMode>sample string 3</OpenMode>
          <RequestData xmlns:d6p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" i:nil="true" />
          <Type>sample string 9</Type>
        </EzyButtonLinkItem>
      </ButtonList>
      <Title>sample string 2</Title>
    </HeaderConfig>
    <Signature xmlns="http://schemas.datacontract.org/2004/07/Ezy.Module.BaseData.Models">
      <Config xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" i:nil="true" />
      <Items>
        <ScreenSignatureItem>
          <CanSign>true</CanSign>
          <CanViewHistory>true</CanViewHistory>
          <EntityId>sample string 10</EntityId>
          <Id>sample string 1</Id>
          <IsChecked>true</IsChecked>
          <Name>sample string 2</Name>
          <OrderNo>4</OrderNo>
          <OrderNoByTemplate>5</OrderNoByTemplate>
          <SignedById>sample string 8</SignedById>
          <SignedById_Name>sample string 9</SignedById_Name>
          <SignedDate>1.1</SignedDate>
        </ScreenSignatureItem>
        <ScreenSignatureItem>
          <CanSign>true</CanSign>
          <CanViewHistory>true</CanViewHistory>
          <EntityId>sample string 10</EntityId>
          <Id>sample string 1</Id>
          <IsChecked>true</IsChecked>
          <Name>sample string 2</Name>
          <OrderNo>4</OrderNo>
          <OrderNoByTemplate>5</OrderNoByTemplate>
          <SignedById>sample string 8</SignedById>
          <SignedById_Name>sample string 9</SignedById_Name>
          <SignedDate>1.1</SignedDate>
        </ScreenSignatureItem>
      </Items>
    </Signature>
    <d2p1:SQLExecItemList xmlns:d3p1="http://schemas.datacontract.org/2004/07/Ezy.Module.Library.Data">
      <d3p1:BaseCategoryItem>
        <d3p1:Text>sample string 2</d3p1:Text>
        <d3p1:Text_Display>sample string 4</d3p1:Text_Display>
        <d3p1:Text_Filter>sample string 3</d3p1:Text_Filter>
        <d3p1:Value>sample string 1</d3p1:Value>
      </d3p1:BaseCategoryItem>
      <d3p1:BaseCategoryItem>
        <d3p1:Text>sample string 2</d3p1:Text>
        <d3p1:Text_Display>sample string 4</d3p1:Text_Display>
        <d3p1:Text_Filter>sample string 3</d3p1:Text_Filter>
        <d3p1:Value>sample string 1</d3p1:Value>
      </d3p1:BaseCategoryItem>
    </d2p1:SQLExecItemList>
  </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>
</EzyResultObjectOfSQLExecCompareOptionModel3BwjWE5f>