Wexa AI
  1. Tables
Wexa AI
  • Wexa AI
  • Getting Started with Wexa AI
  • Use Cases and Workflows
  • API Reference
  • Tutorials
  • Troubleshooting Guide
  • API Endpoints
    • Project
      • create project
      • Get all projects
      • Get project
      • update project
      • Delete project
    • Agentflows
      • create agentflow
      • get agentflows
      • Get agentflow by projectId and UserId
      • get agentflow by id
      • Add skilled agent to agentflow
      • Update skilled agent
    • Connectors
      • get connectors by projectid
      • get connector by Id
      • Delete a connector
      • connector update status
      • get all available trigger actions
    • Skills
      • create skill
      • get skills
      • get skills by category'
      • get skills by id
      • skills by name
    • Executeflow
      • create executeflow
      • get executions
      • execute agentflow
      • pause executeflow
      • resume execution
      • cancel executeflow
      • get execution by execution id
      • get execution details for monitoring
    • Customer
      • get customer
      • Get credit history
    • Actions
      • create action
      • get action
    • Files
      • upload files
      • get files by fileid
      • get connector by fileid
      • get files by connector_id
    • Inbox
      • get inbox
    • Tags
      • tags
    • Tasks
      • get tasks
      • get task by id
      • Pause running task
      • resume task
      • Stop task
    • Tables
      • create table
        POST
      • create database
        POST
      • get tables
        GET
      • get records list
        GET
      • get table names
        GET
      • delete record
        DELETE
      • delete a column
        DELETE
    • Dashboard
      • get dashboard
      • refresh dashboard
      • delete component in dashboard
    • Settings
      • get settings
    • Marketplace
      • get all connectors
      • get marketplace coworkers
      • get marketplace coworker by id
    • Coworker schedules
      • get schedules
      • create coworker schedule
      • get schedule coworker by its id
      • update schedule by its id
      • delete schedule by its id
    • Analytics
      • Get analytics
    • Marketplace coworkers
      • hire a coworker
      • check marketplace coworker update
    • Project member
      • project_member
  1. Tables

get tables

GET
https://api.wexa.ai/storage/{projectID}
Last modified:2025-04-25 11:55:26

Retrieve Tables by Project ID#

