Hi Pedro,

the info "I'm getting duplicates" is specific to the way I created the job and maybe a bit confusing

The main question is:

How can I get the tSugarCRMInput component to read the deleted accounts from Sugar? Sugar sets the field "deleted" in the database to 1 for each account that should no longer be active. These accounts are also no longer retrieved via the tSugarCRMInput component.

Thanks and regards
Andre

Hi everyone,

I have created a job to import accounts to SugarCRM from a SQL datasource. I used the built in Sugar component. As I need to retrieve the accounts already imported I am getting some duplicates because the import component for Sugar does not get the accounts with the field deleted set to 1. I googled that the param $deleted has to be set to 1 to get them, but I have no plan how to do this in talend and what this param option is.

Can anyone tell me how to get the accounts with the database field deleted set to 1?

Thank you very much.

Regards

Andre