Actions462
- Users Actions
- Download Greeting
- Batch Delete
- Get Call Log
- Get Phone Registrars
- Reboot Phone
- Reprovision Phone
- Upgrade Phone
- Generate Prov Link
- Has Duplicated Email
- Get Duplicated Emails
- Send Welcome Email
- List Groups
- List Forwarding Profiles
- Get Phone Secret
- Regenerate
- Regenerate Passwords
- Export Extensions
- Get Phone Registrar
- Bulk Update
- Get User
- Update User
- Delete User
- List Greetings
- Make Call User Record Greeting
- Make Call
- Get Monitor Status
- Set Monitor Status
- Multi User Update
- Reprovision All Phones
- Get Multi Edit Greetings
- Multi Delete Greeting
- Get User By Number
- List User
- Create User
- Active Calls Actions
- Activity Log Actions
- Anti Hacking Settings Actions
- Backups Actions
- Black List Numbers Actions
- Blocklist Actions
- Call Cost Settings Actions
- Call Flow Apps Actions
- Call Flow Scripts Actions
- Call History View Actions
- Call Parking Settings Actions
- Call Types Settings Actions
- CDR Settings Actions
- Chat History View Actions
- Chat Log Settings Actions
- Contacts Actions
- Chat Messages History View Actions
- Codecs Settings Actions
- Conference Settings Actions
- Console Restrictions Actions
- Countries Actions
- Country Codes Actions
- CRM Integration Actions
- Crm Templates Actions
- Custom Prompts Actions
- Data Connector Settings Actions
- Defs Actions
- Device Infos Actions
- Dial Code Settings Actions
- Did Numbers Actions
- DN Properties Actions
- E 164 Settings Actions
- Email Template Actions
- Emergency Geo Locations Actions
- Fax Actions
- Fax Server Settings Actions
- Firewall Actions
- Firmwares Actions
- Fxs Actions
- General Settings For Pbx Actions
- Google Settings Actions
- Emergency Notifications Settings Actions
- Event Logs Actions
- Fxs Templates Actions
- General Settings For Apps Actions
- Groups Actions
- Holidays Actions
- Hotel Services Actions
- Microsoft 365 Integration Actions
- My Group Actions
- Inbound Rules Actions
- Last Cdr And Chat Message Timestamp Actions
- License Status Actions
- Logging Settings Actions
- Microsoft 365 Teams Integration Actions
- Music On Hold Settings Actions
- My Tokens Actions
- My User Actions
- Network Interfaces Actions
- Network Settings Actions
- Notification Settings Actions
- Office Hours Actions
- Outbound Rules Actions
- Parameters Actions
- Parkings Actions
- Peers Actions
- Phone Book Settings Actions
- Phone Logos Actions
- Phones Settings Actions
- Phone Templates Actions
- Playlists Actions
- Prompt Sets Actions
- Purge Settings Actions
- Queues Actions
- Receptionists Actions
- Report Queue Failed Callbacks Actions
- Recordings Actions
- System Status Actions
- Remote Archiving Settings Actions
- Report Abandoned Chats Statistics Actions
- Report Abandoned Queue Calls Actions
- Report Agent Login History Actions
- Report Agents In Queue Statistics Actions
- Report Audit Log Actions
- Report Average Queue Waiting Time Actions
- Report Breaches Sla Actions
- Report Call Cost By Extension Group Actions
- Report Call Distribution Actions
- Report Call Log Data Actions
- Report Detailed Queue Statistics Actions
- Report Extensions Statistics By Ring Groups Actions
- Report Extension Statistics By Group Actions
- Report Extension Statistics Actions
- Report Inbound Rules Actions
- Report Queue Agents Chat Statistics Actions
- Report Queue Agents Chat Statistics Totals Actions
- Report Queue Answered Calls By Wait Time Actions
- Report Queue An Un Calls Actions
- Report Queue Callbacks Actions
- Report Queue Chat Performance Actions
- Report Statistic Sla Actions
- Report Queue Performance Overview Actions
- Report Queue Performance Totals Actions
- Report Ring Group Statistics Actions
- Sbcs Actions
- Secure Sip Settings Actions
- Report Team Queue General Statistics Actions
- Scheduled Reports Actions
- Ring Groups Actions
- Security Tokens Actions
- Service Principals Actions
- Services Actions
- Sip Devices Actions
- Directories Actions
- Tenant Properties Actions
- Trunks Actions
- Trunk Templates Actions
- Updates Actions
- Voicemail Settings Actions
- Website Links Actions
- Report Inbound Calls Actions
- Report Outbound Calls Actions
- Report User Activity Actions
Overview
This node interacts with the 3CX telephony system to retrieve extension statistics data for a specified period and filter criteria. It is useful for generating reports on call activity, usage patterns, or performance metrics related to specific extensions within an organization’s phone system.
Typical use cases include:
- Monitoring call volumes and durations for selected extensions over a given time frame.
- Filtering statistics by extension identifiers and call areas to analyze specific segments.
- Applying query options like sorting, filtering, and pagination to customize the report output.
For example, a user might request extension statistics from January 1 to January 31, filtered to a particular extension group, and sorted by call duration to identify the busiest extensions.
Properties
| Name | Meaning |
|---|---|
| Period From | Start date/time of the reporting period (usage: periodFrom={periodFrom}). |
| Period To | End date/time of the reporting period (usage: periodTo={periodTo}). |
| Extension Filter | Filter string to specify which extensions to include in the report (usage: extensionFilter={extensionFilter}). |
| Call Area | Numeric identifier representing the call area to filter statistics by (usage: callArea={callArea}). |
| Options | Additional query options to refine the results: |
| - Top | Show only the first n items. |
| - Skip | Skip the first n items. |
| - Search | Search items by search phrases. |
| - Filter | Filter items by property values (e.g., State eq 'Connected'). |
| - Count | Include count of items (boolean). |
| - Select | Select specific properties to be returned (e.g., Id,Name). |
| - Orderby | Order items by property values (e.g., Name desc, CreatedAt asc). |
| - Expand | Expand related entities (e.g., RelatedEntity1,RelatedEntity2). |
Output
The node outputs JSON data containing the extension statistics matching the specified filters and options. The structure typically includes statistical fields such as call counts, durations, extension identifiers, and other relevant metrics depending on the API response.
If binary data were involved (not indicated here), it would represent files or media related to the statistics, but this node focuses on JSON data output.
Dependencies
- Requires an API key credential for authenticating with the 3CX telephony system.
- Needs the base URL of the 3CX server configured in credentials.
- The node uses HTTP requests to the 3CX API endpoint
/xapi/v1with appropriate headers.
Troubleshooting
- Missing or invalid credentials: Ensure that the API key and server URL are correctly set up in the node credentials.
- Invalid date formats: The
Period FromandPeriod Tomust be valid date strings accepted by the 3CX API. - Incorrect filter syntax: Filters and query options must follow the expected OData-like syntax; otherwise, the API may return errors.
- Empty results: Check that the extension filter and call area parameters match existing data; no matches will result in empty output.
- API connectivity issues: Verify network access to the 3CX server and that the server URL is correct without trailing slashes.
Links and References
- 3CX API Documentation
- OData Query Options (for understanding
$filter,$orderby, etc.)