# IntegrationFieldLookupKey

## <span class="mw-headline" id="bkmrk-what-it-does-1">What it does</span>

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

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

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

## <span class="mw-headline" id="bkmrk-how-to-invoke-1">How to invoke</span>

Insert value in field mapping Designer &gt; Integration &gt; Import sources &gt; \[intergration\] &gt; \[fieldmapping\] &gt; Codeunit handler

```
dk.p2e.blanket.codeunit.common.IntegrationFieldLookupKey
```

## <span class="mw-headline" id="bkmrk-configuration-1">Configuration</span>

Insert an SQL expression in:

\[fieldmapping\] &gt; Configuration values

Example:

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

## <span class="mw-headline" id="bkmrk-developer-info-1">Developer info</span>

- <span class="mw-headline">Type: [CodeunitTranslator](https://docs.tsnocode.com/books/codeunit-reference/chapter/translator)</span>
- <span class="mw-headline">Security: None</span>
- <span class="mw-headline">Classpath: dk.p2e.blanket.codeunit.common.IntegrationFieldLookupKey</span>