Retrieve the restorable times for a given EC2 MSSQL database

Returns a list of time intervals (start timestamp and end timestamp) in which the MSSQL database can be restored.

Path Parameters

database_id string required
Performs the operation on a database within the specified database id.

Query Parameters

limit int64
Limits the size of the response on each page to the specified number of items.
start string
Sets the page token used to browse the collection. Leave this parameter empty to get the first page. Other pages can be traversed using HATEOAS links.
filter string
Narrows down the results to only the items that satisfy the filter criteria. The following table lists the supported filter fields for this resource and the filter conditions that can be applied on those fields:

Field Filter Condition Description
timestamp $lte, $gt Filter pitr intervals whose range is "less than or equal to" or "greater than" a given timestamp.
For more information about filtering, refer to the Filtering section of this guide.

Field	Filter Condition	Description
timestamp	$lte, $gt	Filter pitr intervals whose range is "less than or equal to" or "greater than" a given timestamp.

Responses

200
default

ListEC2MssqlDatabasePitrIntervalsResponse represents the success response

application/api.clumio.ec2-mssql-databases=v1+json

Schema
Example (from schema)

Schema

_embedded object
Embedded responses related to the resource.
items object[]
A collection of requested items.
_embedded object
Embedded responses related to the resource.
_links object
URLs to pages related to the resource.
restore-ec2-mssql-database object
A resource-specific HATEOAS link.
href string
The URI for the referenced operation.
templated boolean
Determines whether the "href" link is a URI template. If set to true, the "href" link is a URI template.
type string
The HTTP method to be used with the "href" link for the referenced operation.
end_timestamp string
End timestamp of the interval. Represented in RFC-3339 format.
start_timestamp string
Start timestamp of the interval. Represented in RFC-3339 format.
_links object
URLs to pages related to the resource.
_first object
The HATEOAS link to the first page of results.
href string
The URI for the referenced operation.
templated boolean
Determines whether the "href" link is a URI template. If set to true, the "href" link is a URI template.
type string
The HTTP method to be used with the "href" link for the referenced operation.
_next object
The HATEOAS link to the next page of results.
href string
The URI for the referenced operation.
templated boolean
Determines whether the "href" link is a URI template. If set to true, the "href" link is a URI template.
type string
The HTTP method to be used with the "href" link for the referenced operation.
_self object
The HATEOAS link to this resource.
href string
The URI for the referenced operation.
templated boolean
Determines whether the "href" link is a URI template. If set to true, the "href" link is a URI template.
type string
The HTTP method to be used with the "href" link for the referenced operation.
current_count int64
The number of items listed on the current page.
filter_applied string
The filter used in the request. The filter includes both manually-specified and system-generated filters.
limit int64
The maximum number of items displayed per page in the response.
start string
The page token used to get this response.

{
  "_embedded": {
    "items": [
      {
        "_embedded": {},
        "_links": {
          "restore-ec2-mssql-database": {
            "href": "string",
            "templated": true,
            "type": "string"
          }
        },
        "end_timestamp": "string",
        "start_timestamp": "string"
      }
    ]
  },
  "_links": {
    "_first": {
      "href": "string",
      "templated": true,
      "type": "string"
    },
    "_next": {
      "href": "string",
      "templated": true,
      "type": "string"
    },
    "_self": {
      "href": "string",
      "templated": true,
      "type": "string"
    }
  },
  "current_count": 0,
  "filter_applied": "string",
  "limit": 0,
  "start": "string"
}

Error

application/json

Schema
Example (from schema)

Schema

errors object[]
A list of errors encountered during runtime.
error_code uint32
error_message string
The reason for the error.

{
  "errors": [
    {
      "error_code": 0,
      "error_message": "string"
    }
  ]
}

GET /datasources/aws/ec2-mssql/databases/:database_id/pitr-intervals

Authorization

Request

Click Edit to configure Base URL

https://us-west-2.api.clumio.com

Bearer Token

database_id — path required

limit — query

start — query

filter — query

curl -L -X GET 'https://us-west-2.api.clumio.com/datasources/aws/ec2-mssql/databases/:database_id/pitr-intervals' \
-H 'Accept: application/api.clumio.ec2-mssql-databases=v1+json' \
-H 'Authorization: Bearer <TOKEN>'

curl -L -X GET 'https://us-west-2.api.clumio.com/datasources/aws/ec2-mssql/databases/:database_id/pitr-intervals' \
-H 'Accept: application/api.clumio.ec2-mssql-databases=v1+json' \
-H 'Authorization: Bearer <TOKEN>'

curl -L -X GET 'https://us-west-2.api.clumio.com/datasources/aws/ec2-mssql/databases/:database_id/pitr-intervals' \
-H 'Accept: application/api.clumio.ec2-mssql-databases=v1+json' \
-H 'Authorization: Bearer <TOKEN>'

curl -L -X GET 'https://us-west-2.api.clumio.com/datasources/aws/ec2-mssql/databases/:database_id/pitr-intervals' \
-H 'Accept: application/api.clumio.ec2-mssql-databases=v1+json' \
-H 'Authorization: Bearer <TOKEN>'

curl -L -X GET 'https://us-west-2.api.clumio.com/datasources/aws/ec2-mssql/databases/:database_id/pitr-intervals' \
-H 'Accept: application/api.clumio.ec2-mssql-databases=v1+json' \
-H 'Authorization: Bearer <TOKEN>'

curl -L -X GET 'https://us-west-2.api.clumio.com/datasources/aws/ec2-mssql/databases/:database_id/pitr-intervals' \
-H 'Accept: application/api.clumio.ec2-mssql-databases=v1+json' \
-H 'Authorization: Bearer <TOKEN>'

curl -L -X GET 'https://us-west-2.api.clumio.com/datasources/aws/ec2-mssql/databases/:database_id/pitr-intervals' \
-H 'Accept: application/api.clumio.ec2-mssql-databases=v1+json' \
-H 'Authorization: Bearer <TOKEN>'

Retrieve the restorable times for a given EC2 MSSQL database​

Authorization

Request

Retrieve the restorable times for a given EC2 MSSQL database