ODBC Driver for Twilio

Build 26.0.9770

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.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770