OIC - Search Data from CSV file

Usecase: Here, I will show you how you can search employee information from a CSV file using empid.

High level steps:

• Add rest configure to fetch emp details based on id
• Read csv file using FTP connection
• Map the searching logic to show in rest response.

Implementation:

Step1: Add an App driven orchestratation integration style and add a rest connection and configure id template param and emp details as response.

Step2: Add FTP connection and read the file and use a sample csv file.

Step3: Map the fields as below:

Take XSLT view and add for each on top of Email and map for each source Emp.

Then add if block inside for each and add the condition csv file empid = template id

Map all the fields.

XSLT code view will be like that:

Now the integration flow looks like below

Step4: Add the tracking and save and activate and test

CSV file contents: