README

apitable(apitable.com) PHP SDK，让您轻松扩展数据表功能。

环境

php 8.0+

安装

composer require dongasai/apitable_phpsdk

获取api_token

访问ApiTable的工作台，点击左下角的个人头像，进入[我的设置 > 开发者]。点击生成token（首次使用需要绑定邮箱）。

使用

<?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>';