Foundational · Schema
LineageEntitiesResponse
A response to a lineage search request.
CompanyData GovernanceAIData ManagementLineage
Properties
| Name | Type | Description |
|---|---|---|
| entities | array | The requested entities |
| pageToken | object | A token to fetch the next page of results |
| totalCount | object | Total number of matching entities across all pages (when available). Use this to answer 'how many' questions and to tell whether the returned page is complete or partial. |
JSON Schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"$id": "https://artifacts.apis.io/foundational/json-schema/foundational-lineage-entities-response-schema.json",
"title": "LineageEntitiesResponse",
"description": "A response to a lineage search request.",
"x-generated": "2026-10-29",
"x-method": "derived",
"x-generator": "derive-json-schema.py",
"x-source": "openapi/foundational-openapi.json#/components/schemas/LineageEntitiesResponse",
"properties": {
"entities": {
"items": {
"oneOf": [
{
"$ref": "#/$defs/APITableEntity"
},
{
"$ref": "#/$defs/APIColumnEntity"
},
{
"$ref": "#/$defs/APIDashboardEntity"
},
{
"$ref": "#/$defs/APIDashboardColumnEntity"
},
{
"$ref": "#/$defs/APIFileEntity"
},
{
"$ref": "#/$defs/APIFileColumnEntity"
},
{
"$ref": "#/$defs/APIStreamEntity"
},
{
"$ref": "#/$defs/APIStreamColumnEntity"
},
{
"$ref": "#/$defs/APIWarehouseTaskEntity"
},
{
"$ref": "#/$defs/APIWarehouseTaskColumnEntity"
},
{
"$ref": "#/$defs/APISalesforceResourceEntity"
},
{
"$ref": "#/$defs/APISalesforceResourceColumnEntity"
},
{
"$ref": "#/$defs/APISpreadsheetEntity"
},
{
"$ref": "#/$defs/APISpreadsheetColumnEntity"
},
{
"$ref": "#/$defs/APIWebResourceEntity"
},
{
"$ref": "#/$defs/APIWebResourceColumnEntity"
},
{
"$ref": "#/$defs/APIPowerPlatformDataflowEntity"
},
{
"$ref": "#/$defs/APIPowerPlatformDataflowColumnEntity"
},
{
"$ref": "#/$defs/APIExecutedQueryEntity"
},
{
"$ref": "#/$defs/APIExecutedQueryColumnEntity"
}
]
},
"type": "array",
"title": "Entities",
"description": "The requested entities"
},
"pageToken": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"title": "Pagetoken",
"description": "A token to fetch the next page of results"
},
"totalCount": {
"anyOf": [
{
"type": "integer"
},
{
"type": "null"
}
],
"title": "Totalcount",
"description": "Total number of matching entities across all pages (when available). Use this to answer 'how many' questions and to tell whether the returned page is complete or partial."
}
},
"type": "object",
"required": [
"entities"
],
"$defs": {
"APICertification": {
"type": "string",
"enum": [
"certified",
"deprecated"
],
"title": "APICertification"
},
"APIColumnEntity": {
"properties": {
"id": {
"type": "string",
"title": "Id"
},
"certification": {
"anyOf": [
{
"$ref": "#/$defs/APICertification"
},
{
"type": "null"
}
],
"description": "The certification of the entity: the one set on the entity itself, else the one on its nearest ancestor (see `ancestors`) that has one"
},
"certificationInheritedFrom": {
"anyOf": [
{
"$ref": "#/$defs/APILocationRef"
},
{
"type": "null"
}
],
"description": "The ancestor `certification` is inherited from; null when the certification is the entity's own or it has none"
},
"entityType": {
"type": "string",
"const": "COLUMN",
"title": "Entitytype",
"default": "COLUMN"
},
"ancestors": {
"anyOf": [
{
"items": {
"$ref": "#/$defs/APILocationRef"
},
"type": "array"
},
{
"type": "null"
}
],
"title": "Ancestors",
"description": "The locations the entity sits in, outermost first: its containers (account, database, schema, ...) and, for a column, its table. The entity inherits the certification and the custom tags set on them, unless it has its own."
},
"dbPlatform": {
"$ref": "#/$defs/TablePlatform"
},
"database": {
"type": "string",
"title": "Database",
"description": "The name of the database the table belongs to"
},
"dbSchema": {
"type": "string",
"title": "Dbschema",
"description": "The name of the schema the table belongs to"
},
"tableName": {
"type": "string",
"title": "Tablename",
"description": "The name of the table the column belongs to"
},
"name": {
"type": "string",
"title": "Name",
"description": "The name of the column"
},
"columnType": {
"anyOf": [
{
"$ref": "#/$defs/ColumnType"
},
{
"type": "null"
}
],
"description": "The type of the column"
}
},
"type": "object",
"required": [
"id",
"dbPlatform",
"database",
"dbSchema",
"tableName",
"name"
],
"title": "APIColumnEntity",
"description": "A table's column entity.\n\nContains relevant information about the parent table and the column itself."
},
"APIColumnEntitySlim": {
"properties": {
"id": {
"type": "string",
"title": "Id"
},
"entityId": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"title": "Entityid",
"description": "The column's own entity id: the id lineage walks and diff entries name it by. `id` addresses it in this API."
},
"name": {
"type": "string",
"title": "Name",
"description": "The name of the column"
},
"columnType": {
"anyOf": [
{
"$ref": "#/$defs/ColumnType"
},
{
"type": "null"
}
],
"description": "The type of the column"
},
"parentId": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"title": "Parentid",
"description": "The immediate owning Port or parent Field"
},
"certification": {
"anyOf": [
{
"$ref": "#/$defs/APICertification"
},
{
"type": "null"
}
],
"description": "The certification of the column: the one set on the column itself, else the one on its nearest ancestor (its table, then its containers) that has one"
},
"certificationInheritedFrom": {
"anyOf": [
{
"$ref": "#/$defs/APILocationRef"
},
{
"type": "null"
}
],
"description": "The ancestor `certification` is inherited from; null when the certification is the column's own or it has none"
},
"labels": {
"anyOf": [
{
"additionalProperties": {
"type": "string"
},
"type": "object"
},
{
"type": "null"
}
],
"title": "Labels",
"description": "The column's labels, embedded with `labels`: the tags scans found on it and the custom tags in effect on it, its own and, per tag name it has none of, its nearest ancestor's. A tag with several values joins them with ', '."
},
"owners": {
"anyOf": [
{
"items": {
"$ref": "#/$defs/PublicEntityOwner"
},
"type": "array"
},
{
"type": "null"
}
],
"title": "Owners",
"description": "The column's owners, embedded with `owners`: its own and every ancestor's, each user once."
}
},
"type": "object",
"required": [
"id",
"name"
],
"title": "APIColumnEntitySlim"
},
"APIDashboardColumnEntity": {
"properties": {
"id": {
"type": "string",
"title": "Id"
},
"certification": {
"anyOf": [
{
"$ref": "#/$defs/APICertification"
},
{
"type": "null"
}
],
"description": "The certification of the entity: the one set on the entity itself, else the one on its nearest ancestor (see `ancestors`) that has one"
},
"certificationInheritedFrom": {
"anyOf": [
{
"$ref": "#/$defs/APILocationRef"
},
{
"type": "null"
}
],
"description": "The ancestor `certification` is inherited from; null when the certification is the entity's own or it has none"
},
"entityType": {
"type": "string",
"const": "DASHBOARD_COLUMN",
"title": "Entitytype",
"default": "DASHBOARD_COLUMN"
},
"ancestors": {
"anyOf": [
{
"items": {
"$ref": "#/$defs/APILocationRef"
},
"type": "array"
},
{
"type": "null"
}
],
"title": "Ancestors",
"description": "The locations the entity sits in, outermost first: its containers (account, database, schema, ...) and, for a column, its table. The entity inherits the certification and the custom tags set on them, unless it has its own."
},
"dashboardPlatform": {
"$ref": "#/$defs/VisualizationPlatform",
"description": "The platform of the dashboard"
},
"projectName": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"title": "Projectname",
"description": "The name of the project the dashboard belongs to"
},
"dashboardName": {
"type": "string",
"title": "Dashboardname",
"description": "The name of the dashboard"
},
"url": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"title": "Url",
"description": "The URL identifying the dashboard"
},
"name": {
"type": "string",
"title": "Name",
"description": "The name of the column"
}
},
"type": "object",
"required": [
"id",
"dashboardPlatform",
"dashboardName",
"name"
],
"title": "APIDashboardColumnEntity",
"description": "A dashboard column entity.\n\nContains relevant information about the parent dashboard and the column itself."
},
"APIDashboardEntity": {
"properties": {
"id": {
"type": "string",
"title": "Id"
},
"certification": {
"anyOf": [
{
"$ref": "#/$defs/APICertification"
},
{
"type": "null"
}
],
"description": "The certification of the entity: the one set on the entity itself, else the one on its nearest ancestor (see `ancestors`) that has one"
},
"certificationInheritedFrom": {
"anyOf": [
{
"$ref": "#/$defs/APILocationRef"
},
{
"type": "null"
}
],
"description": "The ancestor `certification` is inherited from; null when the certification is the entity's own or it has none"
},
"entityType": {
"type": "string",
"const": "DASHBOARD",
"title": "Entitytype",
"default": "DASHBOARD"
},
"ancestors": {
"anyOf": [
{
"items": {
"$ref": "#/$defs/APILocationRef"
},
"type": "array"
},
{
"type": "null"
}
],
"title": "Ancestors",
"description": "The locations the entity sits in, outermost first: its containers (account, database, schema, ...) and, for a column, its table. The entity inherits the certification and the custom tags set on them, unless it has its own."
},
"childrenTruncated": {
"anyOf": [
{
"type": "boolean"
},
{
"type": "null"
}
],
"title": "Childrentruncated",
"description": "True when `children` is a bounded partial projection, false when child hydration completed, and omitted when this endpoint did not hydrate children."
},
"dashboardPlatform": {
"$ref": "#/$defs/VisualizationPlatform",
"description": "The platform of the dashboard"
},
"projectName": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"title": "Projectname",
"description": "The name of the project the dashboard belongs to"
},
"name": {
"type": "string",
"title": "Name",
"description": "The name of the dashboard"
},
"url": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"title": "Url",
"description": "The URL identifying the dashboard"
},
"usageSummary": {
"anyOf": [
{
"$ref": "#/$defs/VisualizationUsageSummary"
},
{
"type": "null"
}
],
"description": "Compact usage signal: monthly view count and last view time. Populated on search responses for dashboards that have view activity in the lookback window; null otherwise. Use this to rank dashboards by activity without drilling into each entity."
},
"children": {
"anyOf": [
{
"items": {
"$ref": "#/$defs/APIColumnEntitySlim"
},
"type": "array"
},
{
"type": "null"
}
],
"title": "Children"
}
},
"type": "object",
"required": [
"id",
"dashboardPlatform",
"name"
],
"title": "APIDashboardEntity",
"description": "A dashboard entity."
},
"APIExecutedQueryColumnEntity": {
"properties": {
"id": {
"type": "string",
"title": "Id"
},
"certification": {
"anyOf": [
{
"$ref": "#/$defs/APICertification"
},
{
"type": "null"
}
],
"description": "The certification of the entity: the one set on the entity itself, else the one on its nearest ancestor (see `ancestors`) that has one"
},
"certificationInheritedFrom": {
"anyOf": [
{
"$ref": "#/$defs/APILocationRef"
},
{
"type": "null"
}
],
"description": "The ancestor `certification` is inherited from; null when the certification is the entity's own or it has none"
},
"entityType": {
"type": "string",
"const": "EXECUTED_QUERY_COLUMN",
"title": "Entitytype",
"default": "EXECUTED_QUERY_COLUMN"
},
"ancestors": {
"anyOf": [
{
"items": {
"$ref": "#/$defs/APILocationRef"
},
"type": "array"
},
{
"type": "null"
}
],
"title": "Ancestors",
"description": "The locations the entity sits in, outermost first: its containers (account, database, schema, ...) and, for a column, its table. The entity inherits the certification and the custom tags set on them, unless it has its own."
},
"platform": {
"$ref": "#/$defs/TablePlatform",
"description": "The platform of the executed query"
},
"userEmail": {
"type": "string",
"title": "Useremail",
"description": "The email of the user who executed the query"
},
"extractionDatabase": {
"type": "string",
"title": "Extractiondatabase",
"description": "The database where the query was extracted from"
},
"name": {
"type": "string",
"title": "Name",
"description": "The name of the column"
}
},
"type": "object",
"required": [
"id",
"platform",
"userEmail",
"extractionDatabase",
"name"
],
"title": "APIExecutedQueryColumnEntity",
"description": "An executed query column entity.\n\nContains relevant information about the parent executed query and the column itself."
},
"APIExecutedQueryEntity": {
"properties": {
"id": {
"type": "string",
"title": "Id"
},
"certification": {
"anyOf": [
{
"$ref": "#/$defs/APICertification"
},
{
"type": "null"
}
],
"description": "The certification of the entity: the one set on the entity itself, else the one on its nearest ancestor (see `ancestors`) that has one"
},
"certificationInheritedFrom": {
"anyOf": [
{
"$ref": "#/$defs/APILocationRef"
},
{
"type": "null"
}
],
"description": "The ancestor `certification` is inherited from; null when the certification is the entity's own or it has none"
},
"entityType": {
"type": "string",
"const": "EXECUTED_QUERY",
"title": "Entitytype",
"default": "EXECUTED_QUERY"
},
"ancestors": {
"anyOf": [
{
"items": {
"$ref": "#/$defs/APILocationRef"
},
"type": "array"
},
{
"type": "null"
}
],
"title": "Ancestors",
"description": "The locations the entity sits in, outermost first: its containers (account, database, schema, ...) and, for a column, its table. The entity inherits the certification and the custom tags set on them, unless it has its own."
},
"childrenTruncated": {
"anyOf": [
{
"type": "boolean"
},
{
"type": "null"
}
],
"title": "Childrentruncated",
"description": "True when `children` is a bounded partial projection, false when child hydration completed, and omitted when this endpoint did not hydrate children."
},
"platform": {
"$ref": "#/$defs/TablePlatform",
"description": "The platform of the executed query"
},
"userEmail": {
"type": "string",
"title": "Useremail",
"description": "The email of the user who executed the query"
},
"extractionDatabase": {
"type": "string",
"title": "Extractiondatabase",
"description": "The database where the query was extracted from"
},
"name": {
"type": "string",
"title": "Name",
"description": "The name of the executed query entity"
},
"children": {
"anyOf": [
{
"items": {
"$ref": "#/$defs/APIColumnEntitySlim"
},
"type": "array"
},
{
"type": "null"
}
],
"title": "Children"
}
},
"type": "object",
"required": [
"id",
"platform",
"userEmail",
"extractionDatabase",
"name"
],
"title": "APIExecutedQueryEntity",
"description": "An executed query entity."
},
"APIFileColumnEntity": {
"properties": {
"id": {
"type": "string",
"title": "Id"
},
"certification": {
"anyOf": [
{
"$ref": "#/$defs/APICertification"
},
{
"type": "null"
}
],
"description": "The certification of the entity: the one set on the entity itself, else the one on its nearest ancestor (see `ancestors`) that has one"
},
"certificationInheritedFrom": {
"anyOf": [
{
"$ref": "#/$defs/APILocationRef"
},
{
"type": "null"
}
],
"description": "The ancestor `certification` is inherited from; null when the certification is the entity's own or it has none"
},
"entityType": {
"type": "string",
"const": "FILE_COLUMN",
"title": "Entitytype",
"default": "FILE_COLUMN"
},
"ancestors": {
"anyOf": [
{
"items": {
"$ref": "#/$defs/APILocationRef"
},
"type": "array"
},
{
"type": "null"
}
],
"title": "Ancestors",
"description": "The locations the entity sits in, outermost first: its containers (account, database, schema, ...) and, for a column, its table. The entity inherits the certification and the custom tags set on them, unless it has its own."
},
"platform": {
"$ref": "#/$defs/StoragePlatform",
"description": "The storage platform of the file"
},
"uri": {
"type": "string",
"title": "Uri",
"description": "The URI of the file"
},
"fileName": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"title": "Filename",
"description": "The name of the file"
},
"name": {
"type": "string",
"title": "Name",
"description": "The name of the column"
}
},
"type": "object",
"required": [
"id",
"platform",
"uri",
"name"
],
"title": "APIFileColumnEntity",
"description": "A file column entity.\n\nContains relevant information about the parent file and the column itself."
},
"APIFileEntity": {
"properties": {
"id": {
"type": "string",
"title": "Id"
},
"certification": {
"anyOf": [
{
"$ref": "#/$defs/APICertification"
},
{
"type": "null"
}
],
"description": "The certification of the entity: the one set on the entity itself, else the one on its nearest ancestor (see `ancestors`) that has one"
},
"certificationInheritedFrom": {
"anyOf": [
{
"$ref": "#/$defs/APILocationRef"
},
{
"type": "null"
}
],
"description": "The ancestor `certification` is inherited from; null when the certification is the entity's own or it has none"
},
"entityType": {
"type": "string",
"const": "FILE",
"title": "Entitytype",
"default": "FILE"
},
"ancestors": {
"anyOf": [
{
"items": {
"$ref": "#/$defs/APILocationRef"
},
"type": "array"
},
{
"type": "null"
}
],
"title": "Ancestors",
"description": "The locations the entity sits in, outermost first: its containers (account, database, schema, ...) and, for a column, its table. The entity inherits the certification and the custom tags set on them, unless it has its own."
},
"childrenTruncated": {
"anyOf": [
{
"type": "boolean"
},
{
"type": "null"
}
],
"title": "Childrentruncated",
"description": "True when `children` is a bounded partial projection, false when child hydration completed, and omitted when this endpoint did not hydrate children."
},
"platform": {
"$ref": "#/$defs/StoragePlatform",
"description": "The storage platform of the file"
},
"uri": {
"type": "string",
"title": "Uri",
"description": "The URI of the file"
},
"fileName": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"title": "Filename",
"description": "The name of the file"
},
"dirName": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"title": "Dirname",
"description": "The directory name"
},
"fileFormat": {
"anyOf": [
{
"$ref": "#/$defs/FileFormat"
},
{
"type": "null"
}
],
"description": "The format of the file"
},
"name": {
"type": "string",
"title": "Name",
"description": "The name of the file entity"
},
"children": {
"anyOf": [
{
"items": {
"$ref": "#/$defs/APIColumnEntitySlim"
},
"type": "array"
},
{
"type": "null"
}
],
"title": "Children"
}
},
"type": "object",
"required": [
"id",
"platform",
"uri",
"name"
],
"title": "APIFileEntity",
"description": "A file entity."
},
"APILocationRef": {
"properties": {
"locationId": {
"type": "string",
"title": "Locationid",
"description": "The location's id. The certification and tag endpoints take it as `entity_id`, so a value set on a container applies to everything under it."
},
"level": {
"type": "string",
"title": "Level",
"description": "A container's level, such as `account`, `db` or `schema`, or an entity's type, such as `table`"
},
"name": {
"type": "string",
"title": "Name",
"description": "The container's or entity's name"
}
},
"type": "object",
"required": [
"locationId",
"level",
"name"
],
"title": "APILocationRef",
"description": "A location a certification or custom tags can be set on: a container (an account, a database, a schema,\na BI project or folder, ...) or an entity."
},
"APIPowerPlatformDataflowColumnEntity": {
"properties": {
"id": {
"type": "string",
"title": "Id"
},
"certification": {
"anyOf": [
{
"$ref": "#/$defs/APICertification"
},
{
"type": "null"
}
],
"description": "The certification of the entity: the one set on the entity itself, else the one on its nearest ancestor (see `ancestors`) that has one"
},
"certificationInheritedFrom": {
"anyOf": [
{
"$ref": "#/$defs/APILocationRef"
},
{
"type": "null"
}
],
"description": "The ancestor `certification` is inherited from; null when the certification is the entity's own or it has none"
},
"entityType": {
"type": "string",
"const": "POWER_PLATFORM_DATAFLOW_COLUMN",
"title": "Entitytype",
"default": "POWER_PLATFORM_DATAFLOW_COLUMN"
},
"ancestors": {
"anyOf": [
{
"items": {
"$ref": "#/$defs/APILocationRef"
},
"type": "array"
},
{
"type": "null"
}
],
"title": "Ancestors",
"description": "The locations the entity sits in, outermost first: its containers (account, database, schema, ...) and, for a column, its table. The entity inherits the certification and the custom tags set on them, unless it has its own."
},
"platform": {
"$ref": "#/$defs/PowerPlatformPlatform",
"description": "The Power Platform platform"
},
"workspaceId": {
"type": "string",
"title": "Workspaceid",
"description": "The workspace ID"
},
"dataflowId": {
"type": "string",
"title": "Dataflowid",
"description": "The dataflow ID"
},
"dataflowEntityName": {
"type": "string",
"title": "Dataflowentityname",
"description": "The dataflow entity name"
},
"name": {
"type": "string",
"title": "Name",
"description": "The name of the column"
}
},
"type": "object",
"required": [
"id",
"platform",
"workspaceId",
"dataflowId",
"dataflowEntityName",
"name"
],
"title": "APIPowerPlatformDataflowColumnEntity",
"description": "A Power Platform dataflow column entity.\n\nContains relevant information about the parent Power Platform dataflow and the column itself."
},
"APIPowerPlatformDataflowEntity": {
"properties": {
"id": {
"type": "string",
"title": "Id"
},
"certification": {
"anyOf": [
{
"$ref": "#/$defs/APICertification"
},
{
"type": "null"
}
],
"description": "The certification of the entity: the one set on the entity itself, else the one on its nearest ancestor (see `ancestors`) that has one"
},
"certificationInheritedFrom": {
"anyOf": [
{
"$ref": "#/$defs/APILocationRef"
},
{
"type": "null"
}
],
"description": "The ancestor `certification` is inherited from; null when the certification is the entity's own or it has none"
},
"entityType": {
"type": "string",
"const": "POWER_PLATFORM_DATAFLOW",
"title": "Entitytype",
"default": "POWER_PLATFORM_DATAFLOW"
},
"ancestors": {
"anyOf": [
{
"items": {
"$ref": "#/$defs/APILocationRef"
},
"type": "array"
},
{
"type": "null"
}
],
"title": "Ancestors",
# --- truncated at 32 KB (71 KB total) ---
# Full source: https://artifacts.apis.io/foundational/json-schema/foundational-lineage-entities-response-schema.json
Work with this as data
Every JSON Schema here is available over the APIs.io API and to AI agents over MCP.
MCP server
One button, every client — Claude, Cursor, VS Code and the rest.
https://apis.io/mcp
Tools for schemas
4 MCP tools reach this
find_json_schemasBrowse and filter every JSON Schema in the catalog.apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.resolveTurn a domain, URL or GitHub org into the provider it belongs to.find_cohortsEvery scored population of providers in the catalog.
Call it yourself
curl for this page
This JSON Schema
curl "https://apis.io/api/v1/json-schemas/foundational-lineage-entities-response"
All schemas
curl "https://apis.io/api/v1/json-schemas?limit=25"
Discovery needs no key. Ratings and market analysis are Pro.
Get an API key
Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.
A second provider on the same verified email joins the account you already have.