Skip to main content
POST
/
public
/
v1
/
board
/
{boardId}
/
table
/
{tableId}
/
row
/
authenticate
Node.js SDK
import { CoperaAI } from '@copera.ai/sdk';

const copera = CoperaAI({
  apiKey: 'your-api-key-here'
});

const row = await copera.board.authenticateTableRow({
  boardId: 'board_id_here',
  tableId: 'table_id_here',
  identifierColumnId: 'email_column_id',
  identifierColumnValue: '[email protected]',
  passwordColumnId: 'password_column_id',
  passwordColumnValue: 'user_password'
});
console.log(row);
{
  "_id": "<string>",
  "rowId": 123,
  "owner": "<string>",
  "table": "<string>",
  "board": "<string>",
  "createdAt": "<string>",
  "updatedAt": "<string>",
  "columns": [
    {
      "columnId": "<string>",
      "value": "<unknown>",
      "linkValue": "<unknown>",
      "lookupValue": [
        {
          "foreignRowId": "<string>",
          "foreignRowValue": "<unknown>"
        }
      ]
    }
  ]
}

​
Overview

Authenticate a table row by matching an identifier column value and verifying a password column. This enables building custom authentication systems using board tables.

​
Prerequisites

  • Valid API key with board read permissions
  • Board ID and Table ID
  • A column to use as identifier (e.g., email, username)
  • A password column

​
Request Body

  • identifierColumnId: The ID of the column to search by (e.g., email, username column)
  • identifierColumnValue: The value to match in that column
  • passwordColumnId: The ID of the password column
  • passwordColumnValue: The plaintext password to verify

​
Response

Returns the authenticated row if credentials are valid. Password columns are masked with ********.

​
Errors

  • 400 Bad Request: No row found with the provided identifier
  • 401 Unauthorized: Invalid password

Authorizations

​
Authorization
string
header
required

Bearer token

Path Parameters

​
boardId
string
required

ObjectId

Required string length: 24
​
tableId
string
required

ObjectId

Required string length: 24

Body

application/json
​
identifierColumnId
string
required

ObjectId

Required string length: 24
​
identifierColumnValue
string
required
​
passwordColumnId
string
required

ObjectId

Required string length: 24
​
passwordColumnValue
string
required

Response

Default Response

​
_id
string
required
​
rowId
number
required
​
owner
string
required
​
table
string
required
​
board
string
required
​
createdAt
string
required
​
updatedAt
string
required
​
columns
object[]
required