Retable

Retable is a online database and spreadsheet platform designed for teams and individuals who want to organize, manage, and collaborate on structured data.

Categories: Productivity and Collaboration

Type: retable/v1

Connections

Version: 1

API Key

Properties

Name	Label	Type	Description	Required
key	Key	STRING		true
value	API key	STRING		true

Actions

Delete Row

Name: deleteRow

Delete a row.

Properties

Name	Label	Type	Description	Required
workspace_id	Workspace ID	STRING	`ID of the workspace.`	true
project_id	Project ID	STRING Depends On workspace_id	`ID of the project.`	true
retable_id	Retable ID	STRING Depends On project_id	`ID of the retable.`	true
row_ids	Rows IDs	ARRAY Items [INTEGER]	`ID of the rows to delete.`	true

Example JSON Structure

{
  "label" : "Delete Row",
  "name" : "deleteRow",
  "parameters" : {
    "workspace_id" : "",
    "project_id" : "",
    "retable_id" : "",
    "row_ids" : [ 1 ]
  },
  "type" : "retable/v1/deleteRow"
}

Output

Type: OBJECT

Properties

Name	Type	Description
data	OBJECT Properties {INTEGER(deleted_row_count)}

Output Example

{
  "data" : {
    "deleted_row_count" : 1
  }
}

Insert Row

Name: insertRow

Insert a row.

Properties

Name	Label	Type	Description	Required
workspace_id	Workspace ID	STRING	`ID of the workspace.`	true
project_id	Project ID	STRING Depends On workspace_id	`ID of the project.`	true
retable_id	Retable ID	STRING Depends On project_id	`ID of the retable.`	true
row_ids		DYNAMIC_PROPERTIES Depends On project_id		false

Example JSON Structure

{
  "label" : "Insert Row",
  "name" : "insertRow",
  "parameters" : {
    "workspace_id" : "",
    "project_id" : "",
    "retable_id" : "",
    "row_ids" : { }
  },
  "type" : "retable/v1/insertRow"
}

Output

Type: OBJECT

Properties

Name	Type	Description
data	OBJECT Properties {[INTEGER($row_id), STRING($created_at), STRING($updated_at), {STRING(id), STRING(name), STRING(surname), STRING(email)}($created_by), {STRING(id), STRING(name), STRING(surname), STRING(email)}($updated_by), [STRING($column_id), STRING($title), STRING($cell_value)]($columns)](rows)}

Output Example

{
  "data" : {
    "rows" : [ 1, "", "", {
      "id" : "",
      "name" : "",
      "surname" : "",
      "email" : ""
    }, {
      "id" : "",
      "name" : "",
      "surname" : "",
      "email" : ""
    }, [ "", "", "" ] ]
  }
}

Update Row

Name: updateRow

Update a row.

Properties

Name	Label	Type	Description	Required
workspace_id	Workspace ID	STRING	`ID of the workspace.`	true
project_id	Project ID	STRING Depends On workspace_id	`ID of the project.`	true
retable_id	Retable ID	STRING Depends On project_id	`ID of the retable.`	true
row_id	Row ID	INTEGER	`ID of the row to update.`	true
row_ids		DYNAMIC_PROPERTIES Depends On project_id		false

Example JSON Structure

{
  "label" : "Update Row",
  "name" : "updateRow",
  "parameters" : {
    "workspace_id" : "",
    "project_id" : "",
    "retable_id" : "",
    "row_id" : 1,
    "row_ids" : { }
  },
  "type" : "retable/v1/updateRow"
}

Output

Type: OBJECT

Properties

Name	Type	Description
data	ARRAY Items [INTEGER]	Row IDs.

Output Example

{
  "data" : [ 1 ]
}

On this page