ERP - Incentive Compensation - Check for duplicates from the ImportPublicService WS File Import

Hi,

we need a rule (Groovy validation?) for checking if there are duplicates inside a file that we load from the integration platform to ERP.

The check should be done on the Participant name and a validation error should be given if there are duplicates.

 

1. First step is to load the file in Universal Content Management:

Web Service name: https://egwh-test.fa.em2.oraclecloud.com/crmService/ImportPublicService?wsdl 

Operation "submitImportActivity" 

 

2. Then there is the load in CDM: here the check should be done

../crmService/ImportPublicService?wsdl 

Operation "submitImportActivity"

The CDM entity is the 'Account'.

Is there any place in the SaaS where we could try writing some code to check, line by line, if that Account ID is already in the system?