QuickBaseQueryReader

Development > Component reference > Readers > QuickBaseQueryReader

Short description

Ports

Metadata

QuickBaseQueryReader attributes

Details

Short description

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

Data source	Input ports	Output ports	Each to all outputs	Different to different outputs	Transformation	Transf. req.	Java	CTL	Auto-propagated metadata
QuickBase	0	1-2	⨯	⨯	⨯	⨯	⨯	⨯	⨯

Data source

Input ports

Output ports

Each to all outputs

Different to different outputs

Transformation

Transf. req.

Java

CTL

Auto-propagated metadata

QuickBase

1-2

⨯

Ports

Port type	Number	Required	Description	Metadata
Output	0	✓	For correct data records.	any

Port type

Number

Required

Description

Metadata

Output

✓

For correct data records.

any

Metadata

QuickBaseQueryReader does not propagate metadata.

QuickBaseQueryReader has no metadata template.

Metadata cannot use Autofilling functions.

QuickBaseQueryReader attributes

Attribute Req Description Possible values

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 get from. 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`
Query		Determines which records are returned (all, by default) using the form {<field_id>.<operator>.'<matching_value>'}.	e.g. `{'6'.CT.'Birdie'}`
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. For more information, see Options.

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 get from. 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

Query

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

e.g. {'6'.CT.'Birdie'}

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. For more information, see Options.

Figure 342. Obtaining Table ID

Details

QuickBaseQueryReader gets records from a QuickBase online database. 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.

{{{ highlightedName }}}