Hi Priyanka,Just like UPDATE_INSERT, Do SAP CPI supports DELETE_INSERT?

[rohitparihar · Accepted solution]

Hi Sakshi..

To my knowledge, currently there is no direct equivalent operation like DELETE_INSERT(delete or insert at the same time). However you can achieve similar functionality by implementing a sequence of below steps in your integration flow by making sure the logic and exception handling are maintained properly. 

1. checking/validation of the existing object

2. delete/remove if necessary and

3. create/post/insert 

Hope it helps 🙂

[Sakshi_T · Accepted solution]

Thank you, Rohit! I have a question—can we use UPDATE_INSERT in this case? The issue with INSERT occurs when a record is already present in the database, preventing insertion and causing an error. If we use UPDATE_INSERT, it will update the existing record if it's already in the database, avoiding the error. Please share your thoughts on this.

[rohitparihar · Accepted solution]

Yes, you can do so, but since the function UPDATE_INSERT can handle the checks on its own, the above steps will not be required

[Sakshi_T · Accepted solution]

Hi Rohit, Thanks for the help!

[robertot4s]

Hi,

No it doesn't exist, here you have the existing operations:

https://help.sap.com/docs/integration-suite/sap-integration-suite/payload-and-operation

Regards,

Roberto

[Sakshi_T]

Thank you, Robert!

[Sakshi_T]

Is there any alternative to DELETE_INSERT action in Integration suite?