Skip to Content
1
Aug 04, 2023 at 11:09 AM

Flat File to APIs Patterns CPI

106 Views

Hi All,

We are new to using CPI and have a situation where we have a flat file incoming which requires calling multiple APIs per line. We are unable to change the inbound file unfortunately.

What we are looking for is a method to call S/4 APIs 1-3 in a batch (its not the same API, each is different) and commit in a single LUW. At present each request call is committed at the end of the individual API call, this causes issues as if the second or 3rd API call fails for bad data then we have committed a partial update based on the incoming file.

We have looked at using the simulate methods, but this increases the development effort and system load significantly, as each record in the file is processed twice (once for simulation and once for commit).

Ideally we are looking for a way to group the API calls into a single LUW without creating custom APIs.