ERROR: com.glide.db.impex.datasource.DataSourceException: java.io.IOException: error in loading headers from the xlsx data source: null

[karolisjon]

Hello, maybe some of you have experienced this issue before and will have any tips. Our stakeholders export data from CRM and then import it to ServiceNow through existing transform map. In some cases they get an error in the title and the upload fails. According to them they simply extract the Excel and load it directly to our instance without changing any fields in the sheet. 

- files are always .xlsx 
- there are no spaces or weird symbols in the headers
- there are no empty headers 
- there are no hidden rows

Workaround at the moment is simply to save the file as a copy and then the upload works. It also works if you copy the content to a brand new file. 

My question is - is there a way to somehow prevent this from happening from ServiceNow's end? Maybe the transform map can be adjusted in some way? The weird part is that sometimes there are no issues and sometimes the upload fails, even though no changes are made in the sheet after exporting it. It always is the same. 

Thanks!

[tmalo]

When importing Excel sheets to Tables, ServiceNow is expecting their template to be used. As a short term fix, try copying the data from CRM source into a ServiceNow template. But I would be looking for ways to automate that process. Do you have the ability to use the Integration Hub? I'd imaging Salesforce has a spoke of some sort on there.