Skip to content
getgeolens.com

Discover Tables

GET
/ingest/discover/
curl --request GET \
--url 'https://example.com/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
estimated_rows
required
Any of:
integer
geometry_type
required
Any of:
string
srid
required
Any of:
integer
table_name
required
Table Name

PostgreSQL table name in the data schema.

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

Bad request — invalid payload

ProblemDetail
object
detail
required
Detail
string
status
required
Status
integer
title
required
Title
string
type
Type
string
default: about:blank
Example
{
"type": "about:blank"
}

Unauthorized — missing or invalid credentials

ProblemDetail
object
detail
required
Detail
string
status
required
Status
integer
title
required
Title
string
type
Type
string
default: about:blank
Example
{
"type": "about:blank"
}

Forbidden — caller lacks write access

ProblemDetail
object
detail
required
Detail
string
status
required
Status
integer
title
required
Title
string
type
Type
string
default: about:blank
Example
{
"type": "about:blank"
}

Not found

ProblemDetail
object
detail
required
Detail
string
status
required
Status
integer
title
required
Title
string
type
Type
string
default: about:blank
Example
{
"type": "about:blank"
}

Conflict — resource state prevents the operation

ProblemDetail
object
detail
required
Detail
string
status
required
Status
integer
title
required
Title
string
type
Type
string
default: about:blank
Example
{
"type": "about:blank"
}

Validation error

ProblemDetail
object
detail
required
Detail
string
status
required
Status
integer
title
required
Title
string
type
Type
string
default: about:blank
Example
{
"type": "about:blank"
}

Internal server error

ProblemDetail
object
detail
required
Detail
string
status
required
Status
integer
title
required
Title
string
type
Type
string
default: about:blank
Example
{
"type": "about:blank"
}