Is there a way to upload a data through email or any other way in servicenow except load data option

[Tanya Rathor1]

Hi All,

Is there any way to upload a data through email or any other functionality except load data option in snow.

one way is I have created a transform map for this , and loaded data through load data option.

For Load Data , there is import_admin role required.

and client wanted that anyone can load data either through email/inbound/service request or any other functionality.

please advise.

Regards,

Tanya

[Frank Treml]

Hi Tanya,

we are doing this currently with an email send to the instance including an excel attachement. 

The excel attachment needs to be always in the same format. .

The inbound action is storing the attachment in the sys attachment table and then fire off several scheduled jobs for the processing. 

Hope this helps

Frank

[Frank Treml]

Here are some steps for the inbound action:

First , once the email is received and the inbound action is kicked in, you want to make sure that your import set table is cleaned up. 

Second, you want to make sure , that you get the latest attachment and get rid of any previous that has been stored.

Third, you query your sys_attachment table for the File name you are expecting and use the GlideSysAttachment.copy to get the attachment copied over to your sys_data_source.

Once the attachment is added to the sys_data_source, you can fire off scheduled import set to load your data from the sys_data_source into the Import Set Table using SncTriggerSynchronizer.executeNow.

Once the Data is in your import set table you can then also fire off additional scheduled jobs from the inbound action to get the data where you want it to.

Hope this helps

Frank

[Tanya Rathor1]

Hi Frank,

Thankyou so much for the solution.

can you also please share the script for Inbound action and Scheduled job's.

It will be very helpful for me.

Thank you,

Tanya

[Frank Treml · Accepted solution]

Hi tanya, 

here is the inbound action which you have to modify with your table names and Sys IDs