Skip to content

Return query options.

GET
/api/workspace/entity/{entityIdOrKey}/instances/query/options
curl --request GET \
--url https://example.com/api/workspace/entity/example/instances/query/options

Returns backend-approved filter and sort options for one runtime entity definition. The payload is security-shaped for the current caller and includes only query targets that the backend would actually accept for filtering, sorting, and child-table row predicates.

  • None
entityIdOrKey
required
string

Entity definition identifier or normalized entity key.

access_token
string

Optional access token for clients that cannot set Authorization headers. Prefer Authorization: Bearer <token> when possible.

OK

Media typeapplication/json
object
Data

Backend-approved query capabilities for one runtime entity definition.

object
Options

Ordered list of query targets available to the current caller.

Array<object>
nullable

One runtime query target with backend-approved filter and sort capabilities.

object
Id

Stable option identifier.

string
nullable
Label

Localized user-facing label.

string
nullable
Kind
integer format: int32
Allowed values: 0 1 2 3 4
Reference

Reference to a runtime field by identifier, normalized key, or special query field.

object
FieldId

Field identifier or backend-issued synthetic system-field identifier.

string
nullable
FieldKey

Field key resolved through the runtime normalized-key index.

string
nullable
Special
integer format: int32
Allowed values: 0
StatementId

Statement identifier resolved through the runtime statement index.

string
nullable
StatementKey

Statement key resolved through the runtime normalized-key index.

string
nullable
ObjectContextFactId

Configured object-context fact identifier.

string
nullable
ObjectContextFactFilterKey

Provider-owned object-context fact filter facet key.

string
nullable
FieldType
integer format: int32
Allowed values: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
AllowMultiple

Whether multiple values are allowed for the bound field.

boolean
DecimalPrecision

Decimal precision when applicable.

integer format: int32
nullable
DecimalScale

Decimal scale when applicable.

integer format: int32
nullable
StringMaxLength

String max length when applicable.

integer format: int32
nullable
ReferenceToEntityDefinitionId

Target entity definition identifier for reference-style fields.

string
nullable
PairedReferenceFieldId

Paired reference field identifier for inverse-reference fields.

string
nullable
ReferenceDeleteBehavior
integer format: int32
Allowed values: 0 1
Options

Select options when applicable.

Array<object>
nullable

Option metadata for select fields.

object
Id

Option identifier.

string
nullable
EntityFieldDefinitionId

Owning field identifier.

string
nullable
Key

Option key.

string
nullable
Value

Option display value.

string
nullable
SortOrder

Sort order.

integer format: int32
CanFilter

Whether the backend accepts filter predicates for this option.

boolean
FilterOperators

Operators accepted by the backend for this option.

Array<integer>
nullable
Allowed values: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
FilterVariables

Runtime variables accepted by the backend for this option.

Array<integer>
nullable
Allowed values: 0 1
CanSort

Whether the backend accepts sort items for this option.

boolean
RowsFilterOptions
Array<object> recursive
BaseCurrencyCode

Base currency code for Money fields.

string
nullable
MaxSortItems

Maximum number of accepted sort items.

integer format: int32
Errors
Array<object>
nullable
object
Code
required
string
nullable
Message
required
string
nullable
Target
string
nullable
Field
string
nullable
Metadata
object
key
additional properties
string
nullable
Type
integer format: int32
Allowed values: 0 1 2
Severity
integer format: int32
Allowed values: 0 1 2
Warnings
Array<object>
nullable
object
Code
required
string
nullable
Message
required
string
nullable
Target
string
nullable
Field
string
nullable
Metadata
object
key
additional properties
string
nullable
Type
integer format: int32
Allowed values: 0 1 2
Severity
integer format: int32
Allowed values: 0 1 2
Success
boolean
Example
{
"Data": {
"Options": [
{
"Kind": 0,
"Reference": {
"Special": 0
},
"FieldType": 0,
"ReferenceDeleteBehavior": 0,
"FilterOperators": [
0
],
"FilterVariables": [
0
]
}
]
},
"Errors": [
{
"Type": 0,
"Severity": 0
}
],
"Warnings": [
{
"Type": 0,
"Severity": 0
}
]
}

