activity (sendEMail)

Parent: activity

Applies whentype = sendEMail

Direct Properties:

PropertyTypeRequiredDefault ValueDetails
namestringYesdata type=string; maxLen=255
Enter a name for the workflow activity.
typeenumYesdata type=string; lov=PLUGINS
Valid values: sendEMail

Property Groups:

  • emailHeader
  • emailContent
  • emailAttachments
  • emailDispatchMode
  • emailTemplate
  • genAI
  • source
  • additionalData
  • deadline
  • layout
  • parallelFlow
  • advanced
  • comments
emailHeader
PropertyTypeRequiredDefault ValueDetails
fromstringYes&APP_EMAIL.data type=string; maxLen=4000
tostringYesdata type=string; maxLen=4000
ccstringNodata type=string; maxLen=4000
bccstringNodata type=string; maxLen=4000
emailHeader {
  from: value
  to: value
  cc: value
  bcc: value
}
emailContent
PropertyTypeRequiredDefault ValueDetails
replyTostringNodata type=string; maxLen=4000
subjectstringYesdata type=string; maxLen=4000
bodyPlainTextstringYesdata type=string; maxLen=4000
bodyHtmlstringNodata type=string; maxLen=4000
emailContent {
  replyTo: value
  subject: value
  bodyPlainText: value
  bodyHtml: value
}
emailAttachments
PropertyTypeRequiredDefault ValueDetails
attachmentSqlstringNodata type=string; maxLen=4000
emailAttachments {
  attachmentSql: value
}
emailDispatchMode
PropertyTypeRequiredDefault ValueDetails
sendImmediatelybooleanYesfalsedata type=boolean
emailDispatchMode {
  sendImmediately: false
}
emailTemplate
PropertyTypeRequiredDefault ValueDetails
emailTemplatereferenceNodata type=reference; lov=COMPONENT; references=emailTemplate
placeholderValuesstringNodata type=string; maxLen=4000
Applies whenemail_template_id is set
languageOverridestringNodata type=string; maxLen=128
Applies whenemail_template_id is set
escapeBodySubstitutionsenumNotruedata type=string; maxLen=4000; lov=STATIC
Valid values: false true
Applies whenbody_html is set
emailTemplate {
  emailTemplate: @component
  placeholderValues: value
  languageOverride: value
  escapeBodySubstitutions: false
}
genAI
PropertyTypeRequiredDefault ValueDetails
enabledbooleanYesfalsedata type=boolean
agentreferenceNodata type=reference; lov=COMPONENT; references=aiAgent
Applies whenenabled = true
servicereferenceNodata type=reference; lov=COMPONENT; references=genAIService
Applies whenenabled = true
systemPromptmultiline stringNodata type=multiline string; maxLen=32767
Applies whenenabled = true
genAI {
  enabled: false
  agent: @component
  service: @component
  systemPrompt: ```
    value
  ```
}
source
PropertyTypeRequiredDefault ValueDetails
locationenumYeslocalDatabasedata type=string; lov=STATIC
Valid values: localDatabase restEnabledSql
languageenumYesplsqldata type=string; lov=STATIC
Valid values: plsql javaScript-mle
Applies whenlocation = localDatabase
plsqlCodemultiline stringYesdata type=multiline string; maxLen=32767
Applies whenlocation = localDatabase and language = plsql
javaScriptCodemultiline stringYesdata type=multiline string; maxLen=32767
Applies whenlocation = localDatabase and language = javaScript-mle
remoteServerreferenceYesdata type=reference; lov=COMPONENT; references=restEnabledSqlDatabase
Applies whenlocation = restEnabledSql
plsqlCodemultiline stringYesdata type=multiline string; maxLen=32767
Applies whenlocation = restEnabledSql
Enter the PL/SQL code to be executed on the remote database.
source {
  location: localDatabase
  language: plsql
  plsqlCode: ```plsql
    value
  ```
  javaScriptCode: ```javascript-mle
    value
  ```
  remoteServer: @component
}
additionalData
PropertyTypeRequiredDefault ValueDetails
sqlQuerymultiline stringNodata type=multiline string; maxLen=4000

Enter a SQL query to read additional data.

The column names of the query can be used as bind variables and substitution strings to evaluate conditions or activity variables during the execution of the activity.

The result of the query should contain only one row.

