Quickbase

Quickbase is a no-code database and application development platform that allows businesses to build applications specific to their use case. It allows different teams in an organization to work with a common data repository to manage different operations, and set up workflows for automating different processes involved in running the business. Additionally, it offers hundreds of ready-to-use pre-built business applications.

You can replicate the data from your Quickbase account to a Destination database or data warehouse using Hevo Pipelines. Hevo ingests the data objects in Full Load mode. Refer to section, Data Model for the list of supported objects.

Hevo uses the Quickbase JSON RESTful API to replicate the data present in your Quickbase account to the desired Destination database or data warehouse for scalable analysis.


Prerequisites

  • An active Quickbase account from which data is to be ingested.

  • A Quickbase app ID to authenticate Hevo on your Quickbase account.

  • You must be logged in as an Admin user or have the admin privileges for the app that you are connecting to Hevo.


Obtaining the App ID and User Token

The App ID is the unique ID of the app listed in the Quickbase dashboard whose data you want to replicate to the Destination. You need to create a user token for the app to allow Hevo to access the data.

Note: You need to be an Admin to create a user token in Quickbase.

Obtaining the app ID

Perform the following steps to obtain you App ID:

  1. Log in to your Quickbase account.

  2. In the My Apps tab, you can find the apps created in your account.

  3. Click on the app you want to fetch data from and copy the app ID from the URL. For example, if your site URL is https://hevodata.quickbase.com/db/abcd99efg, then the app ID is abcd99efg.

    Hevo uses this App ID to configure Quickbase as a Source.

    Select the app

Obtaining the user token

Perform the following steps to obtain your user token:

  1. Log in to your QuickbaseMy account.

  2. Click on the username at the top right corner in the page, and click My preferences.

    My preferences

  3. In the My Preferences page, under My User Information, click on the Manage User Tokens link.

    Click Manage user tokens

  4. In the My User Tokens page, do one of the following:

    • Use an existing token:

    • Create a new user token:

      1. Click + New user token.

        Create new token

      2. In the Create a new token page, specify the following:

        Configure new token

        • Name: A unique name for the user token.

        • Description (Optional) : A few words to explain the purpose of the user token.

        • Assign token to apps: Select the app(s) you want to assign this token to. You can select upto 20 apps for a token.

      3. Click Save.
        You have successfully created a token. Copy the token and use it in Hevo to configure Quickbase as a Source.


Configuring Quickbase as a Source

Perform the following steps to configure Quickbase as the Source in your Pipeline:

  1. Click PIPELINES in the Asset Palette.

  2. Click + CREATE in the Pipelines List View.

  3. In the Select Source Type page, select Quickbase.

  4. In the Configure your Quickbase Source page, specify the following:

    Configure Quickbase as a Source

    • Pipeline Name: A unique name for the Pipeline, not exceeding 255 characters.

    • API Token: The API token that you created in your Quickbase account.

    • App ID: The unique ID of your Quickbase app present in your Quickbase app URL. For example, if your site URL is https://hevodata.quickbase.com/db/abcd99efg, then the app ID is abcd99efg.

    • Subdomain: The subdomain of your Quickbase site URL. For example, if your site URL is https://hevodata.quickbase.com/, then the subdomain is hevodata.

  5. Click TEST & CONTINUE.

  6. Proceed to configuring the data ingestion and setting up the Destination.


Data Replication

Default Pipeline Frequency Minimum Pipeline Frequency Maximum Pipeline Frequency Custom Frequency Range (Hrs)
1 hr 1 hr 24 hrs 1-24

Note: You must set the custom frequency in hours as an integer value. For example, 1, 2, 3 but not 1.5 or 1.75.

Hevo fetches all the objects in Full Load mode in each run of the Pipeline.


Schema and Primary Keys

Hevo uses the following schema to upload the records in the Destination database:


Data Model

The following is the list of tables (objects) that are created at the Destination when you run the Pipeline:

Object Mode Description
Tables Full Load Contains the details of all the tables in a specific application, created in your Quickbase account.
Relationships Full Load Contains the details of the relationships defined for common fields between the tables in the Quickbase application.
Reports Full Load Contains the details of all the reports associated with a table in your application. These reports are created by filtering and sorting records in a table according to your requirements.
Fields Full Load Contains the details of all the elements that make up a record in a table such as their ID, name, and the field type.
Fields Usage Full Load Contains the details of the usage statistics for all the fields within a table such as the number of relationships and reports where a field is referenced.

Source Considerations

  • Quickbase imposes a limit of 1 API call per second.

Limitations

  • Hevo currently does not support deletes. Therefore, any data deleted in the Source may continue to exist in the Destination.

Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Oct-25-2022 2.00 New document.
Last updated on 23 Nov 2022

Tell us what went wrong