Difference between revisions of "Codeunit/Integration/IntegrationFieldLookupKey"

Revision as of 10:31, 18 March 2013

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.

Example:

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

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

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

  dk.p2e.blanket.codeunit.common.IntegrationFieldLookupKey

Insert an SQL expression in:

[fieldmapping] > Configuration values

The expression must contain the parameter: @VALUE@

@@ Line 6: / Line 6: @@
 Example:
    SELECT Name FROM user WHERE Email = '@VALUE@';
+Note that the @VALUE@ is SQL escaped for security reasons.
 == How to invoke ==