Forbidden

Media typeapplication/json
object
type
string
nullable
title
string
nullable
status
integer format: int32
nullable
detail
string
nullable
instance
string
nullable
key
additional properties
Examplegenerated
{
"type": "example",
"title": "example",
"status": 1,
"detail": "example",
"instance": "example"
}

Not Found

Media typeapplication/json
object
Data

Backend-approved query capabilities for one runtime entity definition.

object
Options

Ordered list of query targets available to the current caller.

Array<object>
nullable

One runtime query target with backend-approved filter and sort capabilities.

object
Id

Stable option identifier.

string
nullable
Label

Localized user-facing label.

string
nullable
Kind
integer format: int32
Allowed values: 0 1 2 3 4
Reference

Reference to a runtime field by identifier, normalized key, or special query field.

object
FieldId

Field identifier or backend-issued synthetic system-field identifier.

string
nullable
FieldKey

Field key resolved through the runtime normalized-key index.

string
nullable
Special
integer format: int32
Allowed values: 0
StatementId

Statement identifier resolved through the runtime statement index.

string
nullable
StatementKey

Statement key resolved through the runtime normalized-key index.

string
nullable
ObjectContextFactId

Configured object-context fact identifier.

string
nullable
ObjectContextFactFilterKey

Provider-owned object-context fact filter facet key.

string
nullable
FieldType
integer format: int32
Allowed values: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
AllowMultiple

Whether multiple values are allowed for the bound field.

boolean
DecimalPrecision

Decimal precision when applicable.

integer format: int32
nullable
DecimalScale

Decimal scale when applicable.

integer format: int32
nullable
StringMaxLength

String max length when applicable.

integer format: int32
nullable
ReferenceToEntityDefinitionId

Target entity definition identifier for reference-style fields.

string
nullable
PairedReferenceFieldId

Paired reference field identifier for inverse-reference fields.

string
nullable
ReferenceDeleteBehavior
integer format: int32
Allowed values: 0 1
Options

Select options when applicable.

Array<object>
nullable

Option metadata for select fields.

object
Id

Option identifier.

string
nullable
EntityFieldDefinitionId

Owning field identifier.

string
nullable
Key

Option key.

string
nullable
Value

Option display value.

string
nullable
SortOrder

Sort order.

integer format: int32
CanFilter

Whether the backend accepts filter predicates for this option.

boolean
FilterOperators

Operators accepted by the backend for this option.

Array<integer>
nullable
Allowed values: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
FilterVariables

Runtime variables accepted by the backend for this option.

Array<integer>
nullable
Allowed values: 0 1
CanSort

Whether the backend accepts sort items for this option.

boolean
RowsFilterOptions
Array<object> recursive
BaseCurrencyCode

Base currency code for Money fields.

string
nullable
MaxSortItems

Maximum number of accepted sort items.

integer format: int32
Errors
Array<object>
nullable
object
Code
required
string
nullable
Message
required
string
nullable
Target
string
nullable
Field
string
nullable
Metadata
object
key
additional properties
string
nullable
Type
integer format: int32
Allowed values: 0 1 2
Severity
integer format: int32
Allowed values: 0 1 2
Warnings
Array<object>
nullable
object
Code
required
string
nullable
Message
required
string
nullable
Target
string
nullable
Field
string
nullable
Metadata
object
key
additional properties
string
nullable
Type
integer format: int32
Allowed values: 0 1 2
Severity
integer format: int32
Allowed values: 0 1 2
Success
boolean
Example
{
"Data": {
"Options": [
{
"Kind": 0,
"Reference": {
"Special": 0
},
"FieldType": 0,
"ReferenceDeleteBehavior": 0,
"FilterOperators": [
0
],
"FilterVariables": [
0
]
}
]
},
"Errors": [
{
"Type": 0,
"Severity": 0
}
],
"Warnings": [
{
"Type": 0,
"Severity": 0
}
]
}

Conflict

Media typeapplication/json
object
Data

Backend-approved query capabilities for one runtime entity definition.

object
Options

Ordered list of query targets available to the current caller.

Array<object>
nullable

One runtime query target with backend-approved filter and sort capabilities.

object
Id

Stable option identifier.

string
nullable
Label

Localized user-facing label.

string
nullable
Kind
integer format: int32
Allowed values: 0 1 2 3 4
Reference

Reference to a runtime field by identifier, normalized key, or special query field.

object
FieldId

Field identifier or backend-issued synthetic system-field identifier.

string
nullable
FieldKey

Field key resolved through the runtime normalized-key index.

string
nullable
Special
integer format: int32
Allowed values: 0
StatementId

Statement identifier resolved through the runtime statement index.

string
nullable
StatementKey

Statement key resolved through the runtime normalized-key index.

string
nullable
ObjectContextFactId

Configured object-context fact identifier.

string
nullable
ObjectContextFactFilterKey

Provider-owned object-context fact filter facet key.

string
nullable
FieldType
integer format: int32
Allowed values: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
AllowMultiple

Whether multiple values are allowed for the bound field.

boolean
DecimalPrecision

Decimal precision when applicable.

integer format: int32
nullable
DecimalScale

Decimal scale when applicable.

integer format: int32
nullable
StringMaxLength

String max length when applicable.

integer format: int32
nullable
ReferenceToEntityDefinitionId

Target entity definition identifier for reference-style fields.

string
nullable
PairedReferenceFieldId

Paired reference field identifier for inverse-reference fields.

string
nullable
ReferenceDeleteBehavior
integer format: int32
Allowed values: 0 1
Options

Select options when applicable.

Array<object>
nullable

Option metadata for select fields.

object
Id

Option identifier.

string
nullable
EntityFieldDefinitionId

Owning field identifier.

string
nullable
Key

Option key.

string
nullable
Value

Option display value.

string
nullable
SortOrder

Sort order.

integer format: int32
CanFilter

Whether the backend accepts filter predicates for this option.

boolean
FilterOperators

Operators accepted by the backend for this option.

Array<integer>
nullable
Allowed values: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
FilterVariables

Runtime variables accepted by the backend for this option.

Array<integer>
nullable
Allowed values: 0 1
CanSort

Whether the backend accepts sort items for this option.

boolean
RowsFilterOptions
Array<object> recursive
BaseCurrencyCode

Base currency code for Money fields.

string
nullable
MaxSortItems

Maximum number of accepted sort items.

integer format: int32
Errors
Array<object>
nullable
object
Code
required
string
nullable
Message
required
string
nullable
Target
string
nullable
Field
string
nullable
Metadata
object
key
additional properties
string
nullable
Type
integer format: int32
Allowed values: 0 1 2
Severity
integer format: int32
Allowed values: 0 1 2
Warnings
Array<object>
nullable
object
Code
required
string
nullable
Message
required
string
nullable
Target
string
nullable
Field
string
nullable
Metadata
object
key
additional properties
string
nullable
Type
integer format: int32
Allowed values: 0 1 2
Severity
integer format: int32
Allowed values: 0 1 2
Success
boolean
Example
{
"Data": {
"Options": [
{
"Kind": 0,
"Reference": {
"Special": 0
},
"FieldType": 0,
"ReferenceDeleteBehavior": 0,
"FilterOperators": [
0
],
"FilterVariables": [
0
]
}
]
},
"Errors": [
{
"Type": 0,
"Severity": 0
}
],
"Warnings": [
{
"Type": 0,
"Severity": 0
}
]
}