ApexERPHost

ExecuteDbServerAction

**Requires Authentication**
Required role:	SysAdmin

The following routes are available for this service:
POST	/dbadmin/servers/databases/action/{ActionId*}
POST	/dbadmin/servers/{ServerId}/databases/action/{ActionId*}

**ExecuteDbServerAction** Parameters:
Name	Parameter	Data Type	Required
ServerId	path	string	No
DbName	body	string	No
ActionId	path	string	No
Parameters	body	Dictionary<string, string>	No

**ExecuteDbServerActionResponse** Parameters:
Name	Parameter	Data Type	Required
ResponseStatus	form	ResponseStatus	No
ResultSet	form	List<DynamicData>	No
Meta	form	Dictionary<string, string>	No

**DynamicData** Parameters:
Name	Parameter	Data Type	Required	Description
Schema	form	DynamicDataSchema	No
Data	form	List<List<String>>	No

**DynamicDataSchema** Parameters:
Name	Parameter	Data Type	Required	Description
Name	form	string	No
Columns	form	List<DataColumnInfo>	No

**DataColumnInfo** Parameters:
Name	Parameter	Data Type	Required
Id	form	int	No
Name	form	string	No
Type	form	int	No
MaxLength	form	int?	No
Format	form	string	No
ComplexTypeSchema	form	DynamicDataSchema	No

To override the Content-type in your clients, use the HTTP Accept Header, append the .x-protobuf suffix or ?format=x-protobuf

HTTP + X-PROTOBUF

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

POST /dbadmin/servers/databases/action/{ActionId*} HTTP/1.1 
Host: apex.nikoratrade.ge 
Accept: application/x-protobuf
Content-Type: application/x-protobuf
Content-Length: length

{"ServerId":"String","DbName":"String","ActionId":"String","Parameters":{"String":"String"}}

HTTP/1.1 200 OK
Content-Type: application/x-protobuf
Content-Length: length

{"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}},"ResultSet":[{"Schema":{"Name":"String","Columns":[{"Id":0,"Name":"String","Type":0,"MaxLength":0,"Format":"String","ComplexTypeSchema":{"Name":"String","Columns":[{"Id":0,"Name":"String","Type":0,"MaxLength":0,"Format":"String","ComplexTypeSchema":{"Name":"String","Columns":[{"Id":0,"Name":"String","Type":0,"MaxLength":0,"Format":"String"}]}}]}}]},"Data":[["String"]]}],"Meta":{"String":"String"}}