Attempting to Auto Import the Attached CSV from Inbound Email to a table, need help

JhulsBSS
Tera Expert

Hi Guys,
just want some help on this.
I was following this Auto load Excel spreadsheet using Email Inbound Action – The ServiceNow Expert
the only change that I made is:

    var importSetName = "Import Target CSV";
    var importSetLabel = "u_import_target_csv"
    basing the image below
   JhulsBSS_0-1736751281873.png

 

     current.format = "CSV"; // -----> since it was a csv attachment

 

However the problem is that the attachment from the inbound email that was received was not copied to the Data Source.

Can you help me?

1 ACCEPTED SOLUTION

JhulsBSS
Tera Expert

Found the solution.
Turns out, we have conflicting OOTB Inbound Email Actions, that are by default set every email we received to the Incident Table.
To remove that, follow the solution given here:
Solved: I want to stop automatic create incidents from rec... - ServiceNow Community
After that, the guide that I followed will work since it automatically saves the attachment to the data source, no changes needed.

View solution in original post

3 REPLIES 3

Animesh Das2
Mega Sage

Hi @JhulsBSS ,

 

It seems you interchanged the 'importSetName' and 'importSetLabel' values wrongly.

Please try like this shown below instead if that works,

    var importSetName = "u_import_target_csv";
    var importSetLabel = "Import Target CSV";
 

If this address your question, please don't forget to mark this response correct by clicking on Accept as Solution and/or Kudos.

You may mark this helpful as well if it helps you.

Thanks, 

Animesh Das

Upon testing your suggestion its getting worse

JhulsBSS_0-1736815129133.png

On this image above you see that on the lowest part is different, that is when I tried your suggestion.

JhulsBSS
Tera Expert

Found the solution.
Turns out, we have conflicting OOTB Inbound Email Actions, that are by default set every email we received to the Incident Table.
To remove that, follow the solution given here:
Solved: I want to stop automatic create incidents from rec... - ServiceNow Community
After that, the guide that I followed will work since it automatically saves the attachment to the data source, no changes needed.