Skip to content

SeaTable\Client\ActivitiesLogsApi

All URIs are relative to https://cloud.seatable.io, except if the operation defines another base path.

Method HTTP request Description
getBaseActivityLog() GET /dtable-server/api/v1/dtables/{base_uuid}/operations/ Get Base Activity Log
listDeleteOperations() GET /api/v2.1/dtables/{base_uuid}/delete-operation-logs/ List Delete Operations
listDeletedRows() GET /dtable-server/api/v1/dtables/{base_uuid}/deleted-rows/ List Deleted Rows
listRowActivities() GET /dtable-server/api/v1/dtables/{base_uuid}/activities/ List Row Activities

getBaseActivityLog()

getBaseActivityLog($base_uuid, $page): object

Get Base Activity Log

Get the activities log in a base. With the base's base_uuid.

Example

<?php
require_once(__DIR__ . '/vendor/autoload.php');

// Configure Bearer authorization: BaseTokenAuth (use the right token for your request)
$config = SeaTable\Client\Configuration::getDefaultConfiguration()->setAccessToken('YOUR_TOKEN');

$apiInstance = new SeaTable\Client\Base\ActivitiesLogsApi(
    new GuzzleHttp\Client(),
    $config
);
$base_uuid = 5c264e76-0e5a-448a-9f34-580b551364ca; // string | The unique identifier of a base. Sometimes also called dtable_uuid.
$page = 1; // int | The page number you want to start showing the entries. If no value is provided, 1 will be used.

try {
    $result = $apiInstance->getBaseActivityLog($base_uuid, $page);
    print_r($result);
} catch (Exception $e) {
    echo 'Exception when calling ActivitiesLogsApi->getBaseActivityLog: ', $e->getMessage(), PHP_EOL;
}

Parameters

Name Type Description Notes
base_uuid string The unique identifier of a base. Sometimes also called dtable_uuid.
page int The page number you want to start showing the entries. If no value is provided, 1 will be used. [optional]

Return type

object

Authorization

BaseTokenAuth

listDeleteOperations()

listDeleteOperations($op_type, $base_uuid, $page, $per_page)

List Delete Operations

Deleted rows, tables and columns are saved in SeaTable for 7 days. You can list these in the operation log with this request. To restore them, you'll need to log into the web UI. For op_type notice: delete_row returns the single operations which have deleted 1 row each time. delete_rows returns the operations in which multiple rows were deleted. delete_column returns the column that was deleted by each operation. delete_table returns the table that was deleted by each operation.

Example

<?php
require_once(__DIR__ . '/vendor/autoload.php');

// Configure Bearer authorization: BaseTokenAuth (use the right token for your request)
$config = SeaTable\Client\Configuration::getDefaultConfiguration()->setAccessToken('YOUR_TOKEN');

$apiInstance = new SeaTable\Client\Base\ActivitiesLogsApi(
    new GuzzleHttp\Client(),
    $config
);
$op_type = delete_row; // string | Type of delete operation that should be listed. Optional. Choose from `delete_row`, `delete_rows`, `delete_table`, and `delete_column`.
$base_uuid = 5c264e76-0e5a-448a-9f34-580b551364ca; // string | The unique identifier of a base. Sometimes also called dtable_uuid.
$page = 1; // int | The page number you want to start showing the entries. If no value is provided, 1 will be used.
$per_page = 25; // int | The number of results that should be returned. If no value is provided, 25 results will be returned.

try {
    $apiInstance->listDeleteOperations($op_type, $base_uuid, $page, $per_page);
} catch (Exception $e) {
    echo 'Exception when calling ActivitiesLogsApi->listDeleteOperations: ', $e->getMessage(), PHP_EOL;
}

Parameters

Name Type Description Notes
op_type string Type of delete operation that should be listed. Optional. Choose from `delete_row`, `delete_rows`, `delete_table`, and `delete_column`.
base_uuid string The unique identifier of a base. Sometimes also called dtable_uuid.
page int The page number you want to start showing the entries. If no value is provided, 1 will be used. [optional]
per_page int The number of results that should be returned. If no value is provided, 25 results will be returned. [optional]

Return type

void (empty response body)

Authorization

BaseTokenAuth

listDeletedRows()

listDeletedRows($base_uuid): object

List Deleted Rows

List all the deleted rows in the last 7 days. If you are looking for rows deleted before that, you can view a snapshot of this base.

Example

<?php
require_once(__DIR__ . '/vendor/autoload.php');

// Configure Bearer authorization: BaseTokenAuth (use the right token for your request)
$config = SeaTable\Client\Configuration::getDefaultConfiguration()->setAccessToken('YOUR_TOKEN');

$apiInstance = new SeaTable\Client\Base\ActivitiesLogsApi(
    new GuzzleHttp\Client(),
    $config
);
$base_uuid = 5c264e76-0e5a-448a-9f34-580b551364ca; // string | The unique identifier of a base. Sometimes also called dtable_uuid.

try {
    $result = $apiInstance->listDeletedRows($base_uuid);
    print_r($result);
} catch (Exception $e) {
    echo 'Exception when calling ActivitiesLogsApi->listDeletedRows: ', $e->getMessage(), PHP_EOL;
}

Parameters

Name Type Description Notes
base_uuid string The unique identifier of a base. Sometimes also called dtable_uuid.

Return type

object

Authorization

BaseTokenAuth

listRowActivities()

listRowActivities($row_id, $base_uuid, $page, $per_page): object

List Row Activities

List all the activities done to a certain row with the row's row_id.

Example

<?php
require_once(__DIR__ . '/vendor/autoload.php');

// Configure Bearer authorization: BaseTokenAuth (use the right token for your request)
$config = SeaTable\Client\Configuration::getDefaultConfiguration()->setAccessToken('YOUR_TOKEN');

$apiInstance = new SeaTable\Client\Base\ActivitiesLogsApi(
    new GuzzleHttp\Client(),
    $config
);
$row_id = YMIviMeERQCUiQhPPqo6Gw; // string | Unique id of a row.
$base_uuid = 5c264e76-0e5a-448a-9f34-580b551364ca; // string | The unique identifier of a base. Sometimes also called dtable_uuid.
$page = 1; // int | The page number you want to start showing the entries. If no value is provided, 1 will be used.
$per_page = 25; // int | The number of results that should be returned. If no value is provided, 25 results will be returned.

try {
    $result = $apiInstance->listRowActivities($row_id, $base_uuid, $page, $per_page);
    print_r($result);
} catch (Exception $e) {
    echo 'Exception when calling ActivitiesLogsApi->listRowActivities: ', $e->getMessage(), PHP_EOL;
}

Parameters

Name Type Description Notes
row_id string Unique id of a row.
base_uuid string The unique identifier of a base. Sometimes also called dtable_uuid.
page int The page number you want to start showing the entries. If no value is provided, 1 will be used. [optional]
per_page int The number of results that should be returned. If no value is provided, 25 results will be returned. [optional]

Return type

object

Authorization

BaseTokenAuth