activity (dataLoading)
Applies when
type = dataLoading| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
name | string | Yes | data type=string; maxLen=255Enter a name for the workflow activity. | |
type | enum | Yes | data type=string; lov=PLUGINSValid values: dataLoading |
dataLoading
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
dataLoadDefinition | reference | Yes | data type=reference; lov=COMPONENT; references=dataLoadDefinition |
dataLoading {
dataLoadDefinition: @component
}sourceData
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
sourceDataType | enum | Yes | fileBrowseItem | data type=string; maxLen=4000; lov=STATICValid values: fileBrowseItem sqlQuery textareaItem |
fileBrowseItem | string | Yes | data type=string; maxLen=4000; textCase=UPPERApplies when source_data_type = FILE | |
textareaItem | string | Yes | data type=string; maxLen=4000; textCase=UPPERApplies when source_data_type = TEXT | |
sqlQuery | string | Yes | data type=string; maxLen=4000Applies when source_data_type = SQL_QUERY | |
xlsxSheetNameItem | string | No | data type=string; maxLen=4000; textCase=UPPER |
sourceData {
sourceDataType: fileBrowseItem
fileBrowseItem: value
textareaItem: value
sqlQuery: value
xlsxSheetNameItem: value
}processingResult
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
processedRowCountItem | string | No | data type=string; maxLen=4000; textCase=UPPER | |
errorRowCountItem | string | No | data type=string; maxLen=4000; textCase=UPPER |
processingResult {
processedRowCountItem: value
errorRowCountItem: value
}genAI
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
enabled | boolean | Yes | false | data type=boolean |
agent | reference | No | data type=reference; lov=COMPONENT; references=aiAgentApplies when enabled = true | |
service | reference | No | data type=reference; lov=COMPONENT; references=genAIServiceApplies when enabled = true | |
systemPrompt | multiline string | No | data type=multiline string; maxLen=32767Applies when enabled = true |
genAI {
enabled: false
agent: @component
service: @component
systemPrompt: ```
value
```
}source
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
location | enum | Yes | localDatabase | data type=string; lov=STATICValid values: localDatabase restEnabledSql |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: plsql javaScript-mleApplies when location = localDatabase |
plsqlCode | multiline string | Yes | data type=multiline string; maxLen=32767Applies when location = localDatabase and language = plsql | |
javaScriptCode | multiline string | Yes | data type=multiline string; maxLen=32767Applies when location = localDatabase and language = javaScript-mle | |
remoteServer | reference | Yes | data type=reference; lov=COMPONENT; references=restEnabledSqlDatabaseApplies when location = restEnabledSql | |
plsqlCode | multiline string | Yes | data type=multiline string; maxLen=32767Applies when location = restEnabledSqlEnter 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
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
sqlQuery | multiline string | No | data type=multiline string; maxLen=4000Enter 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
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
dueOnType | enum | No | data type=string; lov=STATICValid values: interval sqlQuery expression functionBody schedulerExpression | |
interval | string | Yes | data type=string; maxLen=255Applies when dueOnType = interval | |
sqlQuery | multiline string | Yes | data type=multiline string; maxLen=4000Applies when dueOnType = sqlQuery | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: sql plsql javaScript-mleApplies when dueOnType = expression |
sqlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when dueOnType = expression and language = sql | |
plsqlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when dueOnType = expression and language = plsql | |
javaScriptExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when dueOnType = expression and language = javaScript-mle | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: plsql javaScript-mleApplies when dueOnType = functionBody |
plsqlFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when dueOnType = functionBody and language = plsql | |
javaScriptFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when dueOnType = functionBody and language = javaScript-mle | |
schedulerExpression | multiline string | Yes | data type=multiline string; maxLen=255Applies when dueOnType = 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
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
sequence | number | Yes | data type=number; maxLen=22 |
layout {
sequence: 42
}parallelFlow
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
branch | reference | No | data type=reference; lov=COMPONENT; references=branch |
parallelFlow {
branch: @component
}advanced
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
staticId | string | Yes | data type=string; maxLen=255 | |
label | string | No | data type=string; maxLen=4000 | |
diagram | string | No | data type=string; maxLen=32767 |
advanced {
staticId: value
label: value
diagram: value
}comments
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
comments | multiline string | No | data type=multiline string; maxLen=4000 |
comments {
comments: ```
value
```
}APEXlang Example
activity sample (
name: value
type: dataLoading
dataLoading {
dataLoadDefinition: @component
}
sourceData {
sourceDataType: fileBrowseItem
fileBrowseItem: value
textareaItem: value
sqlQuery: value
xlsxSheetNameItem: value
}
processingResult {
processedRowCountItem: value
errorRowCountItem: value
}
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
```
}
)