GetDatabaseTablePreview method

Overview

Retrieves the values of the specified table of a database for a ODBC, OLEDB or CUSTOM connection.

Name	Description	Type
qConnectionId	Identifier of the connection. This parameter is mandatory.	String
qDatabase	Name of the database. This parameter is optional. If qDatabase is not set then qOwner must be set.	String
qOwner	Owner of the database. This parameter is optional. If qOwner is not set then qDatabase must be set.	String
qTable	Name of the table. This parameter is mandatory.	String

The following is returned in the output:

Name	Description	Type
qPreview	List the values in the table.	Array of DataRecord.

Name

Description

Type

qPreview

List the values in the table.

Name	Description	Type
qValues	List of values inside the table. The first values (in result/qPreview/0/qValues) correspond to the field names in the table. The following values (from result/qPreview/1/qValues) are the values of the fields in the table.	Array of String

Name

Description

Type

qValues

List of values inside the table.

The first values (in result/qPreview/0/qValues) correspond to the field names in the table.

The following values (from result/qPreview/1/qValues) are the values of the fields in the table.

Array of String

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!