A query in Inbound email actions

[devservicenow k]

I am Creating Inbound email action and creating case Record.

After creating if the inbound email Domain is (eg,gmail.com).

the particular Account record with the (gmail.com ) to be selected and stored in Account field in that case Record, i have created the Script but it is not getting updated in the Case record, but in the Logs it is currectly giving the output.

suggest me what changes do i need to do 

[Saurav11]

Hello,

OOB account is a refence field can you try the below:-

(function runAction( /*GlideRecord*/ current, /*GlideRecord*/ event, /*EmailWrapper*/ email, /*ScopedEmailLogger*/ logger, /*EmailClassifier*/ classifier) {
current.u_insp_email = email.from;
var domain = email.from.split('@')[1];
gs.info("Name is: " + domain);

var gr = new GlideRecord('customer_account');
gr.addEncodedQuery('u_emailidCONTAINS' + domain);

gr.query();

if (gr.next()) {
current.account = gr.sys_id;
current.update();
gs.info("Name is2222: " + gr.sys_id);
gs.info("Name is111: " + current.account);
}
//current.u_insp_email = domain;
})(current, event, email, logger, classifier);

Please mark my answer as correct based on Impact.

[Saurav11]

Hello,

If my answer helped you can you also mark it as correct.

Thanks.

[devservicenow k]

I have still some features to be added after that, 

I

[Saurav11]

Hello,

The contact again is a reference field on account table please use the below script:-

(function runAction( /*GlideRecord*/ current, /*GlideRecord*/ event, /*EmailWrapper*/ email, /*ScopedEmailLogger*/ logger, /*EmailClassifier*/ classifier) {
current.u_insp_email = email.from;
var domain = email.from.split('@')[1];
gs.info("Name is: " + domain);

var gr = new GlideRecord('customer_account');
gr.addEncodedQuery('u_emailidCONTAINS' + domain);

gr.query();

if (gr.next()) {
current.account = gr.sys_id;;
current.update();
gs.info("Name is2222: " + gr.name);
gs.info("Name is111: " + current.account);

if(gr.contact==''){
var create = new GlideRecord('sys_user')
create.initialize();
create.insert();
create.email=email.from;
create.name=email.from;
gr.contact=create.sys_id;
gr.update();
}
}

//current.u_insp_email = domain;
})(current, event, email, logger, classifier);

Please mark my answer as correct based on Impact.