Write to data store entity: Is there a way to get number of rows successfully wr

@maheshp To the best of my knowledge, each and every record (new or existing) you input to this smart service will be updated in the database. If there is any problem even with a single record, the smart service ends in failure without making any updates.

If your intention is to only identify the newly inserted records without making a query, then a difference in the primary key attribute between the PV (you input to the smart service for writing into DB) and the 'Stored Values' (output of 'Write to Data Store Entity' smart service) should give you the newly inserted records.

If your intention is to identify the updated (newly inserted or modified) records, then 'Stored Values' (output of 'Write to Data Store Entity' smart service) is the one which will help you in identifying so.

Let's see if any other practitioner can provide their valuable inputs.

@maheshp To the best of my knowledge, each and every record (new or existing) you input to this smart service will be updated in the database. If there is any problem even with a single record, the smart service ends in failure without making any updates.

If your intention is to only identify the newly inserted records without making a query, then a difference in the primary key attribute between the PV (you input to the smart service for writing into DB) and the 'Stored Values' (output of 'Write to Data Store Entity' smart service) should give you the newly inserted records.

If your intention is to identify the updated (newly inserted or modified) records, then 'Stored Values' (output of 'Write to Data Store Entity' smart service) is the one which will help you in identifying so.

Let's see if any other practitioner can provide their valuable inputs.