Bulk upsert with return response in sap cap nodejs

[#1]

Hi All,

I have a scenario where bulk data needs to create or update. If record already exists it needs to update, if record does not exist then it needs to create. For that scenario using UPSERT query with node.js. But the query is only returning affected rows but we need what all records got successfully executed. Please let me know if UPSERT do return response like that or any alternatives.(Note: Please suggest only minimal queries needs to hit db).

Thanks,

Jani Basha Shaik.