OK
{- "items": [
- {
- "id": "bookmark-123",
- "name": "my-bookmark-123",
- "creation_date": "2021-07-04T08:51:34.148Z",
- "data_timestamp": "2021-06-03T08:51:34.148Z",
- "timeflow_id": "1-TIMEFLOW-1",
- "location": "200000",
- "vdb_ids": [
- "vdb-123",
- "vdb-456"
], - "dsource_ids": [
- "dsource-123",
- "dsource-456"
], - "vdb_group_id": "vdb-group-123",
- "vdb_group_name": "my-vdb-group",
- "vdbs": [
- {
- "vdb_id": "vdb-id-1",
- "vdb_name": "vdb-name"
}
], - "dsources": [
- {
- "dsource_id": "dsource-id-1",
- "dsource_name": "dsource-name"
}
], - "retention": 365,
- "expiration": "2021-07-04T00:00:00.000Z",
- "status": "RESTORED",
- "replicated_dataset": true,
- "bookmark_source": "DCT",
- "bookmark_status": "ACTIVE",
- "ss_data_layout_id": "string",
- "ss_bookmark_reference": "string",
- "ss_bookmark_errors": [
- "No snapshots found for JS_BOOKMARK-1 at timestamp 2021-07-04T08:51:34.148"
], - "bookmark_type": "PRIVATE",
- "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}, - {
- "key": "key-2",
- "value": "value-2"
}
]
}
], - "response_metadata": {
- "prev_cursor": "string",
- "next_cursor": "string",
- "total": 0
}
}
The parameters to create a bookmark.
OK
{- "name": "my-bookmark-123",
- "vdb_ids": [
- "vdb-123",
- "vdb-456"
], - "vdb_group_id": "vdb-group-123",
- "snapshot_ids": [
- "snapshot-1",
- "snapshot-2"
], - "timeflow_ids": [
- "timeflow-1",
- "timeflow-2"
], - "timestamp": "2021-05-01T08:51:34.148Z",
- "timestamp_in_database_timezone": "2021-08-14T14:55:20.507Z",
- "location": "112233",
- "retention": 365,
- "expiration": "2021-07-04T00:00:00.000Z",
- "retain_forever": false,
- "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}, - {
- "key": "key-2",
- "value": "value-2"
}
], - "bookmark_type": "PUBLIC",
- "make_current_account_owner": true,
- "inherit_parent_vdb_tags": false,
- "inherit_parent_tags": false
}
{- "bookmark": {
- "id": "bookmark-123",
- "name": "my-bookmark-123",
- "creation_date": "2021-07-04T08:51:34.148Z",
- "data_timestamp": "2021-06-03T08:51:34.148Z",
- "timeflow_id": "1-TIMEFLOW-1",
- "location": "200000",
- "vdb_ids": [
- "vdb-123",
- "vdb-456"
], - "dsource_ids": [
- "dsource-123",
- "dsource-456"
], - "vdb_group_id": "vdb-group-123",
- "vdb_group_name": "my-vdb-group",
- "vdbs": [
- {
- "vdb_id": "vdb-id-1",
- "vdb_name": "vdb-name"
}
], - "dsources": [
- {
- "dsource_id": "dsource-id-1",
- "dsource_name": "dsource-name"
}
], - "retention": 365,
- "expiration": "2021-07-04T00:00:00.000Z",
- "status": "RESTORED",
- "replicated_dataset": true,
- "bookmark_source": "DCT",
- "bookmark_status": "ACTIVE",
- "ss_data_layout_id": "string",
- "ss_bookmark_reference": "string",
- "ss_bookmark_errors": [
- "No snapshots found for JS_BOOKMARK-1 at timestamp 2021-07-04T08:51:34.148"
], - "bookmark_type": "PRIVATE",
- "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}, - {
- "key": "key-2",
- "value": "value-2"
}
]
}, - "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"
}
}
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": "bookmark-123",
- "name": "my-bookmark-123",
- "creation_date": "2021-07-04T08:51:34.148Z",
- "data_timestamp": "2021-06-03T08:51:34.148Z",
- "timeflow_id": "1-TIMEFLOW-1",
- "location": "200000",
- "vdb_ids": [
- "vdb-123",
- "vdb-456"
], - "dsource_ids": [
- "dsource-123",
- "dsource-456"
], - "vdb_group_id": "vdb-group-123",
- "vdb_group_name": "my-vdb-group",
- "vdbs": [
- {
- "vdb_id": "vdb-id-1",
- "vdb_name": "vdb-name"
}
], - "dsources": [
- {
- "dsource_id": "dsource-id-1",
- "dsource_name": "dsource-name"
}
], - "retention": 365,
- "expiration": "2021-07-04T00:00:00.000Z",
- "status": "RESTORED",
- "replicated_dataset": true,
- "bookmark_source": "DCT",
- "bookmark_status": "ACTIVE",
- "ss_data_layout_id": "string",
- "ss_bookmark_reference": "string",
- "ss_bookmark_errors": [
- "No snapshots found for JS_BOOKMARK-1 at timestamp 2021-07-04T08:51:34.148"
], - "bookmark_type": "PRIVATE",
- "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}, - {
- "key": "key-2",
- "value": "value-2"
}
]
}
], - "response_metadata": {
- "prev_cursor": "string",
- "next_cursor": "string",
- "total": 0
}
}
{- "id": "bookmark-123",
- "name": "my-bookmark-123",
- "creation_date": "2021-07-04T08:51:34.148Z",
- "data_timestamp": "2021-06-03T08:51:34.148Z",
- "timeflow_id": "1-TIMEFLOW-1",
- "location": "200000",
- "vdb_ids": [
- "vdb-123",
- "vdb-456"
], - "dsource_ids": [
- "dsource-123",
- "dsource-456"
], - "vdb_group_id": "vdb-group-123",
- "vdb_group_name": "my-vdb-group",
- "vdbs": [
- {
- "vdb_id": "vdb-id-1",
- "vdb_name": "vdb-name"
}
], - "dsources": [
- {
- "dsource_id": "dsource-id-1",
- "dsource_name": "dsource-name"
}
], - "retention": 365,
- "expiration": "2021-07-04T00:00:00.000Z",
- "status": "RESTORED",
- "replicated_dataset": true,
- "bookmark_source": "DCT",
- "bookmark_status": "ACTIVE",
- "ss_data_layout_id": "string",
- "ss_bookmark_reference": "string",
- "ss_bookmark_errors": [
- "No snapshots found for JS_BOOKMARK-1 at timestamp 2021-07-04T08:51:34.148"
], - "bookmark_type": "PRIVATE",
- "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}, - {
- "key": "key-2",
- "value": "value-2"
}
]
}
The new data to update a Bookmark.
Bookmark update initiated.
{- "name": "my-bookmark-123",
- "expiration": "2021-07-04T00:00:00.000Z",
- "retain_forever": false,
- "bookmark_type": "PUBLIC"
}
{- "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
{- "items": [
- {
- "id": "123",
- "name": "my-first-vdb-group",
- "vdb_ids": [
- "vdb-123",
- "vdb-456"
], - "is_locked": false,
- "locked_by": 1,
- "locked_by_name": "admin",
- "vdb_group_source": "DCT",
- "ss_data_layout_id": "string",
- "vdbs": [
- {
- "vdb_id": "string",
- "vdb_name": "string",
- "last_refresh_time_with_group_refresh": "2022-05-29T15:00:00.000Z"
}
], - "database_type": "Oracle",
- "status": "RUNNING",
- "last_successful_refresh_to_bookmark_id": "bookmark-123",
- "last_successful_refresh_time": "2021-05-01T08:51:34.148Z",
- "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
]
}
], - "response_metadata": {
- "prev_cursor": "string",
- "next_cursor": "string",
- "total": 0
}
}
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": "123",
- "name": "my-first-vdb-group",
- "vdb_ids": [
- "vdb-123",
- "vdb-456"
], - "is_locked": false,
- "locked_by": 1,
- "locked_by_name": "admin",
- "vdb_group_source": "DCT",
- "ss_data_layout_id": "string",
- "vdbs": [
- {
- "vdb_id": "string",
- "vdb_name": "string",
- "last_refresh_time_with_group_refresh": "2022-05-29T15:00:00.000Z"
}
], - "database_type": "Oracle",
- "status": "RUNNING",
- "last_successful_refresh_to_bookmark_id": "bookmark-123",
- "last_successful_refresh_time": "2021-05-01T08:51:34.148Z",
- "tags": [
- {
- "key": "key-1",
- "value": "value-1"
}
]
}
], - "response_metadata": {
- "prev_cursor": "string",
- "next_cursor": "string",
- "total": 0
}
}
{- "job_id": "job-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"
}
}