Syndicate content
The Components of a Query

A query typically includes the following parameters:

October 13th, 2009 - 2:10 PM
How to Supply the Query Parameter

The query parameter is the main parameter in a query because it determines which records will come back. In contrast, the other parameters affect the look of the query results or further narrow the query results in some way.

There are two ways to provide the query string:

October 13th, 2009 - 2:10 PM
Constructing the Query String

When you construct a query you must build at least one query string. A query string is composed of a field ID (fid), comparison operator, and the value to be compared against (see the table below for a list of available operators). Each of these components of the query string are separated by a period, and the whole query string enclosed in curly braces, like this:

October 13th, 2009 - 2:10 PM
How to Use Tickets: Tickets vs. Username and Password

If a user is accessing a QuickBase application through a web browser, once the call to API_Authenticate has been made successfully, the ticket cookie will be used automatically: there is no need to explicitly supply the ticket value as returned in the XML.

October 13th, 2009 - 2:10 PM
User Access and Your Application

This chapter covers the APIs application-level features that govern access. The calls that provide these features can be grouped as follows:

October 13th, 2009 - 2:10 PM
How Compromised Security Situations are Handled

If some user uses someone elses application token, and there is a complaint about this being unauthorized, the offending user will have access rights removed and the application token will be revoked.

October 13th, 2009 - 2:10 PM
API Calls That Dont Use the Application Token

The following calls use a ticket only, no application token:

October 13th, 2009 - 2:10 PM
Access to QuickBase (Login)

Login to QuickBase is provided through the API_Authenticate call, which returns a ticket and a ticket cookie. Just like a regular QuickBase login through the UI, the ticket by itself does not convey access to any applications. The application owner needs to assign an access role to the user first. (In addition to the ticket, your app needs an app token.)

October 13th, 2009 - 2:10 PM
The Typical User Management Cycle

After creating your application, tables and fields, and before inviting users to your application, you need to figure out what your system of roles should look like: what tables or fields should be accessed by which role, and what degree of access. All of this is done within Intuit QuickBase directly. The online help can lead you through the process.

October 13th, 2009 - 2:10 PM
API Calls for Basic User Management

If the user is an existing QuickBase user:

October 13th, 2009 - 2:10 PM

© 2016 QuickBase, Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit