302 Found

Found

The document has moved here.

http_api

Syndicate content
How to Return ALL of the columns

Specify the value a in the clist param to get all the columns returned.

October 13th, 2009 - 2:10 PM
Sort List (slist) Parameter

Sort List (slist) Parameter

The slist determines the order in which the returned records are displayed. Heres what an slist looks like:

<slist>7</slist>

October 13th, 2009 - 2:10 PM
Options Parameter

You use the options parameter to further control the return of records. You can use any or all of the options, separating the options with a period. Here are the available options:

October 13th, 2009 - 2:10 PM
About the Sort Order Option

About the Sort Order Option

You can apply a different sort order to different returned columns in the clist by supplying several period delimited sort order params:

<options>sortorder-A.sortorder-D.sortorder-D.sortorder-A</options>

October 13th, 2009 - 2:10 PM
How Do I Construct a View?

How Do I Construct a View?

Detailed instructions for constructing views, reports, and queries are provided in the QuickBase online help.

October 13th, 2009 - 2:10 PM
How are Reports Related to Views?

How are Reports Related to Views?

In the QuickBase UI, you use a report to specify filter criteria for which records are to be retrieved. Each report has its own view. In short, the report and view work together to get and show only the specified records and specified columns (fields) within those records.

October 13th, 2009 - 2:10 PM
How is an API Query Related to Reports and Views?

How is an API Query Related to Reports and Views?

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

Found

The document has moved here.