# 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: 436,
key: 'EXAMPLE-key-Value',
is_favorite: false
),
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: 92,
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_1Kmru' => {
'stringValue' => 'EXAMPLE-stringValue-Value',
'intValue' => 870,
'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: 3,
name: 'EXAMPLE-name-Value',
description: 'EXAMPLE-description-Value',
port_type: 'DATA',
fields: [
OCI::DataIntegration::Models::DynamicProxyField.new(
model_type: 'DYNAMIC_PROXY_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_aMHqo' => {
'stringValue' => 'EXAMPLE-stringValue-Value',
'intValue' => 988,
'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: 595,
name: 'EXAMPLE-name-Value',
description: 'EXAMPLE-description-Value',
type:
OCI::DataIntegration::Models::MapType.new(
model_type: 'MAP_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: 335,
description: 'EXAMPLE-description-Value',
key_element_type: 'EXAMPLE-keyElementType-Value',
value_element_type: 'EXAMPLE-valueElementType-Value',
contains_null: true
),
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_OysNd' => {
'stringValue' => 'EXAMPLE-stringValue-Value',
'intValue' => 745,
'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: 217,
name: 'EXAMPLE-name-Value',
description: 'EXAMPLE-description-Value',
port_type: 'CONTROL',
fields: [
OCI::DataIntegration::Models::DerivedField.new(
model_type: 'DERIVED_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_HCBFP' => {
'stringValue' => 'EXAMPLE-stringValue-Value',
'intValue' => 564,
'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: 189,
name: 'EXAMPLE-name-Value',
description: 'EXAMPLE-description-Value',
expr:
OCI::DataIntegration::Models::Expression.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'
),
expr_string: 'EXAMPLE-exprString-Value',
config_values:
OCI::DataIntegration::Models::ConfigValues.new(
config_param_values: {
'EXAMPLE_KEY_LTByO' => {
'stringValue' => 'EXAMPLE-stringValue-Value',
'intValue' => 417,
'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: 904
),
type: 'EXAMPLE-type-Value',
is_use_inferred_type: true,
labels: %w[EXAMPLE--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_oxubz' => {
'stringValue' => 'EXAMPLE-stringValue-Value',
'intValue' => 12,
'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: 804,
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: true,
is_output: false,
output_aggregation_type: 'COUNT',
type_name: 'EXAMPLE-typeName-Value',
used_for: 'EXAMPLE-usedFor-Value'
)
],
op_config_values:
OCI::DataIntegration::Models::ConfigValues.new(
config_param_values: {
'EXAMPLE_KEY_Yu7rv' => {
'stringValue' => 'EXAMPLE-stringValue-Value',
'intValue' => 637,
'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_DQ51q' => {
'simpleValue' => 'EXAMPLE-simpleValue-Value',
'rootObjectValue' => 'EXAMPLE-rootObjectValue-Value'
}
}
),
is_concurrent_allowed: false,
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: 859
),
sql_script_type: 'SQL_CODE',
operation: 'EXAMPLE-operation-Value'
)
)
# Get the data from response
puts "#{create_task_response.data}"