tableLookup

Parent: legacyDataLoadDefinition

Applies whenskipValidation = false

Direct Properties:

PropertyTypeRequiredDefault ValueDetails
columnNamestringYesdata type=string; maxLen=32767

Property Groups:

  • source
  • compareUploadWith
  • lookup
  • error
  • advanced
source
PropertyTypeRequiredDefault ValueDetails
tableOwnerstringYesdata type=string; maxLen=32767
tableNamestringYesdata type=string; maxLen=128
whereClausemultiline stringNodata type=multiline string; maxLen=4000
The where clause will be used as part of the SQL used to retrieve the Return Column from the lookup table.
 
source {
  tableOwner: value
  tableName: value
  whereClause: ```sql
    value
  ```
}
compareUploadWith
PropertyTypeRequiredDefault ValueDetails
columnstringYesdata type=string; maxLen=32767
column2stringNodata type=string; maxLen=32767
column3stringNodata type=string; maxLen=32767
 
compareUploadWith {
  column: value
  column2: value
  column3: value
}
lookup
PropertyTypeRequiredDefault ValueDetails
returnColumnstringYesdata type=string; maxLen=32767
Select the name of the column returned by the table lookup. This value will be inserted into the load column specified, and is generally the key value of the parent in a foreign key relationship. For example: DEPTNO.
 
lookup {
  returnColumn: value
}
error
PropertyTypeRequiredDefault ValueDetails
errorMessagemultiline stringNodata type=multiline string; maxLen=4000
The error message will be displayed to end users when an error occurs with trying to retrieve the return column from the lookup table using the lookup column(s) provided.
 
error {
  errorMessage: ```
    value
  ```
}
advanced
PropertyTypeRequiredDefault ValueDetails
insertNewValuebooleanYesfalsedata type=boolean
 
advanced {
  insertNewValue: false
}

APEXlang Example

tableLookup sample (
    columnName: value
    source {
        tableOwner: value
        tableName: value
        whereClause: ```sql
          value
        ```
    }
    compareUploadWith {
        column: value
        column2: value
        column3: value
    }
    lookup {
        returnColumn: value
    }
    error {
        errorMessage: ```
          value
        ```
    }
    advanced {
        insertNewValue: false
    }
)