POST api/userquery/create

Request Information

URI Parameters

None.

Body Parameters

Name	Type	Additional information
UserQueryID	integer	None.
QueryTypeID	integer	None.
QueryTitle	string	None.
ServerName	string	None.
ServerIP	string	None.
DatabaseName	string	None.
DatabaseType	string	None.
CommandString	string	None.
CommandType	string	None.
DatabaseUserId	string	None.
DatabasePassword	string	None.
DateCreated	date	None.
DateUpdated	date	None.
CreatedBy	integer	None.
VoidFlag	boolean	None.
SqlAuthentication	boolean	None.
FlagDeleted	boolean	None.

Request Formats

application/json, text/json

Sample:

{
  "UserQueryID": 1,
  "QueryTypeID": 2,
  "QueryTitle": "sample string 3",
  "ServerName": "sample string 4",
  "ServerIP": "sample string 5",
  "DatabaseName": "sample string 6",
  "DatabaseType": "sample string 7",
  "CommandString": "sample string 8",
  "CommandType": "sample string 9",
  "DatabaseUserId": "sample string 10",
  "DatabasePassword": "sample string 11",
  "DateCreated": "2025-10-26T11:15:50.6770767+08:00",
  "DateUpdated": "2025-10-26T11:15:50.6770767+08:00",
  "CreatedBy": 14,
  "VoidFlag": true,
  "SqlAuthentication": true,
  "FlagDeleted": true
}

application/xml, text/xml

Sample:

<DTOSYSUserQuery xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/PTI.AF.DTO">
  <CommandString>sample string 8</CommandString>
  <CommandType>sample string 9</CommandType>
  <CreatedBy>14</CreatedBy>
  <DatabaseName>sample string 6</DatabaseName>
  <DatabasePassword>sample string 11</DatabasePassword>
  <DatabaseType>sample string 7</DatabaseType>
  <DatabaseUserId>sample string 10</DatabaseUserId>
  <DateCreated>2025-10-26T11:15:50.6770767+08:00</DateCreated>
  <DateUpdated>2025-10-26T11:15:50.6770767+08:00</DateUpdated>
  <FlagDeleted>true</FlagDeleted>
  <QueryTitle>sample string 3</QueryTitle>
  <QueryTypeID>2</QueryTypeID>
  <ServerIP>sample string 5</ServerIP>
  <ServerName>sample string 4</ServerName>
  <SqlAuthentication>true</SqlAuthentication>
  <UserQueryID>1</UserQueryID>
  <VoidFlag>true</VoidFlag>
</DTOSYSUserQuery>

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

Response Information

Resource Description

DTOSYSUserQuery

Name	Type	Additional information
UserQueryID	integer	None.
QueryTypeID	integer	None.
QueryTitle	string	None.
ServerName	string	None.
ServerIP	string	None.
DatabaseName	string	None.
DatabaseType	string	None.
CommandString	string	None.
CommandType	string	None.
DatabaseUserId	string	None.
DatabasePassword	string	None.
DateCreated	date	None.
DateUpdated	date	None.
CreatedBy	integer	None.
VoidFlag	boolean	None.
SqlAuthentication	boolean	None.
FlagDeleted	boolean	None.

Response Formats

application/json, text/json

Sample:

{
  "UserQueryID": 1,
  "QueryTypeID": 2,
  "QueryTitle": "sample string 3",
  "ServerName": "sample string 4",
  "ServerIP": "sample string 5",
  "DatabaseName": "sample string 6",
  "DatabaseType": "sample string 7",
  "CommandString": "sample string 8",
  "CommandType": "sample string 9",
  "DatabaseUserId": "sample string 10",
  "DatabasePassword": "sample string 11",
  "DateCreated": "2025-10-26T11:15:50.6770767+08:00",
  "DateUpdated": "2025-10-26T11:15:50.6770767+08:00",
  "CreatedBy": 14,
  "VoidFlag": true,
  "SqlAuthentication": true,
  "FlagDeleted": true
}

application/xml, text/xml

Sample:

<DTOSYSUserQuery xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/PTI.AF.DTO">
  <CommandString>sample string 8</CommandString>
  <CommandType>sample string 9</CommandType>
  <CreatedBy>14</CreatedBy>
  <DatabaseName>sample string 6</DatabaseName>
  <DatabasePassword>sample string 11</DatabasePassword>
  <DatabaseType>sample string 7</DatabaseType>
  <DatabaseUserId>sample string 10</DatabaseUserId>
  <DateCreated>2025-10-26T11:15:50.6770767+08:00</DateCreated>
  <DateUpdated>2025-10-26T11:15:50.6770767+08:00</DateUpdated>
  <FlagDeleted>true</FlagDeleted>
  <QueryTitle>sample string 3</QueryTitle>
  <QueryTypeID>2</QueryTypeID>
  <ServerIP>sample string 5</ServerIP>
  <ServerName>sample string 4</ServerName>
  <SqlAuthentication>true</SqlAuthentication>
  <UserQueryID>1</UserQueryID>
  <VoidFlag>true</VoidFlag>
</DTOSYSUserQuery>