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

Excluding whole rows from being staged based on certain criteria - mapper?

in Integration 3 comments

Summary:

In OIC Gen 3

I have the response from an API call being mapped directly to a stage file write.

So ALL the rows returned are immediately written.

I want to exclude certain rows based on criteria, e.g

"Only include rows where

Col A = 'A' and Col B IN (1,2,3)

or

Col A = 'B' and Col B IN (4,5,6)

etc

I assume I have to remove the map from the API response to the Stage.

Put in a For Loop

Go through each row one by one, use a Switch to check the conditions and only stage each row if it meets the criteria.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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