QuickBaseRecordReader
Not available in Community Designer
| Short Description |
| Ports |
| Metadata |
| QuickBaseRecordReader Attributes |
| Details |
| See also |
Short Description
QuickBaseRecordReader reads data from QuickBase online database.
| Component | Data source | Input ports | Output ports | Each to all outputs | Different to different outputs | Transformation | Transf. req. | Java | CTL | Auto-propagated metadata |
|---|---|---|---|---|---|---|---|---|---|---|
| QuickBaseRecordReader | QuickBase | 0-1 | 1-2 |  | | | | | | |
Icon
Ports
| 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] | |
[1] Only [2] 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 53.12. 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 |
|---|---|---|---|
| Basic | |||
| QuickBase connection | | ID of the connection to the QuickBase online database, see QuickBase Connections | |
| Table ID | | ID of the table in the QuickBase application
data records are to be read from (see the application_stats for getting the table ID) | |
| Records list | List of record IDs (separated by the semicolon) to be read from the specified database table. These records are read first, before the records specified in the input data. | ||
Details
QuickBaseRecordReader reads data from the QuickBase online database (http://quickbase.intuit.com). Records, the IDs of which are specified in the Records list component attribute, are read first. Records with IDs specified in input are read afterward.
The read records are sent through the connected first output port. If the record is erroneous (not present in the database table, e.g.) 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).