QuickBaseRecordReader

Development > Component reference > Readers > QuickBaseRecordReader

Short description

Ports

Metadata

QuickBaseRecordReader attributes

Details

Short description

QuickBaseRecordReader reads data from a QuickBase online database.

Data source	Input ports	Output ports	Each to all outputs	Different to different outputs	Transformation	Transf. req.	Java	CTL	Auto-propagated metadata
QuickBase	0-1	1-2	⨯	⨯	⨯	⨯	⨯	⨯	⨯

Data source

Input ports

Output ports

Each to all outputs

Different to different outputs

Transformation

Transf. req.

Java

CTL

Auto-propagated metadata

QuickBase

0-1

1-2

⨯

Ports

Port type Number Required Description Metadata

Port type	Number	Required	Description	Metadata
Input	0	⨯	For getting application table record IDs to be read.	first field: `integer \| long`
Output	0	✓	For correct data records.	Data types and positions of fields must fit the table field types.^[1]
1	⨯	information about rejected records	Error metadata for QuickBaseRecordReader ^[2]

Input

⨯

For getting application table record IDs to be read.

first field: integer | long

Output

✓

For correct data records.

Data types and positions of fields must fit the table field types.^[1]

⨯

information about rejected records

Error metadata for QuickBaseRecordReader ^[2]

¹	Only `source_row_count` autofilling function returning the record ID can be used.

²	Error metadata cannot use Autofilling functions.

Metadata

QuickBaseRecordReader does not propagate metadata.

QuickBaseRecordReader has no metadata template.

Metadata fields on error port have to have the following structure:

Table 49. Error metadata for QuickBaseRecordReader
Field number	Field name	Data type	Description
0	<any_name1>	integer \| long	ID of the erroneous record
1	<any_name2>	integer \| long	error code
2	<any_name3>	string	error message

QuickBaseRecordReader attributes

Attribute Req Description Possible values

Attribute	Req	Description	Possible values
Basic
QuickBase connection	✓	The ID of the connection to the QuickBase online database, see QuickBase connections.
Table ID	✓	The ID of the table in the QuickBase application data records are to be get from. Select a table in the QuickBase UI and copy the table ID from the browser URL: `https://mydomain.quickbase.com/db/TABLE_ID`.	e.g. `bqib669xe`
Records list		The list of record IDs (separated by a semicolon) to be read from the specified database table. These records are read first, before the records specified in the input data.

Basic

QuickBase connection

✓

The ID of the connection to the QuickBase online database, see QuickBase connections.

Table ID

✓

The ID of the table in the QuickBase application data records are to be get from. Select a table in the QuickBase UI and copy the table ID from the browser URL: https://mydomain.quickbase.com/db/TABLE_ID.

e.g. bqib669xe

Records list

The list of record IDs (separated by a semicolon) to be read from the specified database table. These records are read first, before the records specified in the input data.

Figure 341. Obtaining Table ID

Details

QuickBaseRecordReader reads data from a QuickBase online database. Records, the IDs of which are specified in the Records list component attribute, are read first. Records with IDs specified in the input are read afterward.

The read records are sent through the connected first output port. If the record is erroneous (e.g. not present in the database table), it can can be sent out through the optional second port if it is connected.

This component wraps the API_GetRecordInfo HTTP interaction (http://www.quickbase.com/api-guide/getrecordinfo.html).

{{{ highlightedName }}}