activity (invokeApi)
Applies when
type = invokeApi| 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: invokeApi |
invoke
| Property | Type | Required | Default Value | Details |
|---|---|---|---|---|
type | enum | Yes | plsqlPackage | data type=string; maxLen=4000; lov=STATICValid values: plsqlProcedureOrFunction restSource plsqlPackage |
owner | string | No | data type=string; maxLen=128Applies when type in (PLSQL_PACKAGE)type in (PLSQL_PROCEDURE_FUNCTION) | |
package | string | Yes | data type=string; maxLen=128Applies when type = PLSQL_PACKAGE | |
procedureOrFunction | string | Yes | data type=string; maxLen=128Applies when type = PLSQL_PACKAGE | |
procedureOrFunction | string | Yes | data type=string; maxLen=128Applies when type = PLSQL_PROCEDURE_FUNCTION | |
restSource | reference | Yes | data type=reference; lov=COMPONENT; references=restDataSourceApplies when type = WEB_SOURCE | |
operation | reference | Yes | data type=reference; lov=COMPONENT; references=operationApplies when type = WEB_SOURCE |
invoke {
type: plsqlProcedureOrFunction
owner: value
package: value
procedureOrFunction: value
restSource: @component
operation: @component
}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: invokeApi
invoke {
type: plsqlProcedureOrFunction
owner: value
package: value
procedureOrFunction: value
restSource: @component
operation: @component
}
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
```
}
)