Get TableIndex Details [GetTableIndex]
Version requirement: 3.61.1
Request address http://URL/app/newoms.php/webservice/business/table/get-table-index?cmd=10022&ip-type=webservicerest&access-token=Token
Request parameters
{
"app_id": 2,
"zone_id": 4,
"table_name": "chat_area_rank"
}
Return Description Case 1: Success, the http status code: 200
{
"ret": 0,
"info": {
"app_id": 2,
"zone_id": 4,
"table_name": "chat_area_rank",
"table_index": {
"DbTable": [
{
"TablePrefix": "",
"SubTableCount": 0,
"ValueFields": { // Which value fields in the table are configured with global indexes
"FieldNum": 0
},
"KeyFields": { // Which key fields in the table are configured with global indexes
"FieldNum": 1, // Number of configured fields
"Field": [
{
"FieldName": "ChatAreaId", // Field Name
"DbFieldName": ""
}
]
},
"Deploy": { // Deployment information, this field can be ignored for global indexes
"SubTableStorePlaceNum": 1,
"SubTableStorePlace": [
{
"SubTableIndexStart": 0,
"SubTableIndexEnd": 0,
"DbSourceName": "DbSource"
}
]
}
}
],
"ShardNum": 1 //Shard Num
}
},
"msg": ""
}
Case 2: Failure, the reason is that the table has not configured with index http status code: 422 content: "error:table have not been deployed table index."