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
  • 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
qFields

List of the tables.

Array of DataField
qFormatSpec

List of format specification items, within brackets. Examples of specification items:

  • file type
  • embedded labels, no labels
  • table is <table name>
String

Access Control

reload