Quickbase

Quickbase ETL connector for data replication

Snapshot

Features	Details
Release Status	Released
Source API Version	2.0
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	Quickbase Api token Quickbase App id Quickbase Realm Host name
Replication Type	Full Replication Key based replication
Replication Key	NA lastRunDate
Suggested Replication Frequency	24 hrs

Tables/APIs Supported
Reports	Relationships
Fields	Tables
UsageFields	App

Integrate Quickbase with Daton

1. Signin to Daton

2. Select Quickbase from Integrations page

3. Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later

4. Provide your Quickbase api token, Quickbase app id and Quickbase realm Host name to authorize Daton to periodically extract data Quickbase.

5. Post successful authentication you will be prompted to choose from the list of available tables

6. Then select all required fields for each table

7. Submit the integration

Workflow

1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

2. Users would be able to edit/pause/re-activate/delete integration anytime

3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

Quickbase Data

Reports

Purpose: Get the schema (properties) of all reports for a table. If the user running the API is an application administrator, the API will also return all personal reports with owner's user id.

Source-Api documentation: https://developer.quickbase.com/operation/getTableReports

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name	Target Datatype
id	STRING
name	STRING
type	STRING
description	STRING
query	RECORD
properties	RECORD

Relationships

Purpose: Get a list of all relationships, and their definitions, for a specific table. Details are provided for both the parent and child sides of relationships within a given application. Limited details are returned for cross-application relationships.

Source API Documentation https://developer.quickbase.com/operation/getRelationships

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
metadata	RECORD
relationships	RECORD

Fields

Purpose: Gets the properties for all fields in a specific table. The properties for each field are the same as in Get field.

Source API Documentation https://developer.quickbase.com/operation/getFields

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
id	STRING
label	STRING
mode	STRING
fieldsType	STRING
noWrap	BOOLEAN
bold	BOOLEAN
required	BOOLEAN
appearsByDefault	BOOLEAN
findEnabled	BOOLEAN
unique	BOOLEAN
doesDataCopy	BOOLEAN
fieldHelp	BOOLEAN
audited	BOOLEAN
properties	RECORD

Tables

Purpose: Gets a list of all the tables that exist in a specific application. The properties for each table are the same as what is returned in Get table.

Source API Documentation https://developer.quickbase.com/operation/getAppTables

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
id	STRING
name	STRING
description	STRING
alias	STRING
nextFieldId	NUMERIC
defaultSortFieldId	NUMERIC
nextRecordId	NUMERIC
keyFieldID	STRING
singleRecordName	STRING
pluralRecordNmame	STRING
defautSortOrder	STRING
created	TIMESTAMP
updated	TIMESTAMP
sizeLimit	STRING
spaceRemaining	STRING
spaceUsed	STRING

UsageFields

Purpose: Get all the field usage statistics for a table. This is a summary of the information that can be found in the usage table of field properties.

Source API Documentation https://developer.quickbase.com/operation/getFieldsUsage

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
field	RECORD
usage	RECORD

App

Purpose: Returns the main properties of an application, including application variables.

Source API Documentation https://developer.quickbase.com/operation/getApp

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
created	TIMESTAMP
dateFormat	STRING
description	STRING
hasEveryoneOnTheInternet	BOOLEAN
id	STRING
name	STRING
timeZone	STRING
updated	TIMESTAMP