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>",
"kind": "generic",
"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,
"run_status": "running",
"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>",
"data": {},
"metadata": {},
"parent_data": {}
}
],
"description": "<string>",
"tags": [
"<string>"
],
"notify": false,
"settings": {
"exclude_from_search": false
},
"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",
"status": "created",
"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": [
"web_search"
],
"criteria": [
{
"key": "<string>",
"name": "<string>",
"criterion": "<string>"
}
]
}
]
}Get table data with streaming response to handle large tables.
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>",
"kind": "generic",
"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,
"run_status": "running",
"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>",
"data": {},
"metadata": {},
"parent_data": {}
}
],
"description": "<string>",
"tags": [
"<string>"
],
"notify": false,
"settings": {
"exclude_from_search": false
},
"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",
"status": "created",
"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": [
"web_search"
],
"criteria": [
{
"key": "<string>",
"name": "<string>",
"criterion": "<string>"
}
]
}
]
}Bearer authentication header of the form Bearer <token>, where <token> is your auth token.
Successful Response
Table ID.
Table creation time.
Table name.
Table type.
generic, company, people Table columns configurations.
Show child attributes
Show child attributes
running, idle Number of rows in the table
Number of output columns in the table
Number of input columns in the table
Number of non-input cells that have been completed
Number of non-input cells that are in progress
Show child attributes
Row creation time.
ID of the parent row, if any.
Additional metadata
Data from the parent row, if requested and available.
Show child attributes
Table description.
Table tags.
Whether to notify on table completion.
Show child attributes
created, in_progress, done, failed Total number of company candidates discovered from search
Number of candidates enriched with company profiles
Number of candidates that had criteria evaluation completed
Total number of results
web_search, linkedin, maps Show child attributes
Unique identifier for this criterion (e.g., "is_ai_company")
Human-readable name for this criterion (e.g., "AI Company")
1 - 100The actual criterion text to evaluate against companies
10 - 500