# This is an automatically generated code sample.
# To make this code sample work in your Oracle Cloud tenancy,
# please replace the values for any parameters whose current values do not fit
# your use case (such as resource IDs, strings containing ‘EXAMPLE’ or ‘unique_id’, and
# boolean, number, and enum parameters with values not fitting your use case).
require 'oci'
# Create a default config using DEFAULT profile in default location
# Refer to https://docs.cloud.oracle.com/en-us/iaas/Content/API/Concepts/sdkconfig.htm#SDK_and_CLI_Configuration_File for more info
config = OCI::ConfigFileLoader.load_config
# Initialize service client with default config file
data_integration_client =
OCI::DataIntegration::DataIntegrationClient.new(config: config)
# Send the request to service, some parameters are not required, see API doc for more info
create_task_response =
data_integration_client.create_task(
'ocid1.test.oc1..<unique_ID>EXAMPLE-workspaceId-Value',
OCI::DataIntegration::Models::CreateTaskFromSQLTask.new(
model_type: 'SQL_TASK',
name: 'EXAMPLE-name-Value',
identifier: 'EXAMPLE-identifier-Value',
registry_metadata:
OCI::DataIntegration::Models::RegistryMetadata.new(
aggregator_key: 'EXAMPLE-aggregatorKey-Value',
labels: %w[EXAMPLE--Value],
registry_version: 802,
key: 'EXAMPLE-key-Value',
is_favorite: true
),
key: 'EXAMPLE-key-Value',
model_version: 'EXAMPLE-modelVersion-Value',
parent_ref:
OCI::DataIntegration::Models::ParentReference.new(
parent: 'EXAMPLE-parent-Value',
root_doc_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-rootDocId-Value'
),
description: 'EXAMPLE-description-Value',
object_status: 175,
input_ports: [
OCI::DataIntegration::Models::InputPort.new(
model_type: 'INPUT_PORT',
key: 'EXAMPLE-key-Value',
model_version: 'EXAMPLE-modelVersion-Value',
parent_ref:
OCI::DataIntegration::Models::ParentReference.new(
parent: 'EXAMPLE-parent-Value',
root_doc_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-rootDocId-Value'
),
config_values:
OCI::DataIntegration::Models::ConfigValues.new(
config_param_values: {
'EXAMPLE_KEY_ohW1m' => {
'stringValue' => 'EXAMPLE-stringValue-Value',
'intValue' => 23,
'objectValue' => 'EXAMPLE-objectValue-Value',
'refValue' => 'EXAMPLE-refValue-Value',
'parameterValue' => 'EXAMPLE-parameterValue-Value',
'rootObjectValue' => 'EXAMPLE-rootObjectValue-Value'
}
},
parent_ref:
OCI::DataIntegration::Models::ParentReference.new(
parent: 'EXAMPLE-parent-Value',
root_doc_id:
'ocid1.test.oc1..<unique_ID>EXAMPLE-rootDocId-Value'
)
),
object_status: 935,
name: 'EXAMPLE-name-Value',
description: 'EXAMPLE-description-Value',
port_type: 'CONTROL',
fields: [
OCI::DataIntegration::Models::DynamicInputField.new(
model_type: 'DYNAMIC_INPUT_FIELD',
key: 'EXAMPLE-key-Value',
model_version: 'EXAMPLE-modelVersion-Value',
parent_ref:
OCI::DataIntegration::Models::ParentReference.new(
parent: 'EXAMPLE-parent-Value',
root_doc_id:
'ocid1.test.oc1..<unique_ID>EXAMPLE-rootDocId-Value'
),
config_values:
OCI::DataIntegration::Models::ConfigValues.new(
config_param_values: {
'EXAMPLE_KEY_E3upV' => {
'stringValue' => 'EXAMPLE-stringValue-Value',
'intValue' => 132,
'objectValue' => 'EXAMPLE-objectValue-Value',
'refValue' => 'EXAMPLE-refValue-Value',
'parameterValue' => 'EXAMPLE-parameterValue-Value',
'rootObjectValue' => 'EXAMPLE-rootObjectValue-Value'
}
},
parent_ref:
OCI::DataIntegration::Models::ParentReference.new(
parent: 'EXAMPLE-parent-Value',
root_doc_id:
'ocid1.test.oc1..<unique_ID>EXAMPLE-rootDocId-Value'
)
),
object_status: 793,
name: 'EXAMPLE-name-Value',
description: 'EXAMPLE-description-Value',
type:
OCI::DataIntegration::Models::JavaType.new(
model_type: 'JAVA_TYPE',
key: 'EXAMPLE-key-Value',
model_version: 'EXAMPLE-modelVersion-Value',
parent_ref:
OCI::DataIntegration::Models::ParentReference.new(
parent: 'EXAMPLE-parent-Value',
root_doc_id:
'ocid1.test.oc1..<unique_ID>EXAMPLE-rootDocId-Value'
),
name: 'EXAMPLE-name-Value',
object_status: 878,
description: 'EXAMPLE-description-Value',
java_type_name: 'EXAMPLE-javaTypeName-Value',
config_definition:
OCI::DataIntegration::Models::ConfigDefinition.new(
key: 'EXAMPLE-key-Value',
model_type: 'EXAMPLE-modelType-Value',
model_version: 'EXAMPLE-modelVersion-Value',
parent_ref:
OCI::DataIntegration::Models::ParentReference.new(
parent: 'EXAMPLE-parent-Value',
root_doc_id:
'ocid1.test.oc1..<unique_ID>EXAMPLE-rootDocId-Value'
),
name: 'EXAMPLE-name-Value',
is_contained: true,
object_status: 191,
config_parameter_definitions: {
'EXAMPLE_KEY_NLtsm' => {
'parameterName' => 'EXAMPLE-parameterName-Value',
'description' => 'EXAMPLE-description-Value',
'defaultValue' => 'EXAMPLE-defaultValue-Value',
'classFieldName' => 'EXAMPLE-classFieldName-Value',
'isStatic' => False,
'isClassFieldValue' => False
}
}
)
),
labels: %w[EXAMPLE--Value]
)
]
)
],
output_ports: [
OCI::DataIntegration::Models::OutputPort.new(
model_type: 'OUTPUT_PORT',
key: 'EXAMPLE-key-Value',
model_version: 'EXAMPLE-modelVersion-Value',
parent_ref:
OCI::DataIntegration::Models::ParentReference.new(
parent: 'EXAMPLE-parent-Value',
root_doc_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-rootDocId-Value'
),
config_values:
OCI::DataIntegration::Models::ConfigValues.new(
config_param_values: {
'EXAMPLE_KEY_gWGjt' => {
'stringValue' => 'EXAMPLE-stringValue-Value',
'intValue' => 475,
'objectValue' => 'EXAMPLE-objectValue-Value',
'refValue' => 'EXAMPLE-refValue-Value',
'parameterValue' => 'EXAMPLE-parameterValue-Value',
'rootObjectValue' => 'EXAMPLE-rootObjectValue-Value'
}
},
parent_ref:
OCI::DataIntegration::Models::ParentReference.new(
parent: 'EXAMPLE-parent-Value',
root_doc_id:
'ocid1.test.oc1..<unique_ID>EXAMPLE-rootDocId-Value'
)
),
object_status: 838,
name: 'EXAMPLE-name-Value',
description: 'EXAMPLE-description-Value',
port_type: 'CONTROL',
fields: [
OCI::DataIntegration::Models::FlowPort.new(
model_type: 'FLOW_PORT',
key: 'EXAMPLE-key-Value',
model_version: 'EXAMPLE-modelVersion-Value',
parent_ref:
OCI::DataIntegration::Models::ParentReference.new(
parent: 'EXAMPLE-parent-Value',
root_doc_id:
'ocid1.test.oc1..<unique_ID>EXAMPLE-rootDocId-Value'
),
config_values:
OCI::DataIntegration::Models::ConfigValues.new(
config_param_values: {
'EXAMPLE_KEY_WkEWe' => {
'stringValue' => 'EXAMPLE-stringValue-Value',
'intValue' => 846,
'objectValue' => 'EXAMPLE-objectValue-Value',
'refValue' => 'EXAMPLE-refValue-Value',
'parameterValue' => 'EXAMPLE-parameterValue-Value',
'rootObjectValue' => 'EXAMPLE-rootObjectValue-Value'
}
},
parent_ref:
OCI::DataIntegration::Models::ParentReference.new(
parent: 'EXAMPLE-parent-Value',
root_doc_id:
'ocid1.test.oc1..<unique_ID>EXAMPLE-rootDocId-Value'
)
),
object_status: 896,
name: 'EXAMPLE-name-Value',
description: 'EXAMPLE-description-Value'
)
]
)
],
parameters: [
OCI::DataIntegration::Models::Parameter.new(
model_type: 'PARAMETER',
key: 'EXAMPLE-key-Value',
model_version: 'EXAMPLE-modelVersion-Value',
parent_ref:
OCI::DataIntegration::Models::ParentReference.new(
parent: 'EXAMPLE-parent-Value',
root_doc_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-rootDocId-Value'
),
config_values:
OCI::DataIntegration::Models::ConfigValues.new(
config_param_values: {
'EXAMPLE_KEY_0lWi7' => {
'stringValue' => 'EXAMPLE-stringValue-Value',
'intValue' => 750,
'objectValue' => 'EXAMPLE-objectValue-Value',
'refValue' => 'EXAMPLE-refValue-Value',
'parameterValue' => 'EXAMPLE-parameterValue-Value',
'rootObjectValue' => 'EXAMPLE-rootObjectValue-Value'
}
},
parent_ref:
OCI::DataIntegration::Models::ParentReference.new(
parent: 'EXAMPLE-parent-Value',
root_doc_id:
'ocid1.test.oc1..<unique_ID>EXAMPLE-rootDocId-Value'
)
),
object_status: 100,
name: 'EXAMPLE-name-Value',
description: 'EXAMPLE-description-Value',
type: 'EXAMPLE-type-Value',
default_value: 'EXAMPLE-defaultValue-Value',
root_object_default_value: 'EXAMPLE-rootObjectDefaultValue-Value',
is_input: false,
is_output: true,
output_aggregation_type: 'MAX',
type_name: 'EXAMPLE-typeName-Value',
used_for: 'EXAMPLE-usedFor-Value'
)
],
op_config_values:
OCI::DataIntegration::Models::ConfigValues.new(
config_param_values: {
'EXAMPLE_KEY_gwW5o' => {
'stringValue' => 'EXAMPLE-stringValue-Value',
'intValue' => 267,
'objectValue' => 'EXAMPLE-objectValue-Value',
'refValue' => 'EXAMPLE-refValue-Value',
'parameterValue' => 'EXAMPLE-parameterValue-Value',
'rootObjectValue' => 'EXAMPLE-rootObjectValue-Value'
}
},
parent_ref:
OCI::DataIntegration::Models::ParentReference.new(
parent: 'EXAMPLE-parent-Value',
root_doc_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-rootDocId-Value'
)
),
config_provider_delegate:
OCI::DataIntegration::Models::CreateConfigProvider.new(
bindings: {
'EXAMPLE_KEY_bdTVW' => {
'simpleValue' => 'EXAMPLE-simpleValue-Value',
'rootObjectValue' => 'EXAMPLE-rootObjectValue-Value'
}
}
),
script:
OCI::DataIntegration::Models::Script.new(
key: 'EXAMPLE-key-Value',
model_type: 'EXAMPLE-modelType-Value',
model_version: 'EXAMPLE-modelVersion-Value',
parent_ref:
OCI::DataIntegration::Models::ParentReference.new(
parent: 'EXAMPLE-parent-Value',
root_doc_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-rootDocId-Value'
),
object_status: 746
),
sql_script_type: 'STORED_PROCEDURE',
operation: 'EXAMPLE-operation-Value'
)
)
# Get the data from response
puts "#{create_task_response.data}"