Documentation by ClonePartner

Start typing to search.

API Reference

List team explorer presets

View Markdown
GET /api/explorer-presets

List team explorer presets

Operation IDlistExplorerPresets

Authentication

  • BearerAuth·http bearer·API key token (envoy_<hex>). Create keys from Settings → API Keys — see Using the API.

Query parameters

connector_idinteger
resourcestring
qstring

Case-insensitive search across name/description fields

Success response body

200Preset list

Preset list

Content typeapplication/json

responseobject
4 properties
resultarray<ExplorerPreset>required
Array items
itemobject
8 properties
idinteger
namestring
connector_idinteger | null
Nullable
yes
resourcestring | null
Nullable
yes
definitionobject
12 properties
modestringrequired

Parameters are allowed in visual mode (placeholders in filter values) and in raw mode when rawQuery is valid JSON (placeholders inside JSON string literals). SQL/OData raw queries cannot be parameterized.

Allowed values
visual, raw
filtersarray<ExplorerFilter>
Array items
itemobject
4 properties
fieldstringrequired
operatorstringrequired
valuestringrequired

A literal value, or a {{param}} placeholder referencing a name in the preset's parameters.

valueTypestring

Optional type hint. Use objectId for MongoDB ObjectId fields so the value is coerced to Extended JSON on apply.

Allowed values
auto, string, number, boolean, null, objectId, date
actionstring

Visual builder action. Defaults to find when omitted.

Allowed values
find, count, insert, update, delete
rawQuerystring

Raw query string for mode: raw (SQL, Mongo Extended JSON, or OData). Ignored by parameterization.

columnsarray<string>
Array items
itemstring
limitstring
sortstring

Visual-mode sort column

orderstring

Visual-mode sort direction (omit or asc when unsorted / ascending)

Allowed values
asc, desc
resultViewstring
Allowed values
table, json
jsonatastring
csvDelimiterstring
parametersarray<PresetParameter>

Visual-mode only. Every parameter must be referenced by a {{name}} placeholder in a filter value, and every placeholder must reference a declared parameter.

Array items
itemobject
11 properties
namestringrequired

Referenced as {{name}} in a filter value. Letters, numbers, and underscores only; unique within the preset.

Pattern
^\w+$
labelstringrequired

Shown in the apply dialog.

requiredboolean
Default
true
typestringrequired

string — free text. objectId — free text validated as a 24-char hex ObjectId. mongoRecord — searchable record picker over a Mongo collection on the preset's connector.

Allowed values
string, objectId, mongoRecord
collectionstring

Required for mongoRecord. The Mongo collection to query (e.g. migration_jobs).

valueFieldstring

mongoRecord. Field substituted into the filter. Defaults to _id (coerced to ObjectId hex).

labelFieldstring

mongoRecord. Primary display label (e.g. name).

descriptionFieldsarray<string>

mongoRecord. Muted metadata fields shown under the label.

Array items
itemstring
searchFieldsarray<string>

mongoRecord. Fields searched server-side for the picker query.

Array items
itemstring
filterobject

mongoRecord. Base filter merged into every picker query.

sortobject

mongoRecord. Mongo sort object.

Additional properties
valueinteger
Allowed values
1, -1
created_byinteger
created_atstring · date-time
updated_atstring | null · date-time
Nullable
yes
nextCursorstring
prevCursorstring
totalinteger

Total number of records matching the current filters