Change the DATA format

[TheG]

Heeey Community,

Actually after enrichment with Dropcontact node i receive the email data “messed-up” i want to clean it up and keep only the email adress.

(Pics below)

[MutedJam]

Hi @TheG, good to see you here on the forum!

So you’d like to extract the email address in this example from an array inside the actual Email field? You could try an expression like {{$json["Email"][0]["email"]}}:

Example Workflow:

Result:

[TheG]

Thank you Jam, it works

[MutedJam]

Awesome, thanks for confirming!