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."

results matching ""

    No results matching ""