If the query returns no result or more than one row then the activity fails during execution.

additionalData {
  sqlQuery: ```sql
    value
  ```
}
deadline
PropertyTypeRequiredDefault ValueDetails
dueOnTypeenumNodata type=string; lov=STATIC
Valid values: interval sqlQuery expression functionBody schedulerExpression
intervalstringYesdata type=string; maxLen=255
Applies whendueOnType = interval
sqlQuerymultiline stringYesdata type=multiline string; maxLen=4000
Applies whendueOnType = sqlQuery
languageenumYesplsqldata type=string; lov=STATIC
Valid values: sql plsql javaScript-mle
Applies whendueOnType = expression
sqlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whendueOnType = expression and language = sql
plsqlExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whendueOnType = expression and language = plsql
javaScriptExpressionmultiline stringYesdata type=multiline string; maxLen=4000
Applies whendueOnType = expression and language = javaScript-mle
languageenumYesplsqldata type=string; lov=STATIC
Valid values: plsql javaScript-mle
Applies whendueOnType = functionBody
plsqlFunctionBodymultiline stringYesdata type=multiline string; maxLen=4000
Applies whendueOnType = functionBody and language = plsql
javaScriptFunctionBodymultiline stringYesdata type=multiline string; maxLen=4000
Applies whendueOnType = functionBody and language = javaScript-mle
schedulerExpressionmultiline stringYesdata type=multiline string; maxLen=255
Applies whendueOnType = schedulerExpression
deadline {
  dueOnType: interval
  interval: value
  sqlQuery: ```sql
    value
  ```
  language: sql
  sqlExpression: ```sql
    value
  ```
  plsqlExpression: ```plsql
    value
  ```
  javaScriptExpression: ```javascript-mle
    value
  ```
  plsqlFunctionBody: ```plsql
    value
  ```
  javaScriptFunctionBody: ```javascript-mle
    value
  ```
  schedulerExpression: ```
    value
  ```
}
layout
PropertyTypeRequiredDefault ValueDetails
sequencenumberYesdata type=number; maxLen=22
layout {
  sequence: 42
}
parallelFlow
PropertyTypeRequiredDefault ValueDetails
branchreferenceNodata type=reference; lov=COMPONENT; references=branch
parallelFlow {
  branch: @component
}
advanced
PropertyTypeRequiredDefault ValueDetails
staticIdstringYesdata type=string; maxLen=255
labelstringNodata type=string; maxLen=4000
diagramstringNodata type=string; maxLen=32767
advanced {
  staticId: value
  label: value
  diagram: value
}
comments
PropertyTypeRequiredDefault ValueDetails
commentsmultiline stringNodata type=multiline string; maxLen=4000
comments {
  comments: ```
    value
  ```
}

APEXlang Example

activity sample (
    name: value
    type: sendEMail
    emailHeader {
        from: value
        to: value
        cc: value
        bcc: value
    }
    emailContent {
        replyTo: value
        subject: value
        bodyPlainText: value
        bodyHtml: value
    }
    emailAttachments {
        attachmentSql: value
    }
    emailDispatchMode {
        sendImmediately: false
    }
    emailTemplate {
        emailTemplate: @component
        placeholderValues: value
        languageOverride: value
        escapeBodySubstitutions: false
    }
    genAI {
        enabled: false
        agent: @component
        service: @component
        systemPrompt: ```
          value
        ```
    }
    source {
        location: localDatabase
        language: plsql
        plsqlCode: ```plsql
          value
        ```
        javaScriptCode: ```javascript-mle
          value
        ```
        remoteServer: @component
    }
    additionalData {
        sqlQuery: ```sql
          value
        ```
    }
    deadline {
        dueOnType: interval
        interval: value
        sqlQuery: ```sql
          value
        ```
        language: sql
        sqlExpression: ```sql
          value
        ```
        plsqlExpression: ```plsql
          value
        ```
        javaScriptExpression: ```javascript-mle
          value
        ```
        plsqlFunctionBody: ```plsql
          value
        ```
        javaScriptFunctionBody: ```javascript-mle
          value
        ```
        schedulerExpression: ```
          value
        ```
    }
    layout {
        sequence: 42
    }
    parallelFlow {
        branch: @component
    }
    advanced {
        staticId: value
        label: value
        diagram: value
    }
    comments {
        comments: ```
          value
        ```
    }
)