StudioFlowExecutionReport
Query the Studio Flow Execution Report via the Explore API. Provides step-level detail for each interaction in a studio flow. Up to a month of data per request.
Select
The StudioFlowExecutionReport is a report view. The connector processes the following pseudo-columns server-side; any other WHERE clause conditions are evaluated client-side.
- TimespanFrom supports the following operator: >=
- TimespanTo supports the following operator: <
- Timezone supports the following operator: =
If TimespanFrom and TimespanTo are omitted, the connector defaults the time range to the last 31 days.
For example, the following query is processed server-side:
SELECT * FROM StudioFlowExecutionReport WHERE TimespanFrom >= '2025-01-01' AND TimespanTo < '2025-02-01'
Columns
| Name | Type | References | Description |
| FlowExecutionId [KEY] | String | The unique identifier of the flow execution. | |
| StepExecutionOrder [KEY] | Int | The order of step execution within the flow. | |
| CallSid | String | The SID of the call. | |
| InteractionId | String |
CallsReport.InteractionId | The unique identifier of the interaction. |
| DestinationNumber | String | The destination phone number. | |
| OriginNumber | String | The origin phone number. | |
| FlowName | String | The name of the studio flow. | |
| FlowId | String | The unique identifier of the studio flow. | |
| ComponentTitle | String | The title of the flow component. Example values: Incoming call, Play Audio. | |
| StepName | String | The name of the step in the flow. | |
| Exit | String | The exit condition of the step. Example values: ok. | |
| TimeInStep | Double | The time spent in the step. | |
| Timestamp | Datetime | The timestamp of the step execution. | |
| FlowExecutionFinishedTime | Datetime | The time when the entire flow execution finished. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| TimespanFrom | Datetime | The start date for the report timespan. | |
| TimespanTo | Datetime | The end date for the report timespan. | |
| Timezone | String | The IANA timezone for the report timespan. |