GetTableApplyListInApp
Get Unfinished Application List in the App, including Adding, Modifying, Truncating, Deleting, and Copying Table Data
Unfinished application forms are those that have yet to be confirmed as well as those that have generated corresponding transactions but have not yet completed them. This interface only provides query function, and the returned information is only part information of the application forms. For more detailed information about applications and the execution of application forms, please operate according to the interfaces of various types of application forms. The interface command cmd for processing various types of applicationforms is as follows:
| Application type | Command word (cmd) |
|---|---|
| Add table (apply_type = 0) | 10002 |
| Delete table (apply_type = 1) | 10005 |
| Truncate table (apply_type = 2) | 10004 |
| Modify table (apply_type = 3) | 10003 |
| Copy table data (apply_type = 7) | 10008 |
Request address
POST
http://OmsAddress/app/newoms.php/webservice/business/table/get-table-apply-list-in-app?cmd=10010&ip-type=webservicerest&access-token=AccessTokenVal
POST request parameter description
| Parameter name | Data type | Description | Whether the field is required | Remarks |
|---|---|---|---|---|
| app_id | integer | App of the data to be queried | Yes | |
| zone_id | integer | Zone of the data to be queried | No, the default is to specify all zones under the app | |
| table_name_list | Array | List of table names to be queried | No, the default is to specify all table names under the app | |
| only_incomplete | integer | Whether to query only unfinished application forms. 1: Yes; 0: No. | No, the default value is 1 | |
| only_apply_to_op_table | integer | Whether to query only application forms related to table operations (add, modify, truncate, delete, and rebuild tables). 1: Yes; 0: No. | No, the default value is 1 |
Data Parameters
Use json format to represent the record related information. The following is an example:
{
"app_id": 2,
"zone_id": 3
}
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 information
When the returned status code is 200, it indicates that the query was successful, and the returned information is the specified set_id and app_id
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 "POST" -d '{
"app_id": 2,
"zone_id": 3
}' http://omsaddress/app/newoms.php/webservice/business/table/get-table-apply-list-in-app?cmd=10010&ip-type=webservicerest&access-token=\
Return Example
Successful Return Example
Status of http request = 200
[
{
"id": "112",
"set_id": "1",
"app_id": "2",
"zone_list": "3",
"table_name": "add_table5",
"table_type": "0",
"table_maxnum": "0",
"apply_type": "0",
"ext_zone_id": null,
"user": "yunwei_1",
"execute_status": "0",
"execute_user": "",
"trans_id": "",
"write_time": "2019-05-29 17:22:05"
}
]
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"
}
{
"source_ip": "ip:10.29.89.51 not in whitelist"
}