# Get all billing usage

Endpoint: GET /billing-usage
Version: 5.1.45
Security: api_key

## Query parameters:

  - `start_date` (string, required)
    The date after which all billing usage should be retrieved. Date format is 'yyyy-MM-dd'.

  - `end_date` (string, required)
    The date before which all billing usage should be retrieved. Date format is 'yyyy-MM-dd'.

  - `page_number` (integer)
    The page number for which to billing usage. This will default to the first page if excluded

  - `page_size` (integer)
    The maximum number of objects to return. This will default to the DefaultApiPageSize setting property if not provided

## Response 200 fields (application/json):

  - `_pageInfo` (object)

  - `_pageInfo.numberOnPage` (integer)
    The number of items on this page. This should always match the page size unless it is the last page.

  - `_pageInfo.total` (integer)
    The total number of items

  - `totalSize` (number)
    Total size of the database from list of all database usage. It will be in bytes
    Example: 2695200768

  - `responseList` (array)
    Example: [{"databaseIdentifier":"testHost:testServiceName:testDbName","name":"testDbName","size":2695200768,"dbType":"oracle","billingPeriod":"2022 Oct - Dec (Q4)","failureReason":""}]

  - `responseList.databaseIdentifier` (string)
    The value of database identifier for uniquely identifying a database. The database properties will be colon separated.
    Example: "testHost:testServiceName:testDbName"

  - `responseList.name` (string)
    Name of the database.
    Example: "testDbName"

  - `responseList.size` (number)
    Size of the database in bytes.
    Example: 2695200768

  - `responseList.dbType` (string)
    Type of the database.
    Example: "oracle"

  - `responseList.billingPeriod` (string)
    The display value of billing period.
    Example: "2022 Oct - Dec (Q4)"

  - `responseList.failureReason` (string)
    Reason in case unable to calculate database size.


## Response 401 fields