Version

    QuickBaseRecordWriter

    Short Description
    Ports
    Metadata
    QuickBaseRecordWriter Attributes
    Details
    See also

    Short Description

    QuickBaseRecordWriter writes data into a QuickBase online database.

    ComponentData outputInput portsOutput portsTransformationTransf. requiredJavaCTLAuto-propagated metadata
    QuickBaseRecordWriterQuickBase10-1
    no
    no
    no
    no
    no

    Ports

    Port typeNumberRequiredDescriptionMetadata
    Input0
    yes
    for input data recordsany
    Output0
    no
    for rejected data recordsInput metadata enriched by up to two Error Fields for QuickBaseRecordWriter

    Metadata

    QuickBaseRecordWriter does not propagate metadata.

    Table 55.8. Error Fields for QuickBaseRecordWriter

    Field numberField nameData typeDescription
    optional[1]Specified in the error code output field.integer | longError code
    optional[1]Specified in the error message output field.stringError 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

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

     
    Error code output field 

    The name of the field the error code will be stored in, see Error Fields for QuickBaseRecordWriter.

     
    Error message output field 

    The 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.