TableGetTableApplyDetail
Get Application Form Details
This interface is used to get the details of the specified table application form. Currently, only five types of application form queries are supported, including adding, modifying, deleting, truncating, and merging table data. The permissions of adding table, modifying table, truncating table, deleting table, and merging table data are still used.
If you do not have permission to approve a form, you can use this interface to get the form status, obtain the transaction id and transaction set_id of the form, and operate other transactions.
Request address
GET
http://OmsAddress/app/newoms.php/webservice/business/table/get-table-apply-detail/<uid>?cmd=10008&ip-type=webservicerest&access-token=AccessTokenVal
GET parameter description in url
| Parameter name | Data type | Description | Whether the field is required | Remarks |
|---|---|---|---|---|
| uid | integer | id of the application form | Yes | |
| cmd (cmdVal) | integer | Interface type. Get the application form for adding tables: cmd=10002; get the application form for modifying tables: cmd=10003; get the application form for truncating tables: cmd=10004; get the application form for deleting tables: cmd=10005; get the application form for merging table data: cmd=10008 | Yes |
Return Syntax
Return Parameter Description
When the returned status code is not 200, it indicates that the query was unsuccessful, and the returned data is error message
When the returned status code is 200, it indicates that the details of the application form were got successfully, and the returned data is the information contained in the application form
| Field | Field description | Remarks |
|---|---|---|
| id | id of the application form | |
| set_id | set id of the table | |
| app_id | app id of the table | |
| zone_list | game zone id of the table | |
| table_name | table name | |
| table_type | table type | 0: generic 1: list |
| table_maxnum | Format of the largest element of table | The value is meaningful only when table_type = 1 |
| apply_type | Type of application operation | 0: Table addition 1: Table deletion 2: Table truncation 3: Table modification 7: Table data merge |
| ext_zone_id | id of the target game zone of the application form for merging table data when apply_type = 7 | |
| user | user name of application form | |
| execute_status | form status | -1: rejected 0: to be approved 1: approved and committed transaction 2: transaction executed successfully |
| execute_user | name of the user who approves the form | |
| trans_id | id of the transaction generated by the form |
Request Example
Send A Request through the Curl Method
For the parameters in the command, please refer to the "Description of POST Request Parameters" on this page. For the method to obtain access-token, see: Get access-token
curl -H "Content-type: application/json" -X "GET" http://omsaddress/app/newoms.php/webservice/business/table/get-table-apply-detail/%3Cuid%3E?cmd=10008&ip-type=webservicerest&access-token=\
&uid=\
Return Example
Successful Return Example
Status of http request = 200
{
"id": 289,
"set_id": 126,
"app_id": 3,
"zone_list": "1",
"table_name": "table_in_same_svr",
"table_type": 0,
"table_maxnum": 0,
"apply_type": 7,
"ext_zone_id": "2",
"user": "tcaplus",
"execute_status": 1,
"execute_user": "tcaplus",
"trans_id": "201"
}
Failed Return Example
Status of http request != 200
{
"name": "Unauthorized",
"message": "You are requesting with an invalid credential.",
"code": 0,
"status": 401,
"type": "yii\\web UnauthorizedHttpException"
}
{
"uid": [
"ip(10.29.89.37) not in whitelist for getting table apply detail(cmd:10008) in set_id:126 app_id:3 zone_id:1 table_name:table_in_same_svr"
]
}