Skip to content

Execute one section (or blocks of one section) of a visible published report.

POST
/api/workspace/reporting/reports/{reportDefinitionId}/execute
curl --request POST \
--url https://example.com/api/workspace/reporting/reports/example/execute \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '{ "SectionId": "example", "Filters": { "additionalProperty": "example" }, "Blocks": [ { "SectionId": "example", "BlockId": "example", "Page": { "PageNumber": 1, "PageSize": 1 }, "Sort": { "FieldKey": "example", "Direction": 1 } } ] }'
reportDefinitionId
required
string
access_token
string

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

Runtime report execution request for one section.

object
SectionId

Required section to execute, as stored in the published document (a section saved without an id is section-{n}); viewers see one section at a time. A missing or unknown section returns reporting.report.sections.notFound.

string
nullable
Filters

Values of the section’s filters keyed by filter key.

object
key
additional properties
Blocks

Optional block requests inside the section. When omitted, all section blocks execute.

Array<object>
nullable

Runtime execution request for one report block.

object
SectionId

Section id from the published report document; it must equal the request’s SectionId.

string
nullable
BlockId

Block id from the published report section.

string
nullable
Page

Represents a paging request for table and list DataSource outputs.

object
PageNumber
integer format: int32
PageSize
integer format: int32
Sort

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 report batch execution result.

object
ReportId

Report definition id.

string
nullable
ReportKey

Report key.

string
nullable
VersionNumber

Published version number executed.

integer format: int32
Blocks

Per-block execution results.

Array<object>
nullable

Runtime execution result for one report block.

object
SectionId

Section id from the published report document.

string
nullable
BlockId

Block id from the published report section.

string
nullable
Success

Whether block 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 block 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 block 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": {
"Blocks": [
{
"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 report batch execution result.

object
ReportId

Report definition id.

string
nullable
ReportKey

Report key.

string
nullable
VersionNumber

Published version number executed.

integer format: int32
Blocks

Per-block execution results.

Array<object>
nullable

Runtime execution result for one report block.

object
SectionId

Section id from the published report document.

string
nullable
BlockId

Block id from the published report section.

string
nullable
Success

Whether block 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 block 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 block 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": {
"Blocks": [
{
"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 report batch execution result.

object
ReportId

Report definition id.

string
nullable
ReportKey

Report key.

string
nullable
VersionNumber

Published version number executed.

integer format: int32
Blocks

Per-block execution results.

Array<object>
nullable

Runtime execution result for one report block.

object
SectionId

Section id from the published report document.

string
nullable
BlockId

Block id from the published report section.

string
nullable
Success

Whether block 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 block 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 block 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": {
"Blocks": [
{
"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
}
]
}