GenerateOutboundPhoneNumberReport
Generates a Voice Insights Outbound Phone Number Report and returns the report identifier. The report aggregates Voice Insights metrics for outbound calls, defaulting to the last 7 days when no time range is provided. The returned ReportId can be used with the OutboundPhoneNumberReport view to fetch the report data. Reports are available for 5 days after creation.
Stored Procedure-Specific Information
Generates a Voice Insights Outbound Phone Number Report and returns the report identifier. No parameters are required; by default the report covers the last 7 days. The returned ReportId can be used with the OutboundPhoneNumberReport view to retrieve the report data.The following example generates a report using default settings:
EXEC GenerateOutboundPhoneNumberReport
The following example generates a report for a specific time range:
EXEC GenerateOutboundPhoneNumberReport StartDatetime = '2024-10-01 00:00:00', EndDatetime = '2024-10-31 23:59:59'
The following example filters results by call state and limits the number of phone numbers in the report:
EXEC GenerateOutboundPhoneNumberReport StartDatetime = '2024-10-01 00:00:00', EndDatetime = '2024-10-31 23:59:59', CallState = 'completed,noanswer', Size = 10
Input
| Name | Type | Required | Description |
| StartDatetime | Datetime | False | Start date and time of the report in ISO 8601 format. If omitted, defaults to 7 days before EndDatetime. |
| EndDatetime | Datetime | False | End date and time of the report in ISO 8601 format. Cannot be in the future. If omitted, defaults to the current time. |
| Size | Integer | False | Maximum number of phone numbers to include in the report. |
| CallState | String | False | Comma-separated list of call states to filter by. |
| CallDirection | String | False | Comma-separated list of call directions to filter by. |
| CallType | String | False | Comma-separated list of call types to filter by. |
| TwilioRegions | String | False | Comma-separated list of Twilio region identifiers to filter by. |
| CallerCountryCode | String | False | Comma-separated list of ISO 3166-1 alpha-2 caller country codes to filter by. |
| CalleeCountryCode | String | False | Comma-separated list of ISO 3166-1 alpha-2 callee country codes to filter by. |
| Silent | Boolean | False | Silent call flag values to filter by. |
Result Set Columns
| Name | Type | Description |
| Success | String | Indicates whether the report was generated successfully. |
| ReportId | String | The unique report identifier. Use this value with the OutboundPhoneNumberReport view to fetch report data. |
| Status | String | The status of the report generation. Can be: created, running, or completed. |