How to get EmailAddressId information from Reporting

Content

Hello experts,

I should massively update (not create new records) worker email addresses by HDL.

I'm using the following format:

METADATA|PersonEmail|PersonNumber|EmailAddress|PersonId|EmailType|DateFrom

but without the EmailAddressId I cannot successfully update worker email address, as it seems to be a mandatory field.

How can I get that information? In OTBI the EmailAddressId column doesn't exist. In case, is there another way to update worker email records without that information?

Thanks in advance for your time!

Kind Regards,

Valerio