I have an API that download CSV file as zip. i want to load unzipped CSV file to s3 bucket.Is there any way to do this in matillion
The "Data Transfer Component" (https://documentation.matillion.com/docs/2953509) offers an option to "Unpack ZIP File". You can try to transfer your file within the same bucket and unzip it as part of this process.