# Export Zoom Video Calls Stats with Email

**URL:** <https://devforum.zoom.us/t/export-zoom-video-calls-stats-with-email/93382>\
**Category:** API and Webhooks\
**Created:** [August 14, 2023, 7:37pm UTC](https://devforum.zoom.us/t/export-zoom-video-calls-stats-with-email/93382 "2023-08-14T19:37:42Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![dbernier](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/dbernier/32/50414_2.png) [@dbernier](https://devforum.zoom.us/u/dbernier)\
**Post date:** [August 14, 2023, 7:37pm UTC](https://devforum.zoom.us/t/export-zoom-video-calls-stats-with-email/93382/1 "2023-08-14T19:37:42Z")

</div>

Hello trying to use the PowerShell Gallery with Zoom Video to export outbound calls. The reason being I need to export all our call logs into an excel spreadsheet with our callers emails in order to work with our PowerBI reports.

Currently I cannot get over the error below, Invoke-ZoomRestMethod : The remote server returned an error: (400) Bad Request. . I made sure the ZoomAPI Scope has all 125 scopes. Other commands do work but Get-ZoomTelephoneReports -From ‘2023-08-01’ -To ‘2023-08-13’ gives me this error.

---

<div class="post-metadata">

**Author:** ![dbernier](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/dbernier/32/50414_2.png) [@dbernier](https://devforum.zoom.us/u/dbernier)\
**Post date:** [August 14, 2023, 7:39pm UTC](https://devforum.zoom.us/t/export-zoom-video-calls-stats-with-email/93382/2 "2023-08-14T19:39:21Z")

</div>

Get-ZoomTelephoneReports -From ‘2023-08-01’ -To ‘2023-08-13’ - Does not Work

(Get-ZoomUsers -PageSize 300 -pagenumber 2 -status active).Email - Does Work

---

<div class="post-metadata">

**Author:** ![gianni.zoom](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/gianni.zoom/32/32523_2.png) [@gianni.zoom](https://devforum.zoom.us/u/gianni.zoom)\
**Post date:** [August 14, 2023, 10:42pm UTC](https://devforum.zoom.us/t/export-zoom-video-calls-stats-with-email/93382/3 "2023-08-14T22:42:09Z")

</div>

Hi @dbernier ,

Can you please clarify your workflow? What is the full request code you’re submitting (with sensitive info obscured)?

---

<div class="post-metadata">

**Author:** ![dbernier](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/dbernier/32/50414_2.png) [@dbernier](https://devforum.zoom.us/u/dbernier)\
**Post date:** [August 14, 2023, 10:56pm UTC](https://devforum.zoom.us/t/export-zoom-video-calls-stats-with-email/93382/5 "2023-08-14T22:56:17Z")

</div>

Thank you @gianni.zoom for getting back to me on this. Here is the script below

Install-Module PSZoom  
Import-Module PSZoom  
Connect-PSZoom -AccountID \*\*\*\* -ClientID \*\*\*\* -ClientSecret \*\*\*\*

Get-ZoomTelephoneReports -From ‘2023-08-01’ -To ‘2023-08-13’

Invoke-ZoomRestMethod : The remote server returned an error: (400) Bad Request.  
At C:\Program Files\WindowsPowerShell\Modules\PSZoom\2.0.3.0\Public\Reports\Get-ZoomTelephoneReports.ps1:130 char:25

- … $response = Invoke-ZoomRestMethod -Uri $request.Uri -Method GET
- 

```
                  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

```

  - CategoryInfo : InvalidOperation: ([https://api.zoo](https://api.zoo)…0&page\_number=1:) [Write-Error], WriteErrorException
  - FullyQualifiedErrorId : 400,Invoke-ZoomRestMethod

---

<div class="post-metadata">

**Author:** ![dbernier](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/dbernier/32/50414_2.png) [@dbernier](https://devforum.zoom.us/u/dbernier)\
**Post date:** [August 14, 2023, 10:59pm UTC](https://devforum.zoom.us/t/export-zoom-video-calls-stats-with-email/93382/6 "2023-08-14T22:59:37Z")

</div>

Just trying to gather call reports and export them into an excel and have their emails listed inside the excel. The Call Logs from the web browser only exports with users full names and their extension number right after that. Would prefer usernames instead.

Export Excel from console looks like this

| NO. | Direction | From | To | Forward to | Device | Time | Result | Path | Duration (hh:mm:ss) | Client Code | Department | Cost Center | Charge | End-to-End Encryption | FAC Required |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| 1 | Outbound | John Smith - EXT 843 | 123456 | | Windows\_Client(5.15.3.18551) | 8/11/2023 14:18 | Call Connected | PSTN | 0:00:08 | – | Product | | $0.06 | No | No |

---

<div class="post-metadata">

**Author:** ![dbernier](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/dbernier/32/50414_2.png) [@dbernier](https://devforum.zoom.us/u/dbernier)\
**Post date:** [August 14, 2023, 11:01pm UTC](https://devforum.zoom.us/t/export-zoom-video-calls-stats-with-email/93382/8 "2023-08-14T23:01:32Z")

</div>

Would prefer to have that Username somewhere in the exported reports so our call logs work with our PowerBI reports with Microsoft. Figure I can use PowerShell to export the logs as I need it.

| NO. | Direction | From | To | Forward to | Device | Time | Result | Path | Duration (hh:mm:ss) | Client Code | Department | Cost Center | Charge | End-to-End Encryption | FAC Required |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| 1 | Outbound | [jsmith@companyemail.com](mailto:jsmith@companyemail.com) | 123456 | | Windows\_Client(5.15.3.18551) | 8/11/2023 14:18 | Call Connected | PSTN | 0:00:08 | – | Product | | $0.06 | No | No |

---

<div class="post-metadata">

**Author:** ![gianni.zoom](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/gianni.zoom/32/32523_2.png) [@gianni.zoom](https://devforum.zoom.us/u/gianni.zoom)\
**Post date:** [August 14, 2023, 11:19pm UTC](https://devforum.zoom.us/t/export-zoom-video-calls-stats-with-email/93382/9 "2023-08-14T23:19:29Z")

</div>

Hi @dbernier ,

Please send the exact API endpoint you’re querying. I’m not seeing GET Telephone Reports under Zoom Phone \> Reports:

 ![image](https://us1.discourse-cdn.com/flex016/uploads/zoomdeveloper/original/3X/7/e/7eb8baeddd5f62c74af9f3d664a973f9758c37fd.png)

Thanks!

---

<div class="post-metadata">

**Author:** ![dbernier](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/dbernier/32/50414_2.png) [@dbernier](https://devforum.zoom.us/u/dbernier)\
**Post date:** [August 15, 2023, 12:31am UTC](https://devforum.zoom.us/t/export-zoom-video-calls-stats-with-email/93382/10 "2023-08-15T00:31:40Z")

</div>

Here is the PowerShell commands I found [PowerShell Gallery | PSZoom 2.0.3.0](https://www.powershellgallery.com/packages/PSZoom/2.0.3.0)

---

<div class="post-metadata">

**Author:** ![gianni.zoom](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/gianni.zoom/32/32523_2.png) [@gianni.zoom](https://devforum.zoom.us/u/gianni.zoom)\
**Post date:** [August 16, 2023, 8:23pm UTC](https://devforum.zoom.us/t/export-zoom-video-calls-stats-with-email/93382/11 "2023-08-16T20:23:15Z")

</div>

Hi @dbernier ,

Can you please map that to Zoom’s official API documentation? PSZoom is not officially supported by Zoom.

The creator of it has previously posted here though:

> [@PSZoom - A Powershell module for Zoom's REST API](https://devforum.zoom.us/t/pszoom-a-powershell-module-for-zooms-rest-api/6490/12):
>
> I am running a query to pull all users and am getting a 401 unauthorized. I am an admin in Zoom (not the owner). I just pulled the secret and key from Zoom admin console under personal/settings. We have over 800 users and I have tried #In Powershell it’s explicitly written as a string for the key and secret $apiKey = ‘’ $apiSecret = '’ Get-ZoomUsers -AllPages -ApiKey $apiKey -ApiSecret $apiSecret Get-ZoomUsers : The remote server returned an error: (401) Unauthorized. At line:1 char:1 …

Here is his Github: [Issues · JosephMcEvoy/PSZoom · GitHub](https://github.com/JosephMcEvoy/PSZoom/issues)

---

<div class="post-metadata">

**Author:** ![dbernier](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/dbernier/32/50414_2.png) [@dbernier](https://devforum.zoom.us/u/dbernier)\
**Post date:** [August 16, 2023, 8:56pm UTC](https://devforum.zoom.us/t/export-zoom-video-calls-stats-with-email/93382/12 "2023-08-16T20:56:38Z")

</div>

Thank you for that Clarification explains it. Back to the drawing boards then on how to export call logs with the username/email instead of the persons full name.

Thank you!!

---

<div class="post-metadata">

**Author:** ![gianni.zoom](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/gianni.zoom/32/32523_2.png) [@gianni.zoom](https://devforum.zoom.us/u/gianni.zoom)\
**Post date:** [August 16, 2023, 9:08pm UTC](https://devforum.zoom.us/t/export-zoom-video-calls-stats-with-email/93382/13 "2023-08-16T21:08:56Z")

</div>

Oh @dbernier ,

Would either of these endpoints satisfy the info you’re seeking?:

> **[Zoom Phone API](https://developers.zoom.us/docs/api/rest/reference/phone/methods/#operation/accountCallLogs)**
>
> API Reference for /docs/api/rest/reference/phone/methods

> **[Zoom Phone API](https://developers.zoom.us/docs/api/rest/reference/phone/methods/#operation/phoneUserCallLogs)**
>
> API Reference for /docs/api/rest/reference/phone/methods

> **[Zoom Meeting API](https://developers.zoom.us/docs/api/rest/reference/zoom-api/methods/#operation/reportTelephone)**
>
> API Reference for /docs/api/rest/reference/zoom-api/methods

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex016/uploads/zoomdeveloper/original/3X/6/1/614bdd549b610bbaa46ff934617683a02bdaa03c.png) [@system](https://devforum.zoom.us/u/system)\
**Post date:** [August 17, 2023, 9:09pm UTC](https://devforum.zoom.us/t/export-zoom-video-calls-stats-with-email/93382/14 "2023-08-17T21:09:20Z")

</div>

Closed on August 17, 2023, 9:09pm UTC

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
