Skip to Content (Press Enter)
2023-03-21 09-05-05
m.irfan.azam
84Views
2Comments
Download and Import Compressed CSV File
Question
Reactive
Application Type
Reactive

I want to download and import a compressed csv file. Here are the steps I need to do: -

  1. Download a zip file from a URL.
  2. Zip file contains a CSV file that need to be extracted. 
  3. Import data into a database entity

NOTE: -

  • Compressed file size is always between 10KB to 20KB. 
  • Uncompressed file size is always between 40KB to 50KB

Kindly advise.

0
0
06 Jun 2023
Copy Link
2024-04-03 15-32-55
Maxwell Mckinnon

Hello, 

I've just checked there are a few plug-ins/enxtensions available on the forge that can support this, such as: Unzipper by Esrom Galang or GZip Compress/Decompress by Rul Mendes, try giving these a go.

I'd advise just searching "zip" instead of "Unzipper" to provoke more search results which may help in your use case.

Hope this helps,

Max

0
1
07 Jun 2023
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP

Hi Irfan,

To download a ZIP archive file from a URL, consume it as a REST method, like described here. This of course only works with a static base URL.

To uncompress the ZIP file, use the Platform's built-in ZIP functionality.

To import the CSV into a record list for further manipulation, use one of the available Forge assets.

0
0
08 Jun 2023
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.