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.

Retrieving data from an excel File through inbound Email action.

BhavinG
Tera Contributor

Hi Everyone,
I have been trying to retrieve the data from an Excel file into my code for some implementation using the inbound email action. So, I have got two approaches for the same, i.e.,
1. Using the import set loader 
But it is used when we want to store data into a table using any transform map, etc. But I don't want to store the data in any table. Instead, I wanted to get the data from an Excel file into my code in the form of an object, so that I can use it further for validation or any service request generation.
2. GlideExcelParser.
For this, my Instance doesn't have access to this library. So, I can't use this.

So, I want a solution using Import set only, but I'm unable to figure it out.
Can anyone please help me with that?

1 ACCEPTED SOLUTION

JenniferRah
Mega Sage
Mega Sage

Why do you not have access to GlideExcelParser? It's not a library. It's just a function. https://developer.servicenow.com/dev.do#!/reference/api/yokohama/server/sn_impex/GlideExcelParserSco...

View solution in original post

2 REPLIES 2

JenniferRah
Mega Sage
Mega Sage

Why do you not have access to GlideExcelParser? It's not a library. It's just a function. https://developer.servicenow.com/dev.do#!/reference/api/yokohama/server/sn_impex/GlideExcelParserSco...

Our company hasn't bought this feature or something in our instance. So, whenever I use this function, it shows that "GlideExcelParser" is not defined.