how to unzip the zip attachment and then read internal files which are present inside the zip files

[keshav77]

Hi All,

I am working on project where I get the zip file in the attachment then we have to unzip it and read the data of the files which are under zip file. then we need to combine those 2 files together on the basis of parent child relation ship to do the data validation. 

can we do this is there any way to this please let me know.

[Ankur Bawiskar]

@keshav77 

As I informed there is nothing available OOTB for this except the paid version of Integration hub and that also works in server side

So for your requirement you can use onChange client script and some UI script which has external API library to handle this

Note: Remember I won't recommend this much customization as this will be a technical debt and will have dependency on external library

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[keshav77]

@Ankur Bawiskar  can you please help me with this by giving me suggestion about what method should I use in this case.. and share some steps of those methods as well.

Because external api's are not working for me in this case because of whitelist issues..

java util packages are not working for me either.

Please share some better suggestion regarding this.. 

[Hugo Barros]

@keshav77 right. But but cant you just get the catalog variable value in an onChange catalog client script, and then make a GlideAjax call to a script include and call a sublow that do your validation and returns the result to the client side

[Hugo Barros]

I think the caveat here will be async/synchronous operations. You have to run your subflow with inputs (synchronous) but the glideajax will be asynchronous (and you should not use getXMLWait in this case)

[keshav77]

@Hugo Barros  so you are trying to I can use any java zip utilities that help to unzip the attachment just need to use zip utilities in script include  and need to call glide Ajax on onchange  client script on  the attachment variable. are you aware about any utilities that will work in ServiceNow