Telyzer publishes a read-only OData v4 feed that Excel and Power BI can open directly. Your calls arrive as tables you can pivot, chart and refresh, without exporting files. The feed is part of API access, available on the Business and Enterprise plans and during your trial.
1. Create an API key
Open API & webhooks → New key, name it (for example “Power BI refresh”) and choose its access:
- call records (numbers masked) for the
Callstable; - reports and exports for the other tables;
- show full phone numbers if the people using the workbook may see them.
Copy the key when it is shown: it is shown only once. The Excel and Power BI card on the same page shows your Data feed address, https://app.telyzer.com/odata/v1.
Important: An API key belongs to the organization, not to a person: it is not limited to a member's sites or departments. Give feed keys only to people who may see every call, and Revoke a key you no longer use.
2. Connect Excel or Power BI
| Step | Excel | Power BI Desktop |
|---|---|---|
| Open the feed | Data tab → Get Data → From Other Sources → From OData Feed. | Get data → OData feed. |
| Address | Paste the data feed address and select OK. | The same. |
| Sign in | Choose Basic. User name apikey, password your API key. | The same. |
| Pick tables | Tick the tables you want, for example Calls and DailySummary, then Load. | The same. |
Refresh the query whenever you want new calls.
Tables
| Table | One row per | Columns |
|---|---|---|
Calls | Call (transfers folded into one conversation) | Id, StartUtc, LocalDate, LocalTime, LocalHour, SiteId, Site, Direction, Outcome, Extension, ExtensionName, Department, Number, Contact, Category, Region, Trunk, TrunkName, AccountCode, RoutedByType, RoutedByName, RingSeconds, TalkSeconds, HoldSeconds, Segments, AfterHours, Cost, CostVat, OffPeak, Currency |
DailySummary | Day, site and direction | Date, SiteId, Site, Direction, Calls, Answered, Missed, AfterHours, TalkSeconds, RingSeconds, Cost |
Extensions | Extension | Id, SiteId, Site, Number, Name, Department, Status, LastSeenUtc |
Sites | Site | Id, Name, Country, Timezone, Status |
Departments | Department | Id, Name, AnswerWithinSeconds, AnswerTargetPercent |
LocalDate, LocalTime and LocalHour are the wall-clock time at the call's site; StartUtc is UTC. Costs are the estimate from your tariff (see Call costs).
Large histories and query options
- Rows arrive in pages of 5,000; Excel and Power BI follow the pages automatically.
- The feed understands what Excel and Power BI send:
$select,$filter(eq,ne,gt,ge,lt,le,and,or,not,contains,startswith,endswith),$orderby,$top,$skipand$count. Text matching is case-sensitive. - A step the feed can't do (for example grouping) returns a clear message; remove that step from the query, or apply it after the data has loaded.
- Without show full phone numbers, the
Numbercolumn is masked and can't be filtered or sorted on. - Each key can make up to 300 requests a minute, like the rest of the API.