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
}
]
}

Validation Error

Media type application/json
HTTPValidationError
object
detail
Detail
Array<object>
ValidationError
object
loc
required
Location
Array
msg
required
Message
string
type
required
Error Type
string
input
Input
ctx
Context
object
Example generated
{
"detail": [
{
"loc": [
"example"
],
"msg": "example",
"type": "example",
"input": "example",
"ctx": {}
}
]
}