# Clone this repository
$ git clone https://github.com/retable-io/retablejs
# Go into the repository
$ cd retablejs
# Install dependencies
$ npm install
# Build the package
$ npm run build

For testing, from your command line:

# Go into the repository
$ cd retablejs
# Run the test script
$ npm run test

Installation

npm install retablejs

Client Usage

Authorization

Warning
Your API requests are authenticated using API keys. Any request that doesn't include an API key will return an error. You can generate an API Key from your User page at any time on Retable.io. This generated API Key is constant, when it is generated it never changes or is deleted. Though you can change its usable state on the same page. After obtaining your API Key (starts with RTBL-v1 prefix) you have to provide an apiKey header to every request. Otherwise, you will get an Unauthorized error.
```
// CommonJS Import
const Retable = require('retable');

// ES6 Import
// Using TypeScript? Pass `esModuleInterop` in tsconfig.json
import Retable from 'retable';

const client = new Retable({
    apiKey: "RTBLv1-xxxxxxxxxxxxxxxxxxx"
});
```

Error Handling

client.getWorkspace(workspace_id: string).then((p) => {
    // Do something
}).catch(err => {
    err.detail; // Error detail
    err.status; // Error status code
});

Function Detail

Workspace

Function	Description
`getWorkspace`	Get a specific Workspace and its Projects
`getAllWorkspaces`	Get user's all Workspaces
`createWorkspace`	Create a new Workspace with a default Project
`deleteWorkspace`	Delete a specific Workspace
`getWorkspaceProjects`	Get all Projects that belong to a specific Workspace

Project

Function	Description
`createProject`	Create a Project under the given Workspace with a default Retable
`getProject`	Get a specific Project with Retables
`deleteProject`	Delete a specific Project
`getProjectTables`	Get all Retables that belong to a specific Project

Table

Function	Description
`createTable`	Create a new Retable under a specific Project
`getTable`	Get information about a specific Retable
`deleteColumn`	Delete column from a specific Retable
`addColumn`	Create a new column on the specific Retable
`getRow`	Returns data of a specific Retable
`insertRow`	Insert row to a specific Retable
`updateRow`	Update row of a specific Retable
`deleteRow`	Delete row from a specific Retable

Get a Workspace

https://api.retable.io/v1/public/workspace/{workspace_id}

client.getWorkspace(workspace_id: string).then(res => {
    res.data // workspace data object
});

Get All Workspaces

https://api.retable.io/v1/public/workspace

client.getAllWorkspaces().then(res => {
  res.data // workspace data object
});

Create a Workspace

https://api.retable.io/v1/public/workspace

client.createWorkspace(
  {
    name: 'string',
    description: 'string'
  }).then(res => {
  res.data // workspace data object
});

Delete a Workspace

https://api.retable.io/v1/public/workspace/{workspace_id}

client.deleteWorkspace(workspace_id: string).then(res => {
  res.data // workspace data object
});

Get Workspace's Projects

https://api.retable.io/v1/public/workspace/{workspace_id}/project

client.getWorkspaceProjects(workspace_id: string).then(res => {
 res.data // workspace data object
});

Create a Project

https://api.retable.io/v1/public/workspace/{workspace_id}/project

client.createProject(workspace_id: string,  {
    name: 'string',
    description: 'string',
    color: 'string';
  }).then(res => {
  res.data // project data object
});

Get a Project

https://api.retable.io/v1/public/project/{project_id}

client.getProject(project_id: string).then(res => {
  res.data // project data object
});

Delete a Project

https://api.retable.io/v1/project/{project_id}

client.deleteProject(project_id: string).then(res => {
  res.data //project data object
});

Get Project's Tables

https://api.retable.io/v1/public/project/{project_id}/retable

client.getProjectTables(project_id: string).then(res => {
  res.data // project data object
});

Create a Table

https://api.retable.io/v1/public/project/{project_id}/retable

client.createTable(project_id: string).then(res => {
   res.data // retable data object
});

Get a Table

https://api.retable.io/v1/public/retable/{retable_id}

client.getTable(retable_id: string).then(res => {
  res.data // retable data object
});

Delete Column

https://api.retable.io/v1/public/retable/{retable_id}/column

client.deleteColumn(retable_id: string,{
    column_ids: [
        "<column_id>",
        "<column_id>"
    ]
}).then(res => {
  res.data // column data array
});

Add Column

https://api.retable.io/v1/public/retable/{retable_id}/column

client.addColumn(retable_id: string,{
    columns: [
        {
            title: "hello",
            type: "text"
        }
    ]
}).then(res => {
  res.data // column data array
});

Get Row

https://api.retable.io/v1/public/retable/{retable_id}/data

client.getRow(retable_id: string).then(res => {
   res.data // row data object
});

Insert Row

https://api.retable.io/v1/public/retable/{retable_id}/data

client.insertRow(retable_id: string,{
    data: [
        {
            columns: [
                {
                    column_id: "Bvt1FQhTyAPjmDx",
                    cell_value: "Isengard"
                }
            ]
        },
        {
            columns: [
                { 
                    column_id: "Bvt1FQhTyAPjmDx",
                    cell_value: "Rivendell"
                }
            ]
        }
    ]
}).then(res => {
  res.data // row data object
});

Update Row

https://api.retable.io/v1/public/retable/{retable_id}/data

client.updateRow(retable_id: string,{
    rows: [
        {
            row_id: 2,
            columns: [
                {
                    column_id: "Bvt1FtQhTyAPjmDx",
                    update_cell_value: "Mordor"
                }
            ]
        },
    ]
}).then(res => {
  res.data // row data array
});

Delete Row

https://api.retable.io/v1/public/retable/{retable_id}/data

client.deleteRow(retable_id: string,{
    row_ids: [
        1
    ]
}).then(res => {
  res.data // row data object
});