Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Script for Dynamic Data Source creation

Kumar38
Kilo Sage

Kumar38_1-1692551131178.jpeg

When we use " load data " , it auto creates a data source . Which script creates data Source . Every time it does  it updates file path with attachment name . Which might be the reason we have the following error.

 

com.glide.db.impex.datasource.DataSourceException: The supplied data appears to be in the Office 2007+ XML. You are calling the part of POI that deals with OLE2 Office Documents. You need to call a different part of POI to process this data (eg XSSF instead of HSSF).

1 ACCEPTED SOLUTION

Kumar38
Kilo Sage

In our case , the file name is causing the Issue. Renaming the file fixed the issue.

View solution in original post

2 REPLIES 2

Sonu Parab
Mega Sage

Hi @Kumar38 ,

Have a look below thread.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0780856

 

https://www.servicenow.com/community/developer-forum/error-com-glide-db-impex-datasource-datasourcee...

 

If my response successfully addresses your query, I kindly request you to consider marking it as the accepted solution. Doing so can be beneficial for others who might have a similar concern.

Thank you!

 

 

 

Kumar38
Kilo Sage

In our case , the file name is causing the Issue. Renaming the file fixed the issue.