Show contents of uploaded file in Portal before submitting the form?

[SNNoob]

Heya!

I have a record producer which allows users to load up an Excel file to import Users to ServiceNow. That's all working fine.

However, would it be possible to showcase the contents of the Excel file in the Record Producer page, before submitting (in a somewhat similar fashion to list views would be nice but not necessary). Challenge here is of course that since the records don't exist in ServiceNow until the form is submitted, any related lists are out of the question.

So far, I'm under the impression that this is impossible but perhaps someone here has ideas if this is doable?

[Sebastian L]

Not without a lot of customization, but in theory I guess you could, but doesn't mean you should hehe..

When you upload an attachment in the portal, it is actually saved in the attachment table. So you could maybe look up that attachment record, copy it to an already-built data source that looks for an attachment, process that data source and then look up the import records and display them on the portal, once you get the answer from the server... IN THEORY hehe. Don't think the effort is equal to the benefit.   

[SNNoob]

Thanks Sebastian, I agree that there are probably better ways to do this 🙂 was more interested in the hypothetical side of this.

[Sebastian L]

Forgot about the GlideExcelParser as Saurav mentions below. So you could look up the attachment and use that. Definitely the best option! 🙂 

[Saurav11 · Accepted solution]

hello,

Ins Servicenow we do have functions to do the same check the below article:-

https://developer.servicenow.com/dev.do#!/reference/api/rome/server/sn_impex-namespace/GlideExcelParserScopedAPI#GEPS-GlideExcelParser

Please mark answwr correct/helpful based on impact