Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Read File in Segments to REST Service insert to ATP database — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Read File in Segments to REST Service insert to ATP database

Received Response
19
Views
6
Comments
edited Nov 15, 2019 2:52PM in Integration 6 comments

Summary

Read File in Segments to REST Service insert to database results in all rows written in each segment read

Content

I have a very large file to import to my integration.  I am using FTP download and then Stage Read File in Segments to access the data that will be inserted into a database table in our Cloud ATP Oracle database.  The REST call is set up to utilize Batchload in order to post the 200 rows that each read in segment will pull.

The result is that for each read, All rows in the inbound file are written to the database.  I believe the problem is in the way the elements are defined but cannot see that actual problem.  I am very new to OIC and am learning on the fly.  Any assistance will be appreciated.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!