oracle hcm to oracle epbcs integration using REST API

Summary:

Dear Experts,

We have a requirement to extract data from Oracle HCM and load it into EPBCS. The client’s HCM system provides REST APIs for data access.

Could you please advise on the most appropriate and efficient method to retrieve data via the REST API and integrate it into EPBCS?

We initially proposed using Groovy to invoke the REST API, convert the JSON response into a CSV file, and then use the CSV file as the source for data loading. However, the client’s IT team is not in favor of this approach.

We would appreciate your guidance on any alternative integration methods that could be considered for this requirement.