GetFileTableFields method
Lists the fields of a table for a folder connection.
FileType
Recognized file formats are:
- CSV for Delimited
- FIX for Fixed Record
- DIF for Data Interchange Format
- EXCEL_BIFF for Microsoft Excel (XLS)
- EXCEL_OOXML for Microsoft Excel (XLSX)
- HTML for HTML
- QVD for QVD file
- XML for XML
- QVX for QVX file
- JSON for JSON format
- KML for KML file
- PARQUET for PARQUET file
Parameters
| Name | Description | Mandatory | Type |
|---|---|---|---|
| qConnectionId |
Identifier of the connection. |
Yes | String |
| qRelativePath |
Path of the connection file. |
No | String |
| qDataFormat |
Type of the file. |
Yes | FileDataFormat |
| qTable |
Name of the table. This parameter must be set for XLS , XLSX , _HTML _ and XML files. |
Yes | String |
Returns
| Name | Description | Type |
|---|---|---|
| qFields |
List of the tables. |
Array of DataField |
| qFormatSpec |
List of format specification items, within brackets. Examples of specification items:
|
String |
Access Control
reload