Skip to content
getgeolens.com

Discover Tables

GET
/ingest/discover/
curl --request GET \
--url 'https://example.com/api/ingest/discover/?limit=1000' \
--header 'Authorization: Bearer <token>'

Discover unregistered tables in the data schema.

Returns tables not yet in the catalog, excluding staging, old, and system tables. Includes geometry type, SRID, and estimated row count. Bounded by limit (default 1000, max 5000) so instances with thousands of orphan tables don’t blow up the response payload.

limit
Limit

Maximum number of tables to return (PERF-11 bound).

integer
default: 1000 >= 1 <= 5000

Maximum number of tables to return (PERF-11 bound).

Successful Response

Media type application/json
DiscoverResponse
object
tables
required
Tables

Tables in the data schema that are eligible for registration as datasets.

Array<object>
DiscoveredTable
object
table_name
required
Table Name

PostgreSQL table name in the data schema.

string
geometry_type
required
Any of:
string
srid
required
Any of:
integer
estimated_rows
required
Any of:
integer
Example generated
{
"tables": [
{
"table_name": "example",
"geometry_type": "example",
"srid": 1,
"estimated_rows": 1
}
]
}

Bad request — invalid payload

Unauthorized — missing or invalid credentials

Forbidden — caller lacks write access

Not found

Conflict — resource state prevents the operation

Validation error

Internal server error