OIC - Decrypt file using FTP download operation and read reference in stage activity

Use Case: Here, we will download (with decrypt) an encrypyed csv file without schema option  and then read file reference using stage read entire file option.

Implementation steps:

Step1: First create FTP connection following below blog:

https://soalicious.blogspot.com/2021/08/oic-create-sftp-connection-with-pgp.html

Step2: Create an orchestrated intwgration and drag and drop FTP connection and download the file with pgp encrypt option.

Step3: add the stage activity and choose the read the entire file option and provide the file reference from download response object.

Step4: provide the csv sample file for reading the reference.

Now the integration flow will like as below:

Save and test.

Encrypted csv file:

From Monitoring - view activity stream: