Skip to content

Execute widgets from one visible published dashboard.

POST
/api/workspace/reporting/dashboards/{dashboardDefinitionId}/execute
curl --request POST \
--url https://example.com/api/workspace/reporting/dashboards/example/execute \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '{ "Filters": { "additionalProperty": "example" }, "WidgetIds": [ "example" ], "Pages": { "additionalProperty": { "PageNumber": 1, "PageSize": 1 } }, "Sorts": { "additionalProperty": { "FieldKey": "example", "Direction": 1 } } }'
dashboardDefinitionId
required
string
access_token
string

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

Runtime dashboard widget execution request.

object
Filters

Shared dashboard filter values keyed by filter key.

object
key
additional properties
WidgetIds

Optional widget ids to execute. When omitted, all widgets execute.

Array<string>
nullable
Pages

Optional widget page requests keyed by widget id.

object
key
additional properties

Represents a paging request for table and list DataSource outputs.

object
PageNumber
integer format: int32
PageSize
integer format: int32
Sorts

Optional widget sort requests keyed by widget id.

object
key
additional properties

Represents a sort request for table and list DataSource outputs.

object
FieldKey
string
nullable
Direction

Defines sort direction for table and list DataSource requests.

integer format: int32
Allowed values: 1 2

OK

Media typeapplication/json
object
Data

Runtime dashboard batch execution result.

object
DashboardId

Dashboard definition id.

string
nullable
DashboardKey

Dashboard key.

string
nullable
VersionNumber

Published version number executed.

integer format: int32
Widgets

Per-widget execution results.

Array<object>
nullable

Runtime execution result for one dashboard widget.

object
WidgetId

Widget id from the published dashboard document.

string
nullable
Success

Whether widget execution succeeded.

boolean
Execution

Successful data-source execution result plus source metadata.

object
CatalogItemId

Catalog item identifier.

string
nullable
StableId

Stable data-source identifier.

string
nullable
Key

Data-source key.

string
nullable
SchemaFingerprint

Descriptor fingerprint used for this execution.

string
nullable
Result

Represents the result of a DataSource execution.

object
Shape

Defines the shape returned by a DataSource execution.

integer format: int32
Allowed values: 1 2 3 4 5 6 7
Payload
Page

Represents paging metadata returned by a table or list DataSource.

object
PageNumber
integer format: int32
PageSize
integer format: int32
TotalCount
integer format: int64
nullable
HasMore
boolean
Warnings
Array<object>
nullable

Represents a warning emitted by DataSource execution.

object
Code
string
nullable
Message
string
nullable
FieldKey
string
nullable
Links
Array<object>
nullable

Represents a typed link emitted by DataSource execution.

object
TargetKind

Defines link target families that can be emitted by DataSources.

integer format: int32
Allowed values: 1 2 3 4 5 6 7 8 9 10
TargetId
string
nullable
Label
string
nullable
RouteValues
object
key
additional properties
string
QueryValues
object
key
additional properties
string
ExecutedAtUtc
string format: date-time
Errors

Controlled widget execution 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

Controlled widget execution 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
Fields

Output fields of the executed source (names, value types, units) for column titles and workspace-formatted values. Null for a failed execution, and also for a successful one whose source changed its schema or disappeared meanwhile.

Array<object>
nullable

Describes a field in a DataSource output payload.

object
Key
string
nullable
ValueType

Defines a logical field value type in a DataSource output schema.

integer format: int32
Allowed values: 1 2 3 4 5 6 7 8 9
DisplayName

Represents display text with an invariant default value and optional locale-specific translations.

object
Default

The invariant default text.

string
nullable
Translations

Optional locale-specific translations keyed by locale code.

object
key
additional properties
string
Unit
string
nullable
Format
string
nullable
Nullable
boolean
Sortable
boolean
Filterable
boolean
SemanticRole
string
nullable
LinkRole
string
nullable
Drilldowns

