importing excel data coming from email ito cmdb tables using integrationhub etl

SK41
Giga Guru

Hi,

 

I have a requirement where i have to import excel data in cmdb server table using integrationhub etl. The requirement here is that the excel comes as an attachment in the email to servicenow and from there the excel data should be auto mapped to the table. The excel file should be auto pulled and transformed into the table.

 

is it possible to use integrationhub for the excel data which comes in email and to be auto fed and trigger the import?

 

please suggest.

thanks!

3 REPLIES 3

Claude DAmico
Kilo Sage

I have used this (https://www.servicenow.com/community/developer-blog/loading-data-from-an-email-attachment/ba-p/22797... ) which continues to work well for me.

Claude E. D'Amico, III - CSA

hi,

i am currently doing the same thing as mentioned in the link, using email as integration. Creating inbound and script include to extract attachment and transform data.

 

I am curious to know if the same can be achieved by integrationHub ETL., 

is there any possibility to use it?

@Chuck Tomasi Any suggestions ?