QuickBaseImportCSV
Not available in Community Designer
| Short Description |
| Ports |
| Metadata |
| QuickBaseImportCSV Attributes |
| Details |
| See also |
Short Description
QuickBaseImportCSV adds and updates 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 |  | | | | |
Icon
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.6. 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 | | 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 written into (see the application_stats for getting the table ID) | |
| 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 | name of the error metadata field for storing the error code, see Error Fields for QuickBaseImportCSV | ||
| Error message output field | name of the error metadata field for storing the error message, see Error Fields for QuickBaseImportCSV | ||
| Batch number output field | name of the error metadata field for storing the index of the corrupted batch, see Error Fields for QuickBaseImportCSV | ||
Details
QuickBaseImportCSV receives data records through the input port and writes them into QuickBase online database (http://quickbase.intuit.com). 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 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).