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 download call cost reports grouped by extension groups. It is useful for organizations that want to analyze telephony expenses over specific periods, filtered by extension groups and call classifications. For example, a telecom administrator can use this node to generate detailed cost reports for different departments or teams within a company, helping to monitor and optimize communication costs.
Properties
| Name | Meaning |
|---|---|
| Period From | The start date/time of the reporting period (format as required by the API). |
| Period To | The end date/time of the reporting period. |
| Group Filter | Filter to specify which extension groups to include in the report. |
| Call Class | Numeric value representing the classification of calls to include (e.g., internal, external). |
| Client Time Zone | Time zone context for the report data, ensuring correct time interpretation. |
| Options | Additional query options to refine the report output: |
| - Top | Limit the number of items returned to the first n entries. |
| - Skip | Skip the first n items in the result set. |
| - Search | Search phrase(s) to filter items by text matching. |
| - Filter | OData-style filter expression to narrow down results by property values. |
| - Count | Boolean flag to include the count of total items in the response. |
| - Select | Comma-separated list of properties to return for each item. |
| - Orderby | Property names and directions to order the results (e.g., "Name desc"). |
| - Expand | Related entities to expand inline in the response. |
Output
The node outputs JSON data containing the call cost report grouped by extension group according to the specified filters and parameters. The structure typically includes details such as extension group identifiers, call cost summaries, and possibly metadata about the report period and applied filters.
If binary data is included (not indicated explicitly here), it would represent downloadable report files or attachments related to the call cost data.
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/v1to fetch report data.
Troubleshooting
- Invalid Date Range: Ensure "Period From" is earlier than "Period To". Incorrect ranges may cause errors or empty results.
- Authentication Errors: Verify that the API key credential and server URL are correctly configured and valid.
- Filter Syntax Issues: When using advanced filtering (
$filter), ensure the syntax matches OData standards expected by the API. - Empty Results: Check that the group filter and call class parameters match existing data; otherwise, no records will be returned.
- API Limits: Using large
$topvalues or complex queries might hit API rate limits or timeout issues.