Skip to main content
Version: 6.18 (draft)

Contact ID lookup

This plug-in can be used in transformations to find contacts in the ConSol CM database.

The following settings are available:

  • Step name: Specify the name of the transformation step. The default name is the name of the plug-in.
  • Contact object: Select the contact object which should be searched. This is either a company or a person.
  • Field name: This column can include all fields of the previous transformation step. These fields are mapped to the contact fields in ConSol CM. Click the Get button to retrieve the available fields.
  • Type Select the contact fields from the selected contact object which are mapped to the field names.
  • Case insensitive Specify if the search should be case-sensitive (false) or not (true).

The generated output contains two additional columns:

  • CmInternalcustomerId: This column contains the ID of the contact. If the contact was not found, the ID is -1. If more than one contact was found, the ID is -2. The ID can be used in the subsequent transformation steps.
  • customerResolveException: This column contains a description why the ID could not be retrieved, e.g. Found 0 customers or Found more than 1 customer.