tflanagan/quickbase

A lightweight, very flexible QuickBase API

php-quickbase

, _(*1)

A lightweight, very flexible QuickBase API, _(*2)

JavaScript (Node.js + Browser) Version, _(*3)

Install

$ composer require tflanagan/quickbase

Example

try {
    $qb = new \QuickBase\QuickBase(array(
        'realm' => 'www',
        'appToken' => '****',
        // 'userToken' => '****'
    ));

    // If using user tokens, you do not need to call API_Authenticate

    $qb->api('API_Authenticate', array(
        'username' => '****',
        'password' => '****'
    ));

    $response = $qb->api('API_DoQuery', array(
        'dbid' => '*****',
        'clist' => '3.12',
        'options' => 'num-5'
    ));

    foreach($response['table']['records'] as $record){
        $qb->api('API_EditRecord', array(
            'dbid' => '*****',
            'rid' => $record[3],
            'fields' => array(
                array( 'fid' => 12, 'value' => $record[12])
            )
        ));
    }

    $results = $qb->api(array(
        array(
            'action' => 'API_DoQuery',
            'options' => array(
                'dbid' => '*****',
                'clist' => '3.12',
                'options' => 'num-5'
            )
        ),
        array(
            'action' => 'API_DoQuery',
            'options' => array(
                'dbid' => '*****',
                'clist' => '3.12',
                'options' => 'num-5'
            )
        )
    ));

    var_dump($results[0]); // First DoQuery
    var_dump($results[1]); // Second DoQuery
}catch(\QuickBase\QuickBaseError $err){
    echo '('.$err->getCode().') '.$err->getMessage().'. '.$err->getDetails();
}

Class

class \QuickBase\QuickBase {

    public cURL multi $mch;
    public array $chs;

    private $defaults;

    final public api($action[, $options = array()]);
    final public api($actions = array());

    final public static genCH();

}

class \QuickBase\QuickBaseError extends \Exception {

    protected int $code;
    protected string $message;
    protected string $details;

    protected int $line;
    protected string $file;

    final public getCode(void);
    final public getMessage(void);
    final public getDetails(void);

    final public getLine(void);
    final public getFile(void);

}

class \QuickBase\QuickBaseQuery {

    public QuickBase $parent;
    public string $action;
    public array $settings;
    public array $options;
    public array $response;

    private int $nErrors;

    protected string $payload;

    final public actionRequest();
    final public actionResponse();
    final public addFlags();
    final public constructPayload();
    final public checkForAndHandleError();
    final public finalize();
    final public prepareCH();
    final public processCH();
    final public processOptions();

    final public static arr2Obj(&$arr[, $return = false]);
    final public static arr2Xml($arr, &$xml);
    final public static cleanXml2Arr(&$arr);
    final public static parseCURLHeaders(&$headers);
    final public static xml2Arr($xml, &$arr);

}

class \QuickBase\QuickBaseRequest {

    final public static API_[Authenticate, DoQuery, etc](&$query);

}

class \QuickBase\QuickBaseResponse {

    final public static API_[Authenticate, DoQuery, etc](&$query, &$results);

}

class \QuickBase\QuickBaseOption {

    final public static [clist, fields, etc]($val);

}

Error Handling

php-quickbase throws exceptions whenever an error is detected. You do not have to manually check for QuickBase errors, just wrap your code in try/catch's and you're good to go!, _(*4)

try {
    // QuickBase API Calls Here
}catch(\QuickBase\QuickBaseError $err){
    echo '('.$err->getCode().') '.$err->getMessage().'. '.$err->getDetails();

    /*
     * class \QuickBase\QuickBaseError extends \Exception {
     *
     *  protected int $code;
     *  protected string $message;
     *  protected string $details;
     *
     *  protected int $line;
     *  protected string $file;
     *
     *  final public getCode(void);
     *  final public getMessage(void);
     *  final public getDetails(void);
     *
     *  final public getLine(void);
     *  final public getFile(void);
     *
     * }
    */
}

License

Copyright 2015 Tristian Flanagan, _(*5)

Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at, _(*6)

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License., _(*7)