Fields whose rows open a record and the record kind, such as a Task; null whenever Fields is null.

Array<object>
nullable

Describes a drilldown/link target that can be produced by a DataSource.

object
TargetKind

Defines link target families that can be emitted by DataSources.

integer format: int32
Allowed values: 1 2 3 4 5 6 7 8 9 10
FieldKey
string
nullable
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": {
"Widgets": [
{
"Execution": {
"Result": {
"Shape": 1,
"Links": [
{
"TargetKind": 1
}
]
}
},
"Errors": [
{
"Type": 0,
"Severity": 0
}
],
"Warnings": [
{
"Type": 0,
"Severity": 0
}
],
"Fields": [
{
"ValueType": 1
}
],
"Drilldowns": [
{
"TargetKind": 1
}
]
}
]
},
"Errors": [
{
"Type": 0,
"Severity": 0
}
],
"Warnings": [
{
"Type": 0,
"Severity": 0
}
]
}

Bad Request

Media typeapplication/json
object
Data

Runtime dashboard batch execution result.

object
DashboardId

Dashboard definition id.

string
nullable
DashboardKey

Dashboard key.

string
nullable
VersionNumber

Published version number executed.

integer format: int32
Widgets

Per-widget execution results.

Array<object>
nullable

Runtime execution result for one dashboard widget.

object
WidgetId

Widget id from the published dashboard document.

string
nullable
Success

Whether widget execution succeeded.

boolean
Execution

Successful data-source execution result plus source metadata.

object
CatalogItemId

Catalog item identifier.

string
nullable
StableId

Stable data-source identifier.

string
nullable
Key

Data-source key.

string
nullable
SchemaFingerprint

Descriptor fingerprint used for this execution.

string
nullable
Result

Represents the result of a DataSource execution.

object
Shape

Defines the shape returned by a DataSource execution.

integer format: int32
Allowed values: 1 2 3 4 5 6 7
Payload
Page

Represents paging metadata returned by a table or list DataSource.

object
PageNumber
integer format: int32
PageSize
integer format: int32
TotalCount
integer format: int64
nullable
HasMore
boolean
Warnings
Array<object>
nullable

Represents a warning emitted by DataSource execution.

object
Code
string
nullable
Message
string
nullable
FieldKey
string
nullable
Links
Array<object>
nullable

Represents a typed link emitted by DataSource execution.

object
TargetKind

Defines link target families that can be emitted by DataSources.

integer format: int32
Allowed values: 1 2 3 4 5 6 7 8 9 10
TargetId
string
nullable
Label
string
nullable
RouteValues
object
key
additional properties
string
QueryValues
object
key
additional properties
string
ExecutedAtUtc
string format: date-time
Errors

Controlled widget execution 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

Controlled widget execution 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
Fields

Output fields of the executed source (names, value types, units) for column titles and workspace-formatted values. Null for a failed execution, and also for a successful one whose source changed its schema or disappeared meanwhile.

Array<object>
nullable

Describes a field in a DataSource output payload.

object
Key
string
nullable
ValueType

Defines a logical field value type in a DataSource output schema.

integer format: int32
Allowed values: 1 2 3 4 5 6 7 8 9
DisplayName

Represents display text with an invariant default value and optional locale-specific translations.

object
Default

The invariant default text.

string
nullable
Translations

Optional locale-specific translations keyed by locale code.

object
key
additional properties
string
Unit
string
nullable
Format
string
nullable
Nullable
boolean
Sortable
boolean
Filterable
boolean
SemanticRole
string
nullable
LinkRole
string
nullable
Drilldowns

Fields whose rows open a record and the record kind, such as a Task; null whenever Fields is null.

Array<object>
nullable

Describes a drilldown/link target that can be produced by a DataSource.

object
TargetKind

Defines link target families that can be emitted by DataSources.

