Microsoft sharepoint Online file (custom) - data not recognized

[camille lordon]

Hello,

I am trying to use Microsoft sharepoint online file (custom) connector but I do it, some excel files are showing unexpected values (see image).

Is it something we could fix ?

Thanks in advance

[Peter McKinnis]

Camille,

Based on what I see in the screenshot, the file getting loaded is not a data file but a zip file. The "PK" at the start of the file usually signifies a zip file which cannot be loaded. Can you verify the file you are trying to load?

Thanks,

Peter

[camille lordon]

Hello Peter,

I confirm it is an excel file stored on a sharepoint site.

Thanks in advance for your support

Camille

[Peter McKinnis]

The issue here was that the Excel file ended in an capitalized extensions, e.g. XLSX, which the connector was incorrectly handling. An updated version of the Custom Connector for TIBCO Spotfire has been released.