Skip to main content
GET
/
api
/
integration-sources
/
{source_id}
/
columns
List All Integration Source Columns
curl --request GET \
  --url https://config.heyhumm.ai/api/integration-sources/{source_id}/columns \
  --header 'Authorization: Bearer <token>'
[
  {
    "name": "<string>",
    "id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "table_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "created_at": "2023-11-07T05:31:56Z",
    "updated_at": "2023-11-07T05:31:56Z",
    "description_version": 123,
    "description": "<string>",
    "data_type": "<string>",
    "is_primary_key": false,
    "is_nullable": true,
    "ordinal_position": 123,
    "semantic_type": "<string>",
    "semantic_type_confidence": 123,
    "sample_values": [
      "<unknown>"
    ],
    "enum_cardinality": 123,
    "null_pct": 123,
    "distinct_pct": 123,
    "last_analyzed": "2023-11-07T05:31:56Z",
    "approx_distinct_count": 123,
    "minhash_signature": [
      123
    ],
    "format_signature": {},
    "length_stats": {},
    "entropy": 123,
    "role": "<string>",
    "role_confidence": 123,
    "is_active": true,
    "description_source": "ai_generated",
    "description_generated_at": "2023-11-07T05:31:56Z"
  }
]

Documentation Index

Fetch the complete documentation index at: https://heyhumm.ai/docs/llms.txt

Use this file to discover all available pages before exploring further.

Authorizations

​
Authorization
string
header
required

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

Path Parameters

​
source_id
string<uuid> | null
required

Query Parameters

​
active_only
boolean
default:true

Only return active columns from active tables

​
organization_id
string<uuid> | null
​
resource_id
string<uuid> | null
​
integration_source_id
string<uuid> | null
​
data_source_id
string<uuid> | null
​
context_source_id
string<uuid> | null
​
job_id
string<uuid> | null

Response

Successful Response

​
name
string
required

Column name

​
id
string<uuid>
required
​
table_id
string<uuid>
required
​
created_at
string<date-time>
required
​
updated_at
string<date-time>
required
​
description_version
integer
required
​
description
string | null

Optional description of the column

​
data_type
string | null

Data type (e.g., VARCHAR, INTEGER, TIMESTAMP)

​
is_primary_key
boolean
default:false

Whether this column is a primary key

​
is_nullable
boolean
default:true

Whether this column allows null values

​
ordinal_position
integer | null

Position of the column in the table (1-based)

​
semantic_type
string | null

Semantic type of the column (e.g., email, phone, date)

​
semantic_type_confidence
number | null

Confidence score for the detected semantic type

​
sample_values
any[] | null

Sample values from the column

​
enum_cardinality
integer | null

Number of distinct values (for enum-like columns)

​
null_pct
number | null

Percentage of null values in this column

​
distinct_pct
number | null

Percentage of distinct values in this column

​
last_analyzed
string<date-time> | null

When this column was last analyzed for metadata

​
approx_distinct_count
integer | null

Approximate number of distinct values (HyperLogLog)

​
minhash_signature
integer[] | null

MinHash signature used for estimating Jaccard similarity

​
format_signature
Format Signature · object

Distribution of detected value formats / regex patterns

​
length_stats
Length Stats · object

Value length statistics (min, mean, p95)

​
entropy
number | null

Shannon entropy approximation for value distribution

​
role
string | null

Inferred column role (e.g., PRIMARY_KEY_CANDIDATE)

​
role_confidence
number | null

Confidence score for the inferred column role

​
is_active
boolean
default:true

Whether this column is active for analysis

​
description_source
enum<string> | null

How description was created: 'ai_generated' | 'manual_edit' | 'imported' | 'information_schema'

Available options:
ai_generated,
manual_edit,
imported,
information_schema
​
description_generated_at
string<date-time> | null

When description was last modified