http_api

Syndicate content
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
Handling Special Characters for a Query Field Value

Handling Special Characters for a Query Field Value

What happens if you are querying for a value that has double quotes, for example, Joe B. Briggs? You need to double the quotes on each side, like this:

Joe B. Briggs

October 13th, 2009 - 2:10 PM
Querying on Dates and Times

Querying on Dates and Times

Notice that you can query on dates (yyyy-MM-dd) or on times in milleseconds, but you cannot query on date-time values in the standard format yyyy-MM-dd hh:mm:ss.

October 13th, 2009 - 2:10 PM
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
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

© 1997-2014 Intuit Inc. All Rights Reserved.

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