OK
{- "items": [
- {
- "id": "string",
- "name": "string",
- "replication_mode": "ENGINE_DATA_REPLICATION",
- "engine_id": "string",
- "target_engine_id": "string",
- "target_host": "string",
- "target_port": 8415,
- "type": "string",
- "description": "string",
- "last_execution_status": "RUNNING",
- "last_execution_status_timestamp": "2019-08-24T14:15:22Z",
- "schedule": "string",
- "replication_tag": "string",
- "replication_objects": [
- "string"
], - "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "enable_tag_replication": true,
- "bandwidth_limit": 0,
- "number_of_connections": 1,
- "encrypted": false,
- "automatic_replication": false,
- "use_system_socks_setting": false,
- "vdb_ids": [
- "string"
], - "dsource_ids": [
- "string"
], - "cdb_ids": [
- "string"
], - "vcdb_ids": [
- "string"
], - "group_ids": [
- "string"
], - "replicate_entire_engine": true,
- "data_layout_ids": [
- "string"
]
}
], - "response_metadata": {
- "prev_cursor": "string",
- "next_cursor": "string",
- "total": 0
}
}
The parameters to create a ReplicationProfile.
ReplicationProfile created
The request example is intended for creating a ReplicationProfile.
{- "name": "replication-profile-name",
- "replication_mode": "ENGINE_DATA_REPLICATION",
- "engine_id": 1,
- "target_engine_id": 2,
- "target_port": 8415,
- "description": "description",
- "schedule": "0 0 0 * * ?",
- "tags": [
- {
- "key": "key1",
- "value": "value1"
}, - {
- "key": "key2",
- "value": "value2"
}
], - "enable_tag_replication": true,
- "bandwidth_limit": 0,
- "number_of_connections": 1,
- "encrypted": false,
- "automatic_replication": false,
- "use_system_socks_setting": false,
- "group_ids": [
- "1-GROUP-1"
]
}
{- "job": {
- "id": "job-123",
- "status": "RUNNING",
- "is_waiting_for_telemetry": true,
- "type": "DB_REFRESH",
- "localized_type": "DB Refresh",
- "error_details": "Unable to connect to the engine.",
- "warning_message": "Failed to remove local MaskingJob, engineId: 3 localMaskingJobId: 7.",
- "target_id": "vdb-123",
- "target_name": "vdb",
- "start_time": "2022-01-02T05:11:24.148Z",
- "update_time": "2022-01-02T06:11:24.148Z",
- "trace_id": "string",
- "engine_ids": [
- "string"
], - "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "engines": [
- {
- "engine_id": "string",
- "engine_name": "string"
}
], - "account_id": 1,
- "account_name": "User 1",
- "percent_complete": 50,
- "virtualization_tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "execution_id": "string"
}, - "replication_profile_id": "1-REPLICATION_PROFILE-1"
}
A request body containing a filter expression. This enables searching for items matching arbitrarily complex conditions. The list of attributes which can be used in filter expressions is available in the x-filterable vendor extension.
Note: All keywords are case-insensitive
Operator | Description | Example |
---|---|---|
CONTAINS | Substring or membership testing for string and list attributes respectively. | field3 CONTAINS 'foobar', field4 CONTAINS TRUE |
IN | Tests if field is a member of a list literal. List can contain a maximum of 100 values | field2 IN ['Goku', 'Vegeta'] |
GE | Tests if a field is greater than or equal to a literal value | field1 GE 1.2e-2 |
GT | Tests if a field is greater than a literal value | field1 GT 1.2e-2 |
LE | Tests if a field is less than or equal to a literal value | field1 LE 9000 |
LT | Tests if a field is less than a literal value | field1 LT 9.02 |
NE | Tests if a field is not equal to a literal value | field1 NE 42 |
EQ | Tests if a field is equal to a literal value | field1 EQ 42 |
The SEARCH operator filters for items which have any filterable
attribute that contains the input string as a substring, comparison
is done case-insensitively. This is not restricted to attributes with
string values. Specifically SEARCH '12'
would match an item with an
attribute with an integer value of 123
.
Ordered by precedence.
Operator | Description | Example |
---|---|---|
NOT | Logical NOT (Right associative) | NOT field1 LE 9000 |
AND | Logical AND (Left Associative) | field1 GT 9000 AND field2 EQ 'Goku' |
OR | Logical OR (Left Associative) | field1 GT 9000 OR field2 EQ 'Goku' |
Parenthesis ()
can be used to override operator precedence.
For example: NOT (field1 LT 1234 AND field2 CONTAINS 'foo')
Literal | Description | Examples |
---|---|---|
Nil | Represents the absence of a value | nil, Nil, nIl, NIL |
Boolean | true/false boolean | true, false, True, False, TRUE, FALSE |
Number | Signed integer and floating point numbers. Also supports scientific notation. | 0, 1, -1, 1.2, 0.35, 1.2e-2, -1.2e+2 |
String | Single or double quoted | "foo", "bar", "foo bar", 'foo', 'bar', 'foo bar' |
Datetime | Formatted according to RFC3339 | 2018-04-27T18:39:26.397237+00:00 |
List | Comma-separated literals wrapped in square brackets | [0], [0, 1], ['foo', "bar"] |
OK
An example of a nested Object comparison testing that at least one repository has a version which is equal to 19.0.0.
{- "filter_expression": "repositories CONTAINS {version eq '19.0.0'}"
}
{- "items": [
- {
- "id": "string",
- "name": "string",
- "replication_mode": "ENGINE_DATA_REPLICATION",
- "engine_id": "string",
- "target_engine_id": "string",
- "target_host": "string",
- "target_port": 8415,
- "type": "string",
- "description": "string",
- "last_execution_status": "RUNNING",
- "last_execution_status_timestamp": "2019-08-24T14:15:22Z",
- "schedule": "string",
- "replication_tag": "string",
- "replication_objects": [
- "string"
], - "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "enable_tag_replication": true,
- "bandwidth_limit": 0,
- "number_of_connections": 1,
- "encrypted": false,
- "automatic_replication": false,
- "use_system_socks_setting": false,
- "vdb_ids": [
- "string"
], - "dsource_ids": [
- "string"
], - "cdb_ids": [
- "string"
], - "vcdb_ids": [
- "string"
], - "group_ids": [
- "string"
], - "replicate_entire_engine": true,
- "data_layout_ids": [
- "string"
]
}
], - "response_metadata": {
- "prev_cursor": "string",
- "next_cursor": "string",
- "total": 0
}
}
{- "job": {
- "id": "job-123",
- "status": "RUNNING",
- "is_waiting_for_telemetry": true,
- "type": "DB_REFRESH",
- "localized_type": "DB Refresh",
- "error_details": "Unable to connect to the engine.",
- "warning_message": "Failed to remove local MaskingJob, engineId: 3 localMaskingJobId: 7.",
- "target_id": "vdb-123",
- "target_name": "vdb",
- "start_time": "2022-01-02T05:11:24.148Z",
- "update_time": "2022-01-02T06:11:24.148Z",
- "trace_id": "string",
- "engine_ids": [
- "string"
], - "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "engines": [
- {
- "engine_id": "string",
- "engine_name": "string"
}
], - "account_id": 1,
- "account_name": "User 1",
- "percent_complete": 50,
- "virtualization_tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "execution_id": "string"
}
}
{- "id": "string",
- "name": "string",
- "replication_mode": "ENGINE_DATA_REPLICATION",
- "engine_id": "string",
- "target_engine_id": "string",
- "target_host": "string",
- "target_port": 8415,
- "type": "string",
- "description": "string",
- "last_execution_status": "RUNNING",
- "last_execution_status_timestamp": "2019-08-24T14:15:22Z",
- "schedule": "string",
- "replication_tag": "string",
- "replication_objects": [
- "string"
], - "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "enable_tag_replication": true,
- "bandwidth_limit": 0,
- "number_of_connections": 1,
- "encrypted": false,
- "automatic_replication": false,
- "use_system_socks_setting": false,
- "vdb_ids": [
- "string"
], - "dsource_ids": [
- "string"
], - "cdb_ids": [
- "string"
], - "vcdb_ids": [
- "string"
], - "group_ids": [
- "string"
], - "replicate_entire_engine": true,
- "data_layout_ids": [
- "string"
]
}
{- "job": {
- "id": "job-123",
- "status": "RUNNING",
- "is_waiting_for_telemetry": true,
- "type": "DB_REFRESH",
- "localized_type": "DB Refresh",
- "error_details": "Unable to connect to the engine.",
- "warning_message": "Failed to remove local MaskingJob, engineId: 3 localMaskingJobId: 7.",
- "target_id": "vdb-123",
- "target_name": "vdb",
- "start_time": "2022-01-02T05:11:24.148Z",
- "update_time": "2022-01-02T06:11:24.148Z",
- "trace_id": "string",
- "engine_ids": [
- "string"
], - "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "engines": [
- {
- "engine_id": "string",
- "engine_name": "string"
}
], - "account_id": 1,
- "account_name": "User 1",
- "percent_complete": 50,
- "virtualization_tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "execution_id": "string"
}
}
OK
{- "name": "string",
- "description": "string",
- "target_engine_id": "string",
- "target_host": "string",
- "target_port": 65535,
- "replication_mode": "ENGINE_DATA_REPLICATION",
- "schedule": "string",
- "vdb_ids": [
- "string"
], - "dsource_ids": [
- "string"
], - "cdb_ids": [
- "string"
], - "vcdb_ids": [
- "string"
], - "group_ids": [
- "string"
], - "enable_tag_replication": true,
- "replicate_entire_engine": true,
- "bandwidth_limit": 0,
- "number_of_connections": 1,
- "encrypted": true,
- "automatic_replication": true,
- "use_system_socks_setting": true
}
{- "job": {
- "id": "job-123",
- "status": "RUNNING",
- "is_waiting_for_telemetry": true,
- "type": "DB_REFRESH",
- "localized_type": "DB Refresh",
- "error_details": "Unable to connect to the engine.",
- "warning_message": "Failed to remove local MaskingJob, engineId: 3 localMaskingJobId: 7.",
- "target_id": "vdb-123",
- "target_name": "vdb",
- "start_time": "2022-01-02T05:11:24.148Z",
- "update_time": "2022-01-02T06:11:24.148Z",
- "trace_id": "string",
- "engine_ids": [
- "string"
], - "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
], - "engines": [
- {
- "engine_id": "string",
- "engine_name": "string"
}
], - "account_id": 1,
- "account_name": "User 1",
- "percent_complete": 50,
- "virtualization_tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "tasks": [
- {
- "id": "string",
- "parent_job_id": "string",
- "start_time": "2019-08-24T14:15:22Z",
- "end_time": "2019-08-24T14:15:22Z",
- "title": "string",
- "percent_complete": 100,
- "events": [
- {
- "message_details": "string"
}
], - "status": "PENDING"
}
], - "execution_id": "string"
}
}