Hi Everyone,

This article introduces a Lab of have written showing how a CMDB Integration can be implemented with incoming Emails with attached CSV files. I created this for several reasons:

(i) I teach CMDB Fundamentals and I wanted to show how the IntegrationsHub ETL (upgrade to Transform Maps) can be used automatically when triggered by and incoming Email and Scheduled Import Job.

(ii) I saw this use case in a Community Article where the Customer was asking how to parse an Excel or CSV file from incoming email to update a ServiceNow Table. The responses I saw referenced scripting quite a bit so in my example I am using NO scripting.

(iii) I delivered this topic as a HoT session a few months ago, it in that example I used Transform Maps instead of IntegrationHub ETL. So I thought I would update this and also provide you the ability to try this out using a Lab.

I know this Lab is a little bit lengthy (30-35 mins) but it does hopefully demonstrate a number of technical functions.

* The use of Flows to process incoming emails and process/parse attachment data files (without scripting!).

* The use of IntregrationHub ETL to process incoming data from a type of Integration.

You complete this Lab using my attached Update Set (to create a new CMDB table) and you will need to install the IntegrationHub ETL plugin (this is explained in the Lab).

So I hope this Lab is useful

Regards

Darren