Version

    QuickBaseImportCSV

    QuickBaseWriter 64x64

    Short Description

    Ports

    Metadata

    QuickBaseImportCSV Attributes

    Details

    See also

    Short Description

    QuickBaseImportCSV adds and updates a QuickBase online database table records.

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

    QuickBaseImportCSV

    QuickBase

    1

    0-2

    Ports

    Port type Number Required Description Metadata

    Input

    0

    For input data records.

    any

    Output

    0

    For accepted data records.

    integer or long field for the table Record ID# field values of the imported records

    Output

    1

    for rejected data records

    Input metadata enriched by up to three Error Fields for QuickBaseImportCSV

    Metadata

    QuickBaseImportCSV does not propagate metadata.

    Table 54. Error Fields for QuickBaseImportCSV
    Field number Field name Data type Description

    optional[1]

    specified in the Error code output field

    integer | long

    error code

    optional[1]

    Specified in the Error message output field.

    string

    error message

    optional[1]

    specified in the Batch number output field

    integer | long

    index (starting from 1) of the failed batch

    1

    The error fields must be placed behind the input fields.

    QuickBaseImportCSV Attributes

    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 written into. 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

    Batch size

    The maximum number of records in one batch

    100 (default) | 1-N

    Clist

    A period-delimited list of table field_ids to which the input data columns map. The order is preserved. Thus, enter a 0 for columns not to be imported. If not specified, the database tries to add unique records. It must be set if editing records. The input data must include a column that contains the record ID for each record that you are updating.

    Error code output field

    The name of the error metadata field for storing the error code, see Error Fields for QuickBaseImportCSV.

    Error message output field

    The name of the error metadata field for storing the error message, see Error Fields for QuickBaseImportCSV.

    Batch number output field

    The name of the error metadata field for storing the index of the corrupted batch, see Error Fields for QuickBaseImportCSV.

    tableID
    Figure 373. Obtaining Table ID

    Details

    QuickBaseImportCSV receives data records through the input port and writes them into a QuickBase online database. Generates record IDs for successfully written records and sends them out through the first optional output port if connected. The first field on this output port must be of a string data type. Into this field, generated record IDs will be written. Information about rejected data records can be sent out through the optional second port if connected.

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