Create catalog request through email inbound

jamesgo · ‎01-25-2014

I have a requirement to auto-create catalog request through email inbound action, my approach is to use the Cart API(any better solution?) in inbound action script, I set up the inbound on sc_req_item table but I am not doing a current.insert() otherwise it will double submit the request(as the order is already placed through Cart API), things working fine but one problem I don't find a way to attach the original inbound email to the Activity field, any idea?

Michael Kaufman · ‎01-27-2014

Here are some ideas:

Option 1: Add Message to Comments

Inbound Action: Create Requested Item

Table: sc_req_item

Condition: <your condition here>

Script:

createRequest();

function createRequest() {

var cart = new Cart();

// add in cart

var item = cart.addItem('8c2a069c242cb800839dec45b40a7496');

// set requested for

cart.setVariable(item, 'requested_for', '5136503cc611227c0183e96598c4f706');

cart.setVariable(item, 'request_short_description', email.subject.toString());

cart.setVariable(item, 'request_description', email.body_html);

cart.setVariable(item, 'request_type', 'others');

// set application

cart.setVariable(item, 'application', '3243d574bd05300071578913764fb117');

// set assignment group

cart.setVariable(item, 'assignment_group', '4769d53099266800d7ea6843423a4c2b');

cart.setVariable(item, 'priority', 'PR3');

var cartmsg = "received from: " + email.origemail + "\n\n" + email.body_text;

cart.setVariable(item,'comments',cartmsg);

var rc = cart.placeOrder();

}

Option 2: Generate without Cart API

Inbound Action: Create Requested Item

Table: sc_req_item

Condition: <your condition here>

Script:

createRequest();

function createRequest() {

//Create Request

var grRequest = new GlideRecord ("sc_request");

grRequest.initialize();

grRequest.requested_for = '5136503cc611227c0183e96598c4f706';

grRequest.short_description = email.subject.toString();

grRequest.description = "received from: " + email.origemail + "\n\n" + email.body_text;

var requestSysId = grRequest.insert();

//Create Request Item

current.requested_for = '5136503cc611227c0183e96598c4f706';

current.short_description = email.subject.toString();

current.description = "received from: " + email.origemail + "\n\n" + email.body_text;

current.cat_item = '8c2a069c242cb800839dec45b40a7496';

current.parent = requestSysId;

current.request = requestSysId;

current.request_type = 'others';

current.application= '3243d574bd05300071578913764fb117';

current.assignment_group='4769d53099266800d7ea6843423a4c2b';

current.priority= 'PR3';

current.insert();

}

I tested Option 2 and it did work for me. I used a different Catalog Item (Dev Laptop), because I didn't have your item in my catalog, but most everything else worked the same.

View solution in original post

emyrold · ‎03-27-2014

Hi Mike,

Thanks for standing up that article on creating requests...

Is there a way to easily add values to the variables defined on a "maintain item" ? without using the cart() api ?

In your two inbound action examples, the cart one you are setting values for variables, in the non-cart one you do not set any values to the variables.

Thanks,

-e

Michael Kaufman · ‎03-27-2014

If you use Example 3: Create Requested Items from Inbound Action without Cart in the article. You likely can use current.variables.<your_variable_name>. I haven't tried it, but it might work.

emyrold · ‎03-28-2014

ahhh... ok, I will give that a try... Thank you, -Erik

dheerajdadlani · ‎12-28-2015

Hi Mike,

I am trying to use option 1 i.e using Cart API().

My instance is domain separated.

So in your above code provided it runs perfectly fine but creates an REQ in global domain.

So my requirement is before below line is there any function to set domain i.e before cart item is ordered setting domain of that cart item.

var rc = cart.placeOrder();

tonemking · ‎07-15-2016

If the user submitting the email is in a specific domain then it should run for that domain only. We have domain separation as well.

Tone