List the values of a table for a folder connection
List the values in a table for a folder connection by using the GetFileTablePreview method.
Example
The identifier of the connection file is B6F63CFE-BF978B6D-0E0016ED-B8FDCD8F-DE6A0EC2.
The connection file is Qv101.xlsx.
The type of the file is EXCEL_OOXML.
The handle of the request is 1 because the GetFileTablePreview method applies at app level.
The client sends:
{
"jsonrpc": "2.0",
"id": 6,
"method": "GetFileTablePreview",
"handle": 1,
"params": [
"B6F63CFE-BF978B6D-0E0016ED-B8FDCD8F-DE6A0EC2",
"Qv101.xlsx",
{
"qType": "EXCEL_OOXML"
},
"Categories"
]
}
The engine returns:
{
"jsonrpc": "2.0",
"id": 6,
"result": {
"qPreview": [
{
"qValues": [
"CategoryID",
"CategoryName"
]
},
{
"qValues": [
"1",
"Beverages"
]
},
{
"qValues": [
"2",
"Condiments"
]
},
{
"qValues": [
"3",
"Confections"
]
},
{
"qValues": [
"4",
"Dairy Products"
]
},
{
"qValues": [
"5",
"Grains/Cereals"
]
},
{
"qValues": [
"6",
"Meat/Poultry"
]
},
{
"qValues": [
"7",
"Produce"
]
},
{
"qValues": [
"8",
"Seafood"
]
}
],
"qFormatSpec": "(ooxml, embedded labels, table is Categories)"
}
}
The table Categories contains 2 fields CategoryID and CategoryName. Each field contains 8 values.