Creating a data source with a .zip folder

[Andrew78]

Hi,

I have a requirement where I need to reach out to a zip folder from a URL similar to:
https://example.com:443/folder.zip

This zip contains several folders and I need to get these folder names into a table in ServiceNow.

I have created a data source with Zipped = true, Type = File and Retrieval method = HTTPS which does not work. I suspect this is because the file zip file it is pointed contains folders and not a single file eg: CSV file.

Does anyone have any suggestions of how I could get this data source to work? Or know if there are any other ways I could fulfill this requirement?

Thank you in advance

[Roger Poore]

Is the file in gzip format?  According to this article, gzip isn't supported.  From that article:

I tried to import the file after unzipping it and it worked. But if I try to import the file compressed (GZIP format) manually (filename.csv.gz), it doesn't work. I tried to do the same by compressing my file in ZIP format and I haven't any problem. 

If that's not the issue, you might be able to use a JavaScript based zip library.  See:  https://davidwalsh.name/javascript-zip

[Hitoshi Ozawa]

I'll probably just create a new service on internal server to process the zip file and then just use REST APIs to update the ServiceNow tables.

[Liz26]

Hi, did you manage to solve this requirement? I have similar one and just wanted to check if you could share the solution