php-quickbase
php-quickbase copied to clipboard
A lightweight, very flexible QuickBase API for PHP
php-quickbase
A lightweight, very flexible QuickBase API
JavaScript (Node.js + Browser) Version
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!
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
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
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.