http_api

Syndicate content
Special Matching Values in a Query String

Certain field types use special values with a given comparison operator. For example, what if you wanted to query on a checkbox? How would you specify only those records with the checkbox checked?(Answer: {'fid'.EX.'0'} for unchecked, {'fid'.EX.'1'} for checked: you need to replace fid with your checkbox field id.)

October 13th, 2009 - 2:10 PM
Referencing a Saved Query

October 13th, 2009 - 2:10 PM
Column List (clist) Parameter

The clist specifies which columns will be included in each returned record and how they are ordered in the returned record aggregate. Heres what a clist looks like:

<clist>4.7.9.11</clist>

or in URL-ese:

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
Moving Users in and out of Roles

You can use API_UserRoles to get all the users that are in roles for your application, along with all of the roles for each user.

October 13th, 2009 - 2:10 PM
Building and Using Queries

API_GenResultsTable: both of which are covered in the language reference section.

Both API_DoQuery and API_GenResultsTable make use of the same query mechanism to return data. They differ mainly in the overall format of the return:

October 13th, 2009 - 2:10 PM
How QuickBase Views and Reports Relate to Queries

In the QuickBase UI, retrieved records are displayed in rows in a table, with the field data layed out in separate columns. This layout of record data is called a view.

October 13th, 2009 - 2:10 PM
Is There a Default View or Must I Construct a View?

Is There a Default View or Must I Construct a View?

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