There are various situations where you need to push records in batches to the target service due to the target service limitation.

Considering we need to develop the integration in Oracle Integration, which pulls the records from the database and pushes those records to the target services in batches of 10 records.

You might be thinking we can use Stage File action to read the data in chunks but then you can’t change the limit of 200 while you use File read in chunks operation.

In this case, you have to build a custom solution so here we are.

In this solution, we are going to use the following adapter and actions of Oracle Integration:

  • Rest adapter
  • Global Variables
  • Assign
  • Switch
  • For Each
  • Data Stitch with Append operation
  • Mapper

To build this custom solution, I have captured an end-to-end video that will help you to achieve the same. Click on the below video and watch it completely:

Please look at my YouTube channel for more such videos and don’t forget to subscribe to our channel to get regular updates.

Please subscribe for a membership to watch this video.

Further Readings

FTP adapter in Oracle Integration Cloud(OIC)

XSLT for-each Function

How to create a BIP report in Oracle SaaS

Form region to insert a record into a table in Oracle APEX

Master-Detail Page in Oracle APEX

Cascading List of Values in Oracle APEX

Oracle APEX Interactive Grid with CRUD operation