The handle of the request is 1 because the GetDatabaseTableFields method applies at app level.
The identifier of the connection is C6B69168-9C3CDDFA-9E6DE0F2-72CB57FD-59720244.
The name of the database is AdventureWorks , the name of the owner is HumanResources and the name of the table is Department.
The client sends:
{
"jsonrpc": "2.0",
"id": 8,
"method": "GetDatabaseTableFields",
"handle": 1,
"params": [
"C6B69168-9C3CDDFA-9E6DE0F2-72CB57FD-59720244",
"AdventureWorks",
"HumanResources",
"Department"
]
}
The engine returns:
{
"jsonrpc": "2.0",
"id": 8,
"result": {
"qFields": [
{
"qName": "DepartmentID",
"qIsKey": true
},
{
"qName": "Name"
},
{
"qName": "GroupName"
},
{
"qName": "ModifiedDate"
}
]
}
}
The list of the fields in the table Department is displayed. The field DepartmentID is a primary key.