automation

Parent: app

Children: action, parameteractionsInitiatedOn in (rowsReturned) and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable = false; actionsInitiatedOn in (rowsReturned) and location = restSource and restSource is set and actionsInitiatedOn in (noRowsReturned) and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable = false; actionsInitiatedOn in (rowsReturned) and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable = false; actionsInitiatedOn in (rowsReturned) and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and actionsInitiatedOn in (noRowsReturned) and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable = false; actionsInitiatedOn in (rowsReturned) and location = restSource and restSource is set and actionsInitiatedOn in (noRowsReturned) and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable = false; actionsInitiatedOn in (rowsReturned) and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable = false; actionsInitiatedOn in (rowsReturned) and location = restSource and restSource is set and actionsInitiatedOn in (noRowsReturned) and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable = false; actionsInitiatedOn in (noRowsReturned) and location = restSource and restSource is set and actionsInitiatedOn in (rowsReturned) and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable = false; actionsInitiatedOn in (noRowsReturned) and location = restSource and restSource is set and restSource supports HAS_SYNC_HAS_NO_ARRAY_COLUMNS and useLocalTable = false; actionsInitiatedOn in (noRowsReturned) and location = restSource and restSource is set and actionsInitiatedOn in (rowsReturned) and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable = false; actionsInitiatedOn in (noRowsReturned) and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and actionsInitiatedOn in (rowsReturned) and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable = false; actionsInitiatedOn in (noRowsReturned) and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and restSource supports HAS_SYNC_ALL_ARRAY_COLUMNS and useLocalTable = false; actionsInitiatedOn in (noRowsReturned) and location = restSource and restSource is set and actionsInitiatedOn in (rowsReturned) and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable = false; actionsInitiatedOn in (noRowsReturned) and location = restSource and restSource is set and restSource supports HAS_ARRAY_COLUMNS and nestedRows supports IS_SYNCED and useLocalTable = false

Direct Properties:

Property Groups:

• execution
• source
• dataProfile
• restSynchronization
• externalFilterAndOrderBy
• localPostProcessing
• columnMapping
• actionExecution
• additionalCodeExecution
• advanced
• serverSideCondition
• config
• comments

execution {
  type: onDemand
  scheduleExpression: ```
    value
  ```
  scheduleStatus: active
  actionsInitiatedOn: rowsReturned
}

source {
  location: localDatabase
  remoteServer: @component
  language: plsql
  plsqlFunctionBody: ```plsql
    value
  ```
  javaScriptFunctionBody: ```javascript-mle
    value
  ```
  sampleData: employees
  type: tableView
  tableOwner: value
  tableName: value
  includeRowidColumn: false
  whereClause: ```sql
    value
  ```
  graphOwner: value
  graphName: value
  matchClause: ```
    value
  ```
  columnsClause: ```
    value
  ```
  orderByClause: ```sql
    value
  ```
  sqlQuery: ```sql
    value
  ```
  restSource: @component
  jsonDualityView: @component
  jsonSource: @component
  optimizerHint: value
}

dataProfile {
  nestedRows: @component
}

restSynchronization {
  useLocalTable: false
}

externalFilterAndOrderBy {
  enabled: false
  filter: ```
    value
  ```
  orderBy: ```
    value
  ```
}

localPostProcessing {
  type: whereOrderByClause
  whereClause: ```sql
    value
  ```
  orderByClause: ```sql
    value
  ```
  sqlQuery: ```sql
    value
  ```
  language: plsql
  plsqlFunctionBody: ```plsql
    value
  ```
  javaScriptFunctionBody: ```javascript-mle
    value
  ```
}

columnMapping {
  primaryKeyColumn: value
}

actionExecution {
  commit: once
  maxRowsToProcess: 42
  actionErrorHandling: ignore
}

additionalCodeExecution {
  plsqlCode: ```plsql
    value
  ```
  initProcedureName: value
  beforeRowProcessingProcedureName: value
  cleanupProcedureName: value
}

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
  ```
}

config {
  buildOption: @component
}

comments {
  comments: ```
    value
  ```
}

automation sample (
    name: value
    execution {
        type: onDemand
        scheduleExpression: ```
          value
        ```
        scheduleStatus: active
        actionsInitiatedOn: rowsReturned
    }
    source {
        location: localDatabase
        remoteServer: @component
        language: plsql
        plsqlFunctionBody: ```plsql
          value
        ```
        javaScriptFunctionBody: ```javascript-mle
          value
        ```
        sampleData: employees
        type: tableView
        tableOwner: value
        tableName: value
        includeRowidColumn: false
        whereClause: ```sql
          value
        ```
        graphOwner: value
        graphName: value
        matchClause: ```
          value
        ```
        columnsClause: ```
          value
        ```
        orderByClause: ```sql
          value
        ```
        sqlQuery: ```sql
          value
        ```
        restSource: @component
        jsonDualityView: @component
        jsonSource: @component
        optimizerHint: value
    }
    dataProfile {
        nestedRows: @component
    }
    restSynchronization {
        useLocalTable: false
    }
    externalFilterAndOrderBy {
        enabled: false
        filter: ```
          value
        ```
        orderBy: ```
          value
        ```
    }
    localPostProcessing {
        type: whereOrderByClause
        whereClause: ```sql
          value
        ```
        orderByClause: ```sql
          value
        ```
        sqlQuery: ```sql
          value
        ```
        language: plsql
        plsqlFunctionBody: ```plsql
          value
        ```
        javaScriptFunctionBody: ```javascript-mle
          value
        ```
    }
    columnMapping {
        primaryKeyColumn: value
    }
    actionExecution {
        commit: once
        maxRowsToProcess: 42
        actionErrorHandling: ignore
    }
    additionalCodeExecution {
        plsqlCode: ```plsql
          value
        ```
        initProcedureName: value
        beforeRowProcessingProcedureName: value
        cleanupProcedureName: value
    }
    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
        ```
    }
    config {
        buildOption: @component
    }
    comments {
        comments: ```
          value
        ```
    }
)