Thursday, May 11, 2023

OIC - Convert CSV file data to JSON | Oracle Integration

Usecase: we will poll a csv file using FTP adapter and convert it to json file using FTP adapter configuration.

Highlevel steps:

  1. Create FTP connection.
  2. Create an Scheduled orchestrated integration and call FTP adapter and poll the CSV file.
  3. Drag and drop FTP adapter again and configure to write json file to a directory.
  4. Map the csv file response to write file json data.

CSV file:


Json format:



Detailed steps with screenshots:












No comments:

Post a Comment

Featured Post

OIC XSLT: Execute Only When At Least One Field Has Value and None Are Blank

๐Ÿ”ท OIC XSLT: Validate Fields Before Executing Logic ๐Ÿ”น Requirement Fields: field1, field2, field3, field4, field5 ✔ Execute only when: At le...