about_http_API

Syndicate content
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 - 1: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 - 1: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 - 1: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 - 1:10 PM
API Calls That Dont Use the Application Token

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

October 13th, 2009 - 1: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 - 1: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 - 1:10 PM
API Calls for Basic User Management

If the user is an existing QuickBase user:

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

© 1997-2014 Intuit Inc. All Rights Reserved.

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