Import Set Fails When Email Contains Image Attachments Body

[schetry]

Hi Community,

I have a data source set up to load an Excel attachment from emails. It works fine when the email has only the Excel file, but fails with this error when the email also contains images (like logos):

Error: Unable to load headers from the XLSX data source

My script copies the attachment to the data source and loads it via GlideImportSetLoader.

Question: How can I programmatically load only the Excel attachment when multiple files exist, avoiding this load error?

Thanks!

[Bhuvan]

@schetry 

Create onStart transform script to use only excel file in the attachment and ignore any other extensions.

https://developer.servicenow.com/dev.do#!/learn/courses/xanadu/app_store_learnv2_importingdata_xanad...

Thanks,

Bhuvan