integer format: int32
Allowed values: 1 2 3 4 5 6 7 8 9 10
FieldKey
string
nullable
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": {
"Widgets": [
{
"Execution": {
"Result": {
"Shape": 1,
"Links": [
{
"TargetKind": 1
}
]
}
},
"Errors": [
{
"Type": 0,
"Severity": 0
}
],
"Warnings": [
{
"Type": 0,
"Severity": 0
}
],
"Fields": [
{
"ValueType": 1
}
],
"Drilldowns": [
{
"TargetKind": 1
}
]
}
]
},
"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

Runtime dashboard batch execution result.

object
DashboardId

Dashboard definition id.

string
nullable
DashboardKey

Dashboard key.

string
nullable
VersionNumber

Published version number executed.

integer format: int32
Widgets

Per-widget execution results.

Array<object>
nullable

Runtime execution result for one dashboard widget.

object
WidgetId

Widget id from the published dashboard document.

string
nullable
Success

Whether widget execution succeeded.

boolean
Execution

Successful data-source execution result plus source metadata.

object
CatalogItemId

Catalog item identifier.

string
nullable
StableId

Stable data-source identifier.

string
nullable
Key

Data-source key.

string
nullable
SchemaFingerprint

Descriptor fingerprint used for this execution.

string
nullable
Result

Represents the result of a DataSource execution.

object
Shape

Defines the shape returned by a DataSource execution.

integer format: int32
Allowed values: 1 2 3 4 5 6 7
Payload
Page

Represents paging metadata returned by a table or list DataSource.

object
PageNumber
integer format: int32
PageSize
integer format: int32
TotalCount
integer format: int64
nullable
HasMore
boolean
Warnings
Array<object>
nullable

Represents a warning emitted by DataSource execution.

object
Code
string
nullable
Message
string
nullable
FieldKey
string
nullable
Links
Array<object>
nullable

Represents a typed link emitted by DataSource execution.

object
TargetKind

Defines link target families that can be emitted by DataSources.

integer format: int32
Allowed values: 1 2 3 4 5 6 7 8 9 10
TargetId
string
nullable
Label
string
nullable
RouteValues
object
key
additional properties
string
QueryValues
object
key
additional properties
string
ExecutedAtUtc
string format: date-time
Errors

Controlled widget execution 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

Controlled widget execution 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
Fields

Output fields of the executed source (names, value types, units) for column titles and workspace-formatted values. Null for a failed execution, and also for a successful one whose source changed its schema or disappeared meanwhile.

Array<object>
nullable

Describes a field in a DataSource output payload.

object
Key
string
nullable
ValueType

Defines a logical field value type in a DataSource output schema.

integer format: int32
Allowed values: 1 2 3 4 5 6 7 8 9
DisplayName

Represents display text with an invariant default value and optional locale-specific translations.

object
Default

The invariant default text.

string
nullable
Translations

Optional locale-specific translations keyed by locale code.

object
key
additional properties
string
Unit
string
nullable
Format
string
nullable
Nullable
boolean
Sortable
boolean
Filterable
boolean
SemanticRole
string
nullable
LinkRole
string
nullable
Drilldowns

Fields whose rows open a record and the record kind, such as a Task; null whenever Fields is null.

Array<object>
nullable

Describes a drilldown/link target that can be produced by a DataSource.

object
TargetKind

Defines link target families that can be emitted by DataSources.

integer format: int32
Allowed values: 1 2 3 4 5 6 7 8 9 10
FieldKey
string
nullable
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": {
"Widgets": [
{
"Execution": {
"Result": {
"Shape": 1,
"Links": [
{
"TargetKind": 1
}
]
}
},
"Errors": [
{
"Type": 0,
"Severity": 0
}
],
"Warnings": [
{
"Type": 0,
"Severity": 0
}
],
"Fields": [
{
"ValueType": 1
}
],
"Drilldowns": [
{
"TargetKind": 1
}
]
}
]
},
"Errors": [
{
"Type": 0,
"Severity": 0
}
],
"Warnings": [
{
"Type": 0,
"Severity": 0
}
]
}