Advanced Querying - Queries

Execute raw SQL table search

Executes a raw MI SQL SELECT provided in the request body, with optional bound parameters, pagination, and micro-batch execution. When 'parametersList' is present (and 'parameters' is absent), the response is a JSON array of FeatureCollections — one per parameter set — instead of a single FeatureCollection.

post/v1/spatial/tables/search

Request

  • Base URL: https://api.cloud.precisely.com
  • URL: https://api.cloud.precisely.com/v1/spatial/tables/search
  • Auth: one of:
    • bearerAuth (a scheme the document does not define)
    • ApiKeyAuth (a scheme the document does not define)

Query parameters

pagestring

Optional page number (1-based); must be used together with pageLength.

pageLengthstring

Optional number of features per page; must be used together with page.

lstring

Optional BCP 47 locale tag used for result localization.

Headers

X-Request-Idstring

The X-Request-Id header is optional but helpful for tracking requests. It acts as a unique identifier for troubleshooting and debugging issues effectively. Maximum length: 38 characters.Example: e02f00d5-e3a9-4fd6-aen1-3e5451abee46

Request body

string required

Response

Query executed successfully

Changes

No recorded changes to this operation across all 1 revision of this API.