Use this endpoint to retrieve a list of all tables associated with a specific project in your Wexa.ai environment. Tables serve as structured data repositories, allowing AI coworkers to store, retrieve, and process data efficiently in real time. This functionality is essential for managing datasets that require organization into rows and columns, facilitating seamless integration with ongoing processes and workflows.
Request Request Example
Shell
JavaScript
Java
Swift
curl --location --request GET 'https://api.wexa.ai/storage/' \
--header 'x-api-key: {{x-api-key}}'
Response Response Example
{
  "total_count": 5,
  "tables": [
    {
      "_id": "68071a4f1a9ea363140a265f",
      "projectID": "67fdea40aac77be632954f13",
      "table_name": "new table",
      "columns": [
        {
          "column_name": "_id",
          "column_type": "string",
          "column_id": "_id",
          "array_type": null,
          "default_value": "",
          "object_fields": null,
          "triggers": null,
          "enum_options": null
        },
        {
          "column_name": "Row ID",
          "column_type": "number",
          "column_id": "row_id",
          "array_type": null,
          "default_value": 1,
          "object_fields": null,
          "triggers": null,
          "enum_options": null
        },
        {
          "column_name": "User ID",
          "column_type": "string",
          "column_id": "coworker_user_id",
          "array_type": null,
          "default_value": "",
          "object_fields": null,
          "triggers": null,
          "enum_options": null
        }
      ],
      "connector_id": "68071a521a9ea363140a2660",
      "triggers": null,
      "last_row_id": 0
    },
    {
      "_id": "68071b771a9ea363140a2675",
      "projectID": "67fdea40aac77be632954f13",
      "table_name": "Leads table",
      "columns": [
        {
          "column_name": "_id",
          "column_type": "string",
          "column_id": "_id",
          "array_type": null,
          "default_value": "",
          "object_fields": null,
          "triggers": null,
          "enum_options": null
        },
        {
          "column_name": "Row ID",
          "column_type": "number",
          "column_id": "row_id",
          "array_type": null,
          "default_value": 1,
          "object_fields": null,
          "triggers": null,
          "enum_options": null
        },
        {
          "column_name": "User ID",
          "column_type": "string",
          "column_id": "coworker_user_id",
          "array_type": null,
          "default_value": "",
          "object_fields": null,
          "triggers": null,
          "enum_options": null
        }
      ],
      "connector_id": "68071b781a9ea363140a2676",
      "triggers": null,
      "last_row_id": 0
    },
    {
      "_id": "68071bd51a9ea363140a26a1",
      "projectID": "67fdea40aac77be632954f13",
      "table_name": "Customer table",
      "columns": [
        {
          "column_name": "_id",
          "column_type": "string",
          "column_id": "_id",
          "array_type": null,
          "default_value": "",
          "object_fields": null,
          "triggers": null,
          "enum_options": null
        },
        {
          "column_name": "Row ID",
          "column_type": "number",
          "column_id": "row_id",
          "array_type": null,
          "default_value": 1,
          "object_fields": null,
          "triggers": null,
          "enum_options": null
        },
        {
          "column_name": "User ID",
          "column_type": "string",
          "column_id": "coworker_user_id",
          "array_type": null,
          "default_value": "",
          "object_fields": null,
          "triggers": null,
          "enum_options": null
        }
      ],
      "connector_id": "68071bd61a9ea363140a26a2",
      "triggers": null,
      "last_row_id": 0
    },
    {
      "_id": "68071c321a9ea363140a26b7",
      "projectID": "67fdea40aac77be632954f13",
      "table_name": "Sample table",
      "columns": [
        {
          "column_name": "_id",
          "column_type": "string",
          "column_id": "_id",
          "array_type": null,
          "default_value": "",
          "object_fields": null,
          "triggers": null,
          "enum_options": null
        },
        {
          "column_name": "Row ID",
          "column_type": "number",
          "column_id": "row_id",
          "array_type": null,
          "default_value": 1,
          "object_fields": null,
          "triggers": null,
          "enum_options": null
        },
        {
          "column_name": "User ID",
          "column_type": "string",
          "column_id": "coworker_user_id",
          "array_type": null,
          "default_value": "",
          "object_fields": null,
          "triggers": null,
          "enum_options": null
        }
      ],
      "connector_id": "68071c331a9ea363140a26b8",
      "triggers": null,
      "last_row_id": 0
    },
    {
      "_id": "68071c551a9ea363140a26cd",
      "projectID": "67fdea40aac77be632954f13",
      "table_name": "Example table",
      "columns": [
        {
          "column_name": "_id",
          "column_type": "string",
          "column_id": "_id",
          "array_type": null,
          "default_value": "",
          "object_fields": null,
          "triggers": null,
          "enum_options": null
        },
        {
          "column_name": "Row ID",
          "column_type": "number",
          "column_id": "row_id",
          "array_type": null,
          "default_value": 1,
          "object_fields": null,
          "triggers": null,
          "enum_options": null
        },
        {
          "column_name": "User ID",
          "column_type": "string",
          "column_id": "coworker_user_id",
          "array_type": null,
          "default_value": "",
          "object_fields": null,
          "triggers": null,
          "enum_options": null
        }
      ],
      "connector_id": "68071c561a9ea363140a26ce",
      "triggers": null,
      "last_row_id": 0
    }
  ]
}

Request

Path Params
projectID
string 
required
Header Params
x-api-key
string 
required
Example:
{{x-api-key}}

Responses

🟢200get tables
application/json
Body
total_count
integer 
required
tables
array [object {7}] 
required
_id
string 
required
projectID
string 
required
table_name
string 
required
columns
array [object {8}] 
required
connector_id
string 
required
triggers
null 
required
last_row_id
integer 
required
Modified at 2025-04-25 11:55:26
Previous
create database
Next
get records list