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

get records list

GET
api.wexa.ai/storage/67fdea40aac77be632954f13/68071b771a9ea363140a2675
Request Request Example
Shell
JavaScript
Java
Swift
curl --location --request GET 'api.wexa.ai/storage/67fdea40aac77be632954f13/68071b771a9ea363140a2675?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

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-23 12:52:23
Previous
get tables
Next
get table names
Built with