how to Load data from an email attachment and create an incident and associate the new incident record with loaded data

[____39]

I want to load data via email attachment, and create an incident at the same time while loading data, but how to associate the new incident record with loaded data?  Thank you!

[Ankur Bawiskar · Accepted solution]

Hi,

can you print what came in source.sys_import_set.number?

try this

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {

    // Add your code here
    var gr = new GlideRecord("incident");
    gr.initialize();
    gr.short_description = import_set.number;
    gr.insert();

})(source, map, log, target);

Similarly update the onAfter

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {

    // Add your code here
    var gr = new GlideRecord("incident");
    gr.addQuery("short_description", "LIKE", import_set.number);
    gr.query();
    if (gr.next()) {
        target.fieldName = gr.getUniqueValue(); // if target field is reference to incident

        // OR

        // target.fieldName = gr.number; // if target field is string
    }

})(source, map, log, target);

Regards
Ankur

[____39]

or is it possible for putting the loaded data to the new created incident's related list?

[Ankur Bawiskar]

Hi,

I already shared the logic.

in the inbound first create specific incident; then use onAfter transform script

Regards
Ankur

[JhulsBSS]

Hi Angkur,
I was following the link you shared, however in my end, I can't for some reason copy the attachment from the inbound email to the Data Source.
Hence I cannot import my attachment properly, it is always blank.

Regards,
Jhuls

[____39]

I write the short description with email.text, but can you tell me in the transform map onAfter script, how to find the new created incident? thank you!

[Ankur Bawiskar]

Hi,

like this

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {

	// Add your code here
	var gr = new GlideRecord("incident");
	gr.addQuery("short_description", "your text");
	gr.query();
	if (gr.next()) {
		target.fieldName = gr.getUniqueValue(); // if target field is reference to incident

		// OR

		// target.fieldName = gr.number; // if target field is string
	}

})(source, map, log, target);

Regards
Ankur