POST api/Connectors/GetAllSQL

Request Information

URI Parameters

None.

Body Parameters

Name	Type	Additional information
Customer	string	None.
SQLs	Collection of Connectors_SQL	None.
SearchCriteria	Connectors_SQL	None.
Pager	Pager	None.
IsSuccess	boolean	None.
Message	string	None.
Value	Object	None.

Request Formats

application/json, text/json

Sample:

{
  "Customer": "sample string 1",
  "SQLs": [
    {
      "ID": 1,
      "Descr": "sample string 2",
      "Customer": "sample string 3",
      "sqlServer": "sample string 4",
      "sqlUserName": "sample string 5",
      "sqlPassword": "sample string 6",
      "sqlDatabase": "sample string 7",
      "DatabaseType": 8,
      "ColumnName": "sample string 9",
      "SortDirection": "sample string 10",
      "IsSuccess": true,
      "Message": "sample string 12",
      "Value": {}
    },
    {
      "ID": 1,
      "Descr": "sample string 2",
      "Customer": "sample string 3",
      "sqlServer": "sample string 4",
      "sqlUserName": "sample string 5",
      "sqlPassword": "sample string 6",
      "sqlDatabase": "sample string 7",
      "DatabaseType": 8,
      "ColumnName": "sample string 9",
      "SortDirection": "sample string 10",
      "IsSuccess": true,
      "Message": "sample string 12",
      "Value": {}
    }
  ],
  "SearchCriteria": {
    "ID": 1,
    "Descr": "sample string 2",
    "Customer": "sample string 3",
    "sqlServer": "sample string 4",
    "sqlUserName": "sample string 5",
    "sqlPassword": "sample string 6",
    "sqlDatabase": "sample string 7",
    "DatabaseType": 8,
    "ColumnName": "sample string 9",
    "SortDirection": "sample string 10",
    "IsSuccess": true,
    "Message": "sample string 12",
    "Value": {}
  },
  "Pager": {
    "PageSize": 1,
    "Take": 2,
    "Skip": 3,
    "CurrentPage": 4.0,
    "TotalPage": "sample string 5",
    "TotalRecord": 6.0
  },
  "IsSuccess": true,
  "Message": "sample string 3",
  "Value": {}
}

application/xml, text/xml

Sample:

<SQLLister xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Domain">
  <IsSuccess>true</IsSuccess>
  <Message>sample string 3</Message>
  <Value />
  <Customer>sample string 1</Customer>
  <Pager>
    <CurrentPage>4</CurrentPage>
    <PageSize>1</PageSize>
    <Skip>3</Skip>
    <Take>2</Take>
    <TotalPage>sample string 5</TotalPage>
    <TotalRecord>6</TotalRecord>
  </Pager>
  <SQLs>
    <Connectors_SQL>
      <IsSuccess>true</IsSuccess>
      <Message>sample string 12</Message>
      <Value />
      <ColumnName>sample string 9</ColumnName>
      <Customer>sample string 3</Customer>
      <DatabaseType>8</DatabaseType>
      <Descr>sample string 2</Descr>
      <ID>1</ID>
      <SortDirection>sample string 10</SortDirection>
      <sqlDatabase>sample string 7</sqlDatabase>
      <sqlPassword>sample string 6</sqlPassword>
      <sqlServer>sample string 4</sqlServer>
      <sqlUserName>sample string 5</sqlUserName>
    </Connectors_SQL>
    <Connectors_SQL>
      <IsSuccess>true</IsSuccess>
      <Message>sample string 12</Message>
      <Value />
      <ColumnName>sample string 9</ColumnName>
      <Customer>sample string 3</Customer>
      <DatabaseType>8</DatabaseType>
      <Descr>sample string 2</Descr>
      <ID>1</ID>
      <SortDirection>sample string 10</SortDirection>
      <sqlDatabase>sample string 7</sqlDatabase>
      <sqlPassword>sample string 6</sqlPassword>
      <sqlServer>sample string 4</sqlServer>
      <sqlUserName>sample string 5</sqlUserName>
    </Connectors_SQL>
  </SQLs>
  <SearchCriteria>
    <IsSuccess>true</IsSuccess>
    <Message>sample string 12</Message>
    <Value />
    <ColumnName>sample string 9</ColumnName>
    <Customer>sample string 3</Customer>
    <DatabaseType>8</DatabaseType>
    <Descr>sample string 2</Descr>
    <ID>1</ID>
    <SortDirection>sample string 10</SortDirection>
    <sqlDatabase>sample string 7</sqlDatabase>
    <sqlPassword>sample string 6</sqlPassword>
    <sqlServer>sample string 4</sqlServer>
    <sqlUserName>sample string 5</sqlUserName>
  </SearchCriteria>
</SQLLister>

application/x-www-form-urlencoded

Sample:

Sample not available.

Response Information

Resource Description

HttpResponseMessage

Name	Type	Additional information
Version	Version	None.
Content	HttpContent	None.
StatusCode	HttpStatusCode	None.
ReasonPhrase	string	None.
Headers	Collection of Object	None.
RequestMessage	HttpRequestMessage	None.
IsSuccessStatusCode	boolean	None.