# How to get email column

**URL:** <https://community.piwik.pro/t/how-to-get-email-column/2326>\
**Category:** API & integrations\
**Created:** [June 3, 2023, 4:32am UTC](https://community.piwik.pro/t/how-to-get-email-column/2326 "2023-06-03T04:32:39Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![chohan](https://avatars.discourse-cdn.com/v4/letter/c/9dc877/32.png) [@chohan](https://community.piwik.pro/u/chohan)\
**Post date:** [June 3, 2023, 4:32am UTC](https://community.piwik.pro/t/how-to-get-email-column/2326/1 "2023-06-03T04:32:39Z")

</div>

Hi, I want to get the email column, which API will be used?  
…/api/analytics/v1/query/? session? or events,  
and what column id will be used to get the data using my payload.  
Thanks

---

<div class="post-metadata">

**Author:** ![anthonybartczak](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/anthonybartczak/32/2430_2.png) [@anthonybartczak](https://community.piwik.pro/u/anthonybartczak)\
**Post date:** [June 5, 2023, 5:44am UTC](https://community.piwik.pro/t/how-to-get-email-column/2326/2 "2023-06-05T05:44:43Z")

</div>

Hi chohan!

Do you mean the user ID column? If so, it’s available in both event and session raw data API.

---

<div class="post-metadata">

**Author:** ![chohan](https://avatars.discourse-cdn.com/v4/letter/c/9dc877/32.png) [@chohan](https://community.piwik.pro/u/chohan)\
**Post date:** [June 5, 2023, 1:24pm UTC](https://community.piwik.pro/t/how-to-get-email-column/2326/3 "2023-06-05T13:24:54Z")

</div>

Hello Anthonybartczak  
No I mean the email address of the user that i store in custom\_event\_name  
but i want to know to extract it from the data present in that column (custom\_event\_name).  
Thanks