To capture sys_email data before insert

[Anjan 2025]

Hi,

I want to fetch raw email data before it is inserted in sys_email table. I want to fetch From address of the email before ServiceNow look for user in sys_user table and populate User ID field. How can i achieve this?

[KrishnaMohan]

Hi @Anjan 2025 

Could you share some details about what you're trying to achieve or use case?

Regards,
Krishnamohan

[RaghavSh]

your requirement can be achieved by before insert BR on sys_email table but since it is an OOB table handling inbound/outbound emails it is not recommended at all.

Doing such customisation can break email flows and is not recommended.

[Bhuvan · Accepted solution]

@Anjan 2025 

System does this out of box by looking the sys_user table and populating the user ID if email ID of incoming email matches with user record. If you want to add a custom logic, you can create before BR on sys_email table and manipulate the data before creation.

Make sure you do not impact any of the existing functionalities as Inbound Actions and Inbound Flows might be created on incoming email.

If this helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[Anjan 2025]

Hi Bhuvan,

Thanks, yes I used before businesses rule  to modify user details.It worked for me.