apitable-sdks/apitable.php at develop · apitable/apitable-sdks

apitable(apitable.com) The PHP SDK, giving you the ability to extend your datasheet with ease.

Visit the workbench of ApiTable, click on the personal avatar in the lower left corner, and enter [My Setting > Developer]. click generate token (binding email required for first use).

<?php
require_once './vendor/autoload.php';
use ApiTable\ApiTable;

echo '<pre>';

ApiTable::auth('your api token');

$all = ApiTable::datasheet('your dstId')->record()->all([
    "fieldKey" => 'id'
]);
var_dump(json_encode($all->getData()->getRecords()));

$page = ApiTable::datasheet('your dstId')->get(['pageNum' => 2, 'pageSize' => 2]);
var_dump(json_encode($page->getData()->getRecords()));

$attach = ApiTable::datasheet('your dstId')->upload(__DIR__.'/image.png');
var_dump($attach);

$insertArr = [
    [
        'fields' => ['ID' => 88],
    ],
    [
        'fields' => ['ID' => 99],
    ]
];
$insert = ApiTable::datasheet('your dstId')->record()->add($insertArr, 'name');
var_dump('insert message ' . $insert->getMessage());

$insertRecords = $insert->getData()->getRecords();
$updateArr = [
    [
        'recordId' => $insertRecords[0]['recordId'],
        'fields' => ['ID' => 100],
    ],
    [
        'recordId' => $insertRecords[1]['recordId'],
        'fields' => ['ID' => 101],
    ]
];
$update = ApiTable::datasheet('your dstId')->record()->update($updateArr, 'name');
var_dump('update message ' . $update->getMessage());

$delete = ApiTable::datasheet('your dstId')->record()->del([$insertRecords[0]['recordId'], $insertRecords[1]['recordId'],]);
var_dump('delete message ' . $delete->getMessage());
echo '</pre>';