Wexa AI
  1. Tables
Wexa AI
  • Wexa AI
  • Use Cases and Workflows
  • API Reference
  • Troubleshooting Guide
  • Onboarding
    • Getting Started with Wexa
    • Hire your AI Coworker
  • AI Coworker Creation
    • Create your First AI Coworker
    • Process Flows
    • Creating your First Agent
    • Schedule a Process Flow
    • Executing a Process Flow
    • Settings - Input Form
    • History
  • Tables
    • Intro to Tables
    • Adding records to Tables
    • Table Triggers
  • Knowledge Base
    • Intro to Knowledge Base
  • Connectors and MCP Servers
    • Adding a New Connector
    • Adding an MCP Server
    • Setting up Connectors Triggers
  • 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
      • Connectors and MCP Servers
      • 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
    • Available Connectors
      • Actions
  1. Tables

get records list

GET
https://api.wexa.ai/storage/{projectID}/{table_id}
Last modified:2025-04-25 11:56:30

Retrieve Records by Table ID#

Use this endpoint to retrieve a list of all records associated with a specific table within a given project in your Wexa.ai environment. This functionality allows you to access structured data stored in tables, enabling efficient data retrieval for analysis, reporting, or further processing.
Request Request Example
Shell
JavaScript
Java
Swift
curl --location --request GET 'https://api.wexa.ai/storage//?projectID=67fdea40aac77be632954f13&page=1&query=&sort=1&sort_key=_id' \
--header 'x-api-key: {{x-api-key}}'
Response Response Example
{
    "meta_data": {
        "_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
            },
            {
                "column_name": "city",
                "column_type": "String",
                "column_id": "city",
                "array_type": null,
                "default_value": "",
                "object_fields": null,
                "triggers": null,
                "enum_options": null
            }
        ],
        "connector_id": "68071b781a9ea363140a2676",
        "triggers": null,
        "last_row_id": 1
    },
    "total_count": 1,
    "records": [
        {
            "_id": "68071f1d1a9ea363140a26e3",
            "city": "hyderabad",
            "row_id": 1,
            "coworker_user_id": "67fdea40aac77be632954f0e"
        }
    ]
}

Request

Path Params
projectID
string 
required
table_id
string 
required
Query Params
projectID
string 
required
Example:
67fdea40aac77be632954f13
page
string 
required
Example:
1
query
string 
required
sort
string 
required
Example:
1
sort_key
string 
required
Example:
_id
Header Params
x-api-key
string 
required
Example:
{{x-api-key}}

Responses

🟢200get records list
application/json
Body
meta_data
object 
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
total_count
integer 
required
records
array [object {4}] 
required
_id
string 
optional
city
string 
optional
row_id
integer 
optional
coworker_user_id
string 
optional
Modified at 2025-04-25 11:56:30
Previous
get tables
Next
get table names