记录

新增记录。

import { Base } from 'seatable-api';

const config = {
  server: 'https://cloud.seatable.cn',
  APIToken: '123456'
};

const base = new Base(config);
await base.auth();

const records = [
  {
    k: 'book',
    v: '[{}]'
  },
  {
    k: 'music',
    v: '[{}]'
  },
  {
    k: 'movie',
    v: '[{}]'
  }
];
await base.batchAppendRows('kv', records);

查询记录。

import { Base } from 'seatable-api';

const config = {
  server: 'https://cloud.seatable.cn',
  APIToken: '123456'
};

const base = new Base(config);
await base.auth();

const records = await base.listRows('kv');
console.log(records);

查询记录，使用 SQL 。

import { Base } from 'seatable-api';

const config = {
  server: 'https://cloud.seatable.cn',
  APIToken: '123456'
};

const base = new Base(config);
await base.auth();

const records = await base.query('SELECT _id, k, v FROM kv');
console.log(records);

清空表，使用 SQL 。

import { Base } from 'seatable-api';

const config = {
  server: 'https://cloud.seatable.cn',
  APIToken: '123456'
};

const base = new Base(config);
await base.auth();

try {
  await base.query('DELETE FROM kv');
} catch {
  console.log('表已清空。');
}