# List all staging sources.

Endpoint: GET /staging-sources
Version: 3.17.0
Security: ApiKeyAuth

## Security:

  - `ApiKeyAuth` (unknown)
    apiKey in header Authorization

## Query parameters:

  - `limit` (integer)
    Maximum number of objects to return per query. The value must be between 1 and 1000. Default is 100.

  - `cursor` (string)
    Cursor to fetch the next or previous page of results. The value of this property must be extracted from the 'prev_cursor' or 'next_cursor' property of a PaginatedResponseMetadata which is contained in the response of list and search API endpoints.

  - `sort` (string)
    The field to sort results by. A property name with a prepended '-' signifies descending order.

## Response 200:

  - `200` (unknown)
    OK

## Response 200 fields (application/json):

  - `items` (array)

  - `items.id` (string)
    The Staging Source object entity ID.

  - `items.name` (string)
    The name of this staging source database.

  - `items.database_type` (string)
    The type of this staging source database.

  - `items.database_name` (string)
    The name of container database of associated with this staging source database.

  - `items.database_version` (string)
    The version of container database associated with this staging source database.

  - `items.environment_id` (string)
    A reference to the Environment that hosts this staging source database.

  - `items.data_uuid` (string)
    A universal ID that uniquely identifies this staging source database.

  - `items.ip_address` (string)
    The IP address of the staging source's host.

  - `items.fqdn` (string)
    The FQDN of the staging source's host.

  - `items.repository` (string)
    The repository id for this staging source.

  - `items.oracle_config_type` (string)
    Enum: "OracleRACConfig", "OracleSIConfig", "OraclePDBConfig"

  - `items.cdb_type` (string)
    The cdb type for this staging source. (Oracle only)

  - `items.dsource_id` (string)
    The dsource_id associated with this staging source.

  - `items.tags` (array)

  - `items.tags.key` (string, required)
    Key of the tag
    Example: key-1

  - `items.tags.value` (string, required)
    Value of the tag
    Example: value-1

  - `items.oracle_services` (array)

  - `items.oracle_services.discovered` (boolean)
    Represents whether this jdbc connection string is auto discovered or not.

  - `items.oracle_services.jdbc_connection_string` (string)
    The jdbc connection string used to connect with the database.
    Example: jdbc:oracle:thin:@(DESCRIPTION=(ENABLE=broken)(ADDRESS=(PROTOCOL=tcp)(HOST=10.110.230.197)(PORT=1521))(CONNECT_DATA=(UR=A)(SERVICE_NAME=VDBOMSRBBDC6C_UJG)))

  - `errors` (array)
    Sadly, sometimes requests to the API are not successful. Failures can occur for a wide range of reasons. The Errors object contains information about full or partial failures which might have occurred during the request.

  - `errors.message` (string)
    Message providing more detail about the error that occurred, if available.

  - `errors.object_name` (string)
    Name of the object affected by the error.

  - `response_metadata` (object)

  - `response_metadata.prev_cursor` (string)
    Pointer to the previous page of results. Use this value as a cursor query parameter in a subsequent request, along with limit, to navigate through the collection by virtual page.

  - `response_metadata.next_cursor` (string)
    Pointer to the next page of results. Use this value as a cursor query parameter in a subsequent request, along with limit, to navigate through the collection by virtual page.

  - `response_metadata.total` (integer)
    The total number of results. This value may not be provided.