SFTP Integration : Upload and Download Zip file from Local machine to FTP Server

[Vasudha]

Hi Team,
Please guide me to achieve below scenario in apigee hybrid environment.

Here's what we're trying to achieve with our proxy design: we're attaching a zip file from our local machine in the request, and we want Apigee to unzip the file and convert it to the .esm format and setup a SFTP connection and upload the file to FTP server in  particular folder. 

Below are details for connection establishment:

1. Unzip the Data and Change the File Name Extension from .zip to .esm
2. Upload the File to FTP
SFTP Details (UAT env):
Host: FTP Host
Port: 22
Username: user
Password: *********
Filename: {original name}.esm
Directory: /out/work
key for authentication: Key Pairs (UAT env).

[shaaland]

Hi @Vasudha , Thanks for your question!

While I don't have a good answer for how to do this in an API Proxy, I do have a solution for you that would make this straightforward using Apigee Integration (an Add on to Apigee X) or Application Integration (in preview as a stand alone GCP service - same product, different packaging).  We have an SFTP connector, and you can use Cloud Functions to do any conversions needed (like zip to esm).

Please see some of the posts on the Integration Services Forum page here...there are several samples including SFTP and GCS.
https://www.googlecloudcommunity.com/gc/Integration-Services/bd-p/cloud-integration-services