QuickBaseQueryReader

Not available in Community Designer

Short Description
Ports
Metadata
QuickBaseQueryReader Attributes
Details
See also

Short Description

QuickBaseQueryReader gets records fulfilling given conditions from a QuickBase online database table.

Component Data source Input ports Output ports Each to all outputs Different to different outputs Transformation Transf. req. Java CTL Auto-propagated metadata
QuickBaseQueryReaderQuickBase01-2
no
no
no
no
no
no
no

Ports

Port typeNumberRequiredDescriptionMetadata
Output0
yes
for correct data recordsany

Metadata

QuickBaseQueryReader does not propagate metadata.

QuickBaseQueryReader has no metadata template.

Metadata cannot use Autofilling Functions.

QuickBaseQueryReader Attributes

AttributeReqDescriptionPossible values
Basic
QuickBase connection
yes

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

 
Table ID
yes

The ID of the table in the QuickBase application data records are to be get from (see the application_stats for getting the table ID)

 
Query 

Determines which records are returned (all, by default) using the form {<field_id>.<operator>.'<matching_value>'}

 
CList 

The column list specifies which columns will be included in each returned record and how they are ordered in the returned record aggregate. Use field_ids separated by a period.

 
SList 

The sort list determines the order in which the returned records are displayed. Use field_id separated by a period.

 
Options 

Options used for data records that are read. See Options for more information.

 

Details

QuickBaseQueryReader gets records from a QuickBase online database (http://quickbase.intuit.com). You can use the component attributes to define which columns will be returned, how many records will be returned and how they will be sorted, and whether the QuickBase should return structured data. Records that meet the requirements are sent out through the connected output port.

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

Options

Options attributes can be as follows:

  • skp-n

    Specifies n records from the beginning that should be skipped.

  • num-n

    Specifies n records that should be read.

  • sortorder-A

    Specifies the order of sorting as ascending.

  • sortorder-D

    Specifies the order of sorting as descending.

  • onlynew

    This parameter cannot be used by an anonymous user. The component reads only new records. The results can be different for different users.

See also

QuickBaseRecordReader
Common Properties of Components
Specific Attribute Types
Common Properties of Readers
Readers Comparison