CodeunitTranslator


IntegrationFieldFixCPR

What it does

Cleans up external data in CPR format, for use in a scheduled integration.

String are cleaned using the CPR translateInput method. Data will be cleaned before inserting without the use of this codeunit, but lookups and such might fail if the CPR is formatted poorly.

How to invoke

Insert value in field mapping:

Designer > Integration > Import sources > [integration] > [fieldmapping] > Codeunit handler

dk.p2e.blanket.codeunit.common.IntegrationFieldFixCPR

Configuration

None.

Developer info

IntegrationFieldFixDate

What it does

Cleans up external data in date format, for use in a scheduled integration.

String are cleaned using the date translateInput method. Data will be cleaned before inserting without the use of this codeunit, but lookups and such might fail if the date is not formatted as YYYY-MM-DD.

How to invoke

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

  dk.p2e.blanket.codeunit.common.IntegrationFieldFixDate

Configuration

[All possible configurations and where to edit them]

Developer info

IntegrationFieldLookupKey

What it does

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.

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@';

Developer info

IntegrationFieldValueMap

What it does

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

Values will be swapped from a list provided to this codeunit.

An empty string will be returned if no match can be found.

How to invoke

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

dk.p2e.blanket.codeunit.common.IntegrationFieldValueMap

Configuration

Insert value maps seperated by "@" in:

[fieldmapping] > Configuration values

Example:

Tesla Model S@Large car
Hummer@Large car
Toyota Corolla@Medium car
Suzuki Swift@Small car

Developer info