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.

[Hugo Barros]

Hi @keshav77 , I hope you are doing well.

This may help you:
https://www.servicenow.com/docs/bundle/zurich-build-workflows/page/administer/flow-designer/referenc...

I've used it in a project a few months ago and it helped me unzip files and read contents. Pretty easy to use. You gotta have ServiceNow IntegrationHub license in place though.

[Ankur Bawiskar]

@keshav77 

you can use the paid version using the link shared by @Hugo Barros 

Another method is to use mid server if you don't want to go with the paid Integration Hub

Unzip a file using script 

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

[Hugo Barros]

oh right! That's also an option. thanks for pointing out @Ankur Bawiskar !

[keshav77]

I mean these both method work after the records submission then it will unzip the file. currently what I am looking for in my case-- the user enter the zip file in the attachment variable at the some point of time we can read the data of the internal files.  for example we unzip it  then read the files data in memory  if data is invalid we don't allow to submit it.

@Ankur Bawiskar  is this possible with the help of any packages