action (loadUploadedData)
Applies when
type = loadUploadedData| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
name | string | Yes | data type=string; maxLen=255Enter a name for the automation action. | |
type | enum | Yes | data type=string; lov=PLUGINSValid values: loadUploadedData |
dataLoading
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
dataLoadDefinition | reference | Yes | data type=reference; lov=COMPONENT; references=legacyDataLoadDefinition |
dataLoading {
dataLoadDefinition: @component
}processingResult
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
insertCountItem | string | No | data type=string; maxLen=4000; textCase=UPPER | |
updateCountItem | string | No | data type=string; maxLen=4000; textCase=UPPER | |
errorCountItem | string | No | data type=string; maxLen=4000; textCase=UPPER | |
reviewCountItem | string | No | data type=string; maxLen=4000; textCase=UPPER |
processingResult {
insertCountItem: value
updateCountItem: value
errorCountItem: value
reviewCountItem: 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
}execution
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
sequence | number | Yes | data type=number; maxLen=22 |
execution {
sequence: 42
}error
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
errorMessage | multiline string | No | data type=multiline string; maxLen=4000Enter an error message to be written to the automation log when the processing fails. Use #SQLERRM# as a placeholder for the actual ORA error message. | |
stopExecutionOnError | boolean | Yes | true | data type=boolean |
error {
errorMessage: ```
value
```
stopExecutionOnError: false
}advanced
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
staticId | string | Yes | data type=string; maxLen=255 |
advanced {
staticId: value
}serverSideCondition
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
type | enum | No | data type=string; lov=STATICValid values: rowsReturned noRowsReturned expression functionBody item=value item!=value itemIsNull itemIsNotNull itemIsZero itemIsNotZero itemIsNullOrZero itemIsNotNullAndNotZero itemContainsNoSpaces itemIsNumeric itemIsNotNumeric itemIsAlphanumeric itemIsInColonDelimitedList itemIsNotInColonDelimitedList textIsContainedInItem text=value text!=value textIsContainedInValue textIsNotContainedInValue never | |
sqlQuery | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type in (rowsReturned)type in (noRowsReturned) | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: sql plsql javaScript-mleApplies when type = expression |
sqlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = expression and language = sql | |
plsqlExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = expression and language = plsql | |
javaScriptExpression | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = expression and language = javaScript-mle | |
language | enum | Yes | plsql | data type=string; lov=STATICValid values: plsql javaScript-mleApplies when type = functionBody |
plsqlFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = functionBody and language = plsql | |
javaScriptFunctionBody | multiline string | Yes | data type=multiline string; maxLen=4000Applies when type = functionBody and language = javaScript-mle | |
item | string | Yes | data type=string; maxLen=4000; textCase=UPPERApplies when type in (item=value)type in (item!=value)type in (VALUE_OF_ITEM_IN_COND_1_EQ_COND_2)type in (VALUE_OF_ITEM_IN_COND_1_NOT_EQ_COND_2)type in (itemIsNull)type in (itemIsNotNull)type in (itemIsZero)type in (itemIsNotZero)type in (itemIsNullOrZero)type in (itemIsNotNullAndNotZero)type in (itemContainsNoSpaces)type in (itemIsNumeric)type in (itemIsNotNumeric)type in (itemIsAlphanumeric)type in (itemIsInColonDelimitedList)type in (itemIsNotInColonDelimitedList) | |
text | string | Yes | data type=string; maxLen=4000Applies when type in (textIsContainedInItem)type in (textIsContainedInValue)type in (textIsNotContainedInValue)type in (text=value)type in (text!=value) | |
value | string | Yes | data type=string; maxLen=4000Applies when type in (item=value)type in (item!=value)type in (VALUE_OF_ITEM_IN_COND_1_EQ_COND_2)type in (VALUE_OF_ITEM_IN_COND_1_NOT_EQ_COND_2) | |
list | array of strings | Yes | data type=string; maxLen=4000Applies when type in (itemIsInColonDelimitedList)type in (itemIsNotInColonDelimitedList) | |
item | string | Yes | data type=string; maxLen=4000; textCase=UPPERApplies when type = textIsContainedInItem | |
value | string | Yes | data type=string; maxLen=4000Applies when type in (textIsContainedInValue)type in (textIsNotContainedInValue)type in (text=value)type in (text!=value) | |
executeCondition | enum | Yes | forEachRow | data type=string; lov=STATICValid values: forEachRow onceApplies when type is setSpecify whether the condition is to be executed for each row or only once. |
serverSideCondition {
type: rowsReturned
sqlQuery: ```sql
value
```
language: sql
sqlExpression: ```sql
value
```
plsqlExpression: ```plsql
value
```
javaScriptExpression: ```javascript-mle
value
```
plsqlFunctionBody: ```plsql
value
```
javaScriptFunctionBody: ```javascript-mle
value
```
item: value
text: value
value: value
list: [
value
value
]
executeCondition: forEachRow
}config
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
buildOption | reference | No | data type=reference; lov=COMPONENT; references=buildOption |
config {
buildOption: @component
}comments
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
comments | multiline string | No | data type=multiline string; maxLen=4000 |
comments {
comments: ```
value
```
}APEXlang Example
action sample (
name: value
type: loadUploadedData
dataLoading {
dataLoadDefinition: @component
}
processingResult {
insertCountItem: value
updateCountItem: value
errorCountItem: value
reviewCountItem: value
}
source {
location: localDatabase
language: plsql
plsqlCode: ```plsql
value
```
javaScriptCode: ```javascript-mle
value
```
remoteServer: @component
}
execution {
sequence: 42
}
error {
errorMessage: ```
value
```
stopExecutionOnError: false
}
advanced {
staticId: value
}
serverSideCondition {
type: rowsReturned
sqlQuery: ```sql
value
```
language: sql
sqlExpression: ```sql
value
```
plsqlExpression: ```plsql
value
```
javaScriptExpression: ```javascript-mle
value
```
plsqlFunctionBody: ```plsql
value
```
javaScriptFunctionBody: ```javascript-mle
value
```
item: value
text: value
value: value
list: [
value
value
]
executeCondition: forEachRow
}
config {
buildOption: @component
}
comments {
comments: ```
value
```
}
)