QuickBaseRecordWriter

Short Description
Ports
Metadata
QuickBaseRecordWriter Attributes
Details
See also

Short Description

QuickBaseRecordWriter writes data into a QuickBase online database.

Component Data output Input ports Output ports Transformation Transf. required Java CTL Auto-propagated metadata
QuickBaseRecordWriterQuickBase10-1
no
no
no
no
no

Ports

Port typeNumberRequiredDescriptionMetadata
Input0
yes
for input data recordsany
Output0
no
for rejected data records

input metadata enriched by up to two Error Fields for QuickBaseRecordWriter

Metadata

QuickBaseRecordWriter does not propagate metadata.

Table 56.7. Error Fields for QuickBaseRecordWriter

Field numberField nameData typeDescription
optional[1]specified in the error code output fieldinteger | longError code
optional[1]specified in the error message output fieldstringError message

[1] The error fields must be placed behind the input fields.


QuickBaseRecordWriter Attributes

AttributeReqDescriptionPossible values
Basic
QuickBase connection
yes

ID of the connection to the QuickBase online database, see QuickBase Connections

 
Table ID
yes

ID of the table in the QuickBase application data records are to be written into (see the application_stats for getting the table ID)

 
Mapping
yes

List of database table field_ids separated by a semicolon the metadata field values are to be written to.

 
Error code output field 

Name of the field the error code will be stored in, see Error Fields for QuickBaseRecordWriter

 
Error message output field 

Name of the field the error message will be stored in, see Error Fields for QuickBaseRecordWriter

 

Details

QuickBaseRecordWriter receives data records through the input port and writes them to a QuickBase online database.

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

If the optional output port is connected, rejected records along with the information about the error are sent out through it.