importing excel data coming from email ito cmdb tables using integrationhub etl
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-23-2023 05:05 AM
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-23-2023 09:44 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-24-2023 03:17 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-24-2023 05:05 AM
@Chuck Tomasi Any suggestions ?