> ## Documentation Index > Fetch the complete documentation index at: https://docs.elementary-data.com/llms.txt > Use this file to discover all available pages before exploring further. # List columns > Lists asset columns. Full scan by default; pass `synced_since` for the upserts feed or `deleted_since` for the tombstones feed. ## OpenAPI ````yaml api-reference/beta/openapi.json get /public/beta/{env_id}/columns openapi: 3.1.0 info: description: > The Elementary Public API is a REST interface for programmatically reading Elementary's assets, columns, and lineage for one environment. **Authentication.** Send a bearer token (personal or account token) in the `Authorization` header. The token resolves to an account; results are scoped to the environments that token may view. **Environment scope.** Every resource lives under `/{env_id}`. Call `GET /environments` first to discover the ids you can access. **Pagination.** List endpoints are keyset-paginated: pass `limit` (default 500, max 2000) and follow `next_cursor` until `has_more` is `false`. Cursors are opaque and bound to the filters that produced them — reusing a cursor with different filters returns `400`. **Incremental sync.** Every dataset supports a full scan (default). Assets and columns also expose two incremental feeds: `synced_since` (upserts) and `deleted_since` (soft-delete tombstones). **Rate limiting.** Requests are rate-limited per account; responses carry `RateLimit-*` headers and `429` responses include `Retry-After`. _Beta: the shape may change while we co-design with early adopters._ title: Elementary Public API version: beta servers: - url: https://prod.api.elementary-data.com security: - bearerAuth: [] tags: - description: Discover accessible environments. name: Environments - description: Lineage assets — tables, views, BI assets. name: Assets - description: Columns of assets. name: Columns - description: Asset-to-asset lineage edges. name: Asset lineage - description: Column-level lineage edges. name: Column lineage paths: /public/beta/{env_id}/columns: get: tags: - Columns summary: List columns description: >- Lists asset columns. Full scan by default; pass `synced_since` for the upserts feed or `deleted_since` for the tombstones feed. operationId: list_columns_public_beta__env_id__columns_get parameters: - description: Environment identifier that scopes the request. in: path name: env_id required: true schema: description: Environment identifier that scopes the request. title: Env Id type: string - description: Return only columns with these ids. in: query name: ids required: false schema: anyOf: - items: type: string maxItems: 1000 type: array - type: 'null' description: Return only columns with these ids. title: Ids - description: Return only columns belonging to these asset ids. in: query name: asset_ids required: false schema: anyOf: - items: type: string maxItems: 1000 type: array - type: 'null' description: Return only columns belonging to these asset ids. title: Asset Ids - description: Return only columns with these data types. in: query name: data_types required: false schema: anyOf: - items: type: string maxItems: 1000 type: array - type: 'null' description: Return only columns with these data types. title: Data Types - description: >- Upserts feed: columns whose `synced_at` >= this time (inclusive). Orders by `synced_at`. in: query name: synced_since required: false schema: anyOf: - format: date-time type: string - type: 'null' description: >- Upserts feed: columns whose `synced_at` >= this time (inclusive). Orders by `synced_at`. title: Synced Since - description: >- Tombstones feed: columns whose `deleted_at` >= this time (inclusive). Orders by `deleted_at`. in: query name: deleted_since required: false schema: anyOf: - format: date-time type: string - type: 'null' description: >- Tombstones feed: columns whose `deleted_at` >= this time (inclusive). Orders by `deleted_at`. title: Deleted Since - description: >- Opaque cursor from a previous response's `next_cursor`. Reuse it only with the identical query parameters that produced it. in: query name: cursor required: false schema: anyOf: - type: string - type: 'null' description: >- Opaque cursor from a previous response's `next_cursor`. Reuse it only with the identical query parameters that produced it. title: Cursor - description: Maximum items to return per page (1-2000). in: query name: limit required: false schema: default: 500 description: Maximum items to return per page (1-2000). maximum: 2000 minimum: 1 title: Limit type: integer - description: >- Sort field for a full scan. Ignored when `synced_since`/`deleted_since` is set (those feeds always order by their own cursor). in: query name: order_by required: false schema: $ref: '#/components/schemas/OrderBy' default: id description: >- Sort field for a full scan. Ignored when `synced_since`/`deleted_since` is set (those feeds always order by their own cursor). - description: Sort direction for `order_by`. in: query name: direction required: false schema: $ref: '#/components/schemas/Direction' default: asc description: Sort direction for `order_by`. responses: '200': content: application/json: schema: $ref: '#/components/schemas/PaginatedResponse_Column_' description: Successful Response '400': content: application/json: schema: $ref: '#/components/schemas/ApiErrorResponse' description: Invalid cursor or request parameters. '401': content: application/json: schema: $ref: '#/components/schemas/ApiErrorResponse' description: Authentication is required. '403': content: application/json: schema: $ref: '#/components/schemas/ApiErrorResponse' description: The token does not have permission to access the resource. '404': content: application/json: schema: $ref: '#/components/schemas/ApiErrorResponse' description: The requested resource was not found. '422': content: application/json: schema: $ref: '#/components/schemas/ApiErrorResponse' description: Request validation failed. '429': content: application/json: schema: $ref: '#/components/schemas/ApiErrorResponse' description: Rate limit exceeded. headers: RateLimit-Limit: description: Maximum requests allowed in the current window. schema: type: integer RateLimit-Remaining: description: Requests remaining in the current window. schema: type: integer RateLimit-Reset: description: Seconds until the current rate-limit window resets. schema: type: integer Retry-After: description: Seconds to wait before retrying. schema: type: integer '500': content: application/json: schema: $ref: '#/components/schemas/ApiErrorResponse' description: An unexpected server error occurred. components: schemas: OrderBy: enum: - id - synced_at title: OrderBy type: string Direction: enum: - asc - desc title: Direction type: string PaginatedResponse_Column_: properties: has_more: default: false description: >- The only signal to continue pagination; a short page may still have more items because permission filtering can trim rows. title: Has More type: boolean items: description: Objects returned in the current page. items: $ref: '#/components/schemas/Column' title: Items type: array next_cursor: anyOf: - type: string - type: 'null' description: >- Opaque cursor for the next page, valid only with identical query parameters. title: Next Cursor required: - items title: PaginatedResponse[Column] type: object ApiErrorResponse: properties: error: $ref: '#/components/schemas/ApiError' description: Structured details about the error. required: - error title: ApiErrorResponse type: object Column: properties: asset_id: description: ID of the asset this column belongs to. title: Asset Id type: string data_type: anyOf: - type: string - type: 'null' description: Data type reported by the source platform. title: Data Type deleted_at: anyOf: - format: date-time type: string - type: 'null' description: Soft-delete timestamp. Present only in the `deleted_since` feed. title: Deleted At id: description: Unique column identifier. title: Id type: string name: description: Column name. title: Name type: string synced_at: anyOf: - format: date-time type: string - type: 'null' description: >- When Elementary last synced this column. Use with `synced_since` for incremental reads. title: Synced At required: - id - name - asset_id title: Column type: object ApiError: properties: code: description: Stable code identifying the type of error. title: Code type: string message: description: Human-readable explanation of the error. title: Message type: string required: - code - message title: ApiError type: object securitySchemes: bearerAuth: description: Personal or account token. scheme: bearer type: http ````