Difference between pages "Codeunit/Integration/IntegrationFieldLookupKey" and "Course notes for today"

Revision as of 08:43, 8 October 2021

Servers

Credentials

@@ Line 1: / Line 1: @@
-== 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.
+== Slides for today ==
+https://www.tempusserva.dk/share/training/PFM300.pdf
-Note that the @VALUE@ is SQL escaped for security reasons.
+== Servers for today ==
-== How to invoke ==
+Servers
-Insert value in field mapping
+* http://training.tempusserva.dk/cgi1/login
-Designer > Integration > Import sources > [intergration] > [fieldmapping] > Codeunit handler
+* http://training.tempusserva.dk/cgi2/login
+* http://training.tempusserva.dk/cgi3/login
+* http://training.tempusserva.dk/cgi4/login
+* http://training.tempusserva.dk/cgi5/login
+* http://training.tempusserva.dk/cgi6/login
-   dk.p2e.blanket.codeunit.common.IntegrationFieldLookupKey
+Credentials
+* username: WHITEBOARD
+* password: WHITEBOARD
-== 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