GetFileTablePreview method
Lists the values in a table for a folder connection.
FileType
Recognized file formats are:
- CSV for Delimited
- FIX for Fixed Record
- DIF for Data Interchange Format
- _EXCELBIFF for Microsoft Excel (XLS)
- _EXCELOOXML 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
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 |
|---|---|---|
| qPreview | List of the tables. |
Array of DataRecord |
| qFormatSpec | List of format specification items, within brackets. Examples of specification items:
|
String |