Skip to main content
GET
/
v1
/
tables
/
{table_id}
/
data
Get Table Data
curl --request GET \
  --url https://api.extruct.ai/v1/tables/{table_id}/data \
  --header 'Authorization: Bearer <token>'
{
  "id": "<string>",
  "created_at": "2023-11-07T05:31:56Z",
  "name": "<string>",
  "columns": [
    {
      "id": "<string>",
      "created_at": "2023-11-07T05:31:56Z",
      "config": {
        "name": "<string>",
        "key": "<string>",
        "kind": "input"
      }
    }
  ],
  "owner": {
    "id": "<string>",
    "email": "<string>"
  },
  "status": {
    "num_columns": 123,
    "num_rows": 0,
    "num_output_columns": 0,
    "num_input_columns": 0,
    "num_cells_completed": 0,
    "num_cells_in_progress": 0
  },
  "rows": [
    {
      "id": "<string>",
      "created_at": "2023-11-07T05:31:56Z",
      "parent_row_id": "<string>",
      "company_profile_id": "<string>",
      "data": {},
      "metadata": {},
      "parent_data": {}
    }
  ],
  "description": "<string>",
  "tags": [
    "<string>"
  ],
  "child_relationships": [
    {
      "table_id": "<string>",
      "relationship_type": "company_people"
    }
  ],
  "parent_relationships": [
    {
      "table_id": "<string>",
      "relationship_type": "company_people"
    }
  ],
  "discovery_tasks": [
    {
      "id": "<string>",
      "created_at": "2023-11-07T05:31:56Z",
      "query": "<string>",
      "desired_num_results": 123,
      "is_exhausted": false,
      "num_results_discovered": 0,
      "num_results_enriched": 0,
      "num_results_evaluated": 0,
      "num_results": 0,
      "table_id": "<string>",
      "auto_data_sources": true,
      "data_sources": [],
      "criteria": [
        {
          "key": "<string>",
          "name": "<string>",
          "criterion": "<string>"
        }
      ],
      "exclude_domains": [
        "<string>"
      ]
    }
  ]
}

​
Overview

This endpoint returns paginated rows and computed values from a table. It is the main read endpoint for checking input, enrichment, or scoring output.

​
Example request

export EXTRUCT_API_TOKEN="YOUR_API_TOKEN"
export TABLE_ID="YOUR_TABLE_ID"

curl --get "https://api.extruct.ai/v1/tables/${TABLE_ID}/data" \
  -H "Authorization: Bearer ${EXTRUCT_API_TOKEN}" \
  --data-urlencode "offset=0" \
  --data-urlencode "limit=50"

​
Key parameters

  • table_id (required): target table identifier.
  • offset (optional): pagination offset.
  • limit (optional): page size.

​
Success signal

A successful response returns table rows and status context. Continue paging until returned rows are fewer than limit. Start with a small page size when validating a new workflow, then increase limit once the output looks correct.

​
Common errors

​
401 Unauthorized

Check that your header is Authorization: Bearer ${EXTRUCT_API_TOKEN}.

​
404 Not Found

The table ID is invalid or unavailable in your workspace.

Authorizations

​
Authorization
string
header
required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Path Parameters

​
table_id
string
required

Query Parameters

​
offset
integer | null
​
limit
integer | null

Response

Successful Response

​
id
string
required

Table ID.

​
created_at
string<date-time>
required

Table creation time.

​
name
string
required

Table name.

​
kind
enum<string>
required

Table type.

Available options:
generic,
company,
people
​
columns
ColumnOutputSchema · object[]
required

Table columns configurations.

​
owner
OwnerInfo · object
required
​
status
TableStatus · object
required
​
rows
RowDataOutputSchema · object[]
required
​
description
string | null

Table description.

​
tags
string[] | null

Table tags.

​
child_relationships
TableRelationshipOutput · object[]

Child table relationships.

​
parent_relationships
TableRelationshipOutput · object[]

Parent table relationships.

​
discovery_tasks
DiscoveryTaskOutput · object[] | null