How to get email.from from inbound action to transform script

[Deepthi13]

Hi team, I need email.from address from inbound to transform script? 
i am also trying to write a business rule on sys_email table for this and get current.user_id. but how can i get that business rule value in transform script. please suggest.

[Mark Manders]

What are you trying to do? Are you using your emails as data sources? Why not just handle them with inbound actions or inbound email flows? 

[Deepthi13]

hi mark @Mark Manders , @Ankur Bawiskar  requirement is we get an email with attachment to our instance, where we are processing that excel data into data source and import set and finally importing into target table. so the newly imported data created_by is updating as "system" but where client wants that created by need to be updated as the user who sends the email.

[Mark Manders]

How are you processing your incoming email into the data source? If you are creating the import set from there, you can add a field to the import set table like 'EmailSender' and have the inbound script fill that field with the sender and use your transform map to fill the source.EmailSender as created by on the target table.