Unable to load headers from the XLSX data source ( scheduled import job: <data-source-name>)

[Sumit Rathod4]

Hi,

I am trying to trigger the transformation process via 'Scheduled Imports' from workflow script after copying the attachment from catalog item to data source. But I am getting "Unable to load headers from the XLSX data source ( scheduled import job: <data-source-name>)".

But when I try to load and transform the same input excel file manually, the entire process works seamlessly.

Any leads are highly appreciated.

[-O-]

Wouldn't it be easier to load the data using the GlideExcelParser  API?

Probably your code either does not attach the right file to the right Data Source, or it does not trigger the loading of the right Data Source.

But without code and further details it is hard to tell.

But, again, I'd go for the scripted loading of the data into an Import Set Row table, where it would automatically be transformed as records are added.