Codeunit/Integration/IntegrationFieldLookupKey

From TempusServa wiki
Jump to navigation Jump to search

What it does

Looks up another value based on the string provided, for use in a scheduled integration.

A lookup will be executed sustituting the @VALUE@ in the SQL expression passed to the codeunit.

Note that the @VALUE@ is SQL escaped for security reasons.

How to invoke

Insert value in field mapping Designer > Integration > Import sources > [intergration] > [fieldmapping] > Codeunit handler

  dk.p2e.blanket.codeunit.common.IntegrationFieldLookupKey


Configuration

Insert an SQL expression in:

[fieldmapping] > Configuration values

Example:

 SELECT Name FROM user WHERE Email = '@VALUE@';

The expression must contain the parameter: @VALUE@

Developer info

  • Type: CodeunitTranslator
  • Security: None