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"
}

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"
}

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"
}

Properties

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

Output Example

{
  "data" : [ 1 ]
}

What to do if your action is not listed here?

If this component doesn't have the action you need, you can use Custom Action to create your own. Custom Actions empower you to define HTTP requests tailored to your specific requirements, allowing for greater flexibility in integrating with external services or APIs.

To create a Custom Action, simply specify the desired HTTP method, path, and any necessary parameters. This way, you can extend the functionality of your component beyond the predefined actions, ensuring that you can meet all your integration needs effectively.

On this page