Retrieve a ERP Cloud record to validation purpose

Summary

Retrieve a ERP Cloud record to validation purpose

Content

We are working on integration to create/update an object in Oracle ERP cloud. But before creating/updating we need to check if object already exists in ERP cloud.

In case object exists we need to update it otherwise create the object. Hence just wanted to check if anyone has done it already.

The solution we are thinking to create a BIP report which returns the file with key column. We will check the key field if it exists in the file then we will trigger update otherwise trigger the create operation. Please let me know in case any other way to achieve it.