How to List, Read, ZIP, Write Files in OIC

How to List, Read, ZIP, Write Files in OIC

In this example, we are going to see how to use the FTP adapters to List, Read, ZIP and write files.

Below is the Overview of our exercise,

• Create a Connection
• Create Integration
• List Files (Using FTP Adapter)
• For Each File Present in that Location,
• Download the File (Using FTP Adapter)
• ZIP the File (Using Stage Activity)
• Write the File (Using FTP Adapter)

Create Connection

Please check my earlier post for step by step instruction on creating connection for FTP Adapter.

Create Integration

Create a App Driven Orchestration.

Create the SOAP Adapter as a start.

Drag and drop the FTP Connection from Invokes.

We are going to use this FTP adapter for listing the files present in remote location. Name it as ListFiles and click next

Select Operation as ListFiles
Provide Input directory and File Name pattern. You can override this in run-time using map activity.
Click Next and Done.

Now we are going to read each file and ZIP it and produce it to a new FTP Location.
Drag and Drop ForEach activity from Actions tab.

 Edit the For Each Activity.

Provide name and repeating element details. And decide the current element name(it can be anything but provide a relevant name)

Drag and Drop the FTP adapter once more, this time we are going to download the file to local for us to ZIP the File.

Provide the Input directory of remote FTP Location, and Download Directory of something unique.
OIC will create the Folder in run-time locally and download the file to this location.
*File Name will be overridden in run-time using map activity.

 Edit the Map Activity to provide the Directory and File Name to be downloaded. it will be fetched from Current element name which was given in For-Each.
Note: Also you can see i have overridden the Download Directory as well. Since there will be more files in remote location i want each file to be download to new location. If you want all the files to be downloaded to the same folder, don't assign anything here.

Now you have the files downloaded to OIC, you can ZIP that directory using Stage File Activity.

Specify the File Name : Target file name (.zip file)
Specify the Directory to ZIP : Provide the Directory name where the File was downloaded(previous step)
Specify the Output Directory: Mention unique Directory name (its local to OIC)

Now we have Downloaded and Zipped the file in a OIC location. We have to use FTP adapter again to write this file to remote server. So drag and drop FTP Adapter and Configure it.

Now Click on the Edit Map to Override the Filename and File.

And You are Done.!!! 

Create a SOAP UI Project to trigger the Integration.

FTP Adapter in OIC

How to Read from FTP Adapter in OIC.

To Integrate with FTP location in OIC,
1. Create an Connection with FTP Adapter.
2. Create an Integration to use the connection we created in First step.

In this example, we are going to see how to read data from File using an FTP adapter.

Create Connection

Create the Connection for FTP Adapter.

Populate Host,Port and SFTP as Yes if you are using port as 22.

Populate the Username and Password in Configure security.

Create Integration

Here i have selected the connection of soap adapter which i created in earlier exercise. Please click here to explore more.

Now drag and drop the FTP Connection(created in first step) from Invokes window into the integration flow.

Provide a name.

 Select the operation as "Read File". Provide a dummy file name, because we will override the filename in run-time.

Please select "Yes" for specify structure if you want to read the content of the file.

Provide a sample file here, it will automatically generate the schema in background.
Enter the relevant record name and root element name(Recordest Name)

Edit Map to Read File to set the filename. In this case, we will receive the filename as input from soap service and pass it in run-time.
Note: You can override directory as well, here i haven't done that.

Edit response mapping to pass the result of file content to the SOAP service.

Now save and activate the integration.
Create a Soap Ui project to test the integration. Pass the file name as input and receive the output of file content.