1. Home
  2. Products
  3. Cloud Billing Database
  4. Documentation
  5. 1.0
  6. API
  7. Tables
  8. Hourly Report
  9. Select

Cloud Billing API - Hourly Report - Select

select

Navigation

Link

root

Common link which links to the root level of the service.

tag
a (look at the href attribute for the URL)
id
root
Link

parent

Common link which links to the parent resource.

tag
a (look at the href attribute for the URL)
id
parent
Link

self

Common link which links to this resource.

tag
a (look at the href attribute for the URL)
id
self

Data

tag
code
id
data__
classes
  • data

{
  "tableName": "aws_billing_detailed_line_items",
  "columns": [],
  "whereClauses": [],
  "limit": 2,
  "query": "SELECT * FROM aws_billing_detailed_line_items ORDER BY id_ LIMIT ? ",
  "parameters": [
    2
  ],
  "records": [
    {
      "id_": "20130112345678901200000000000000000000",
      "account_": "123456789012",
      "month_": "2013-01",
      "invoice_i_d": "26889551",
      "payer_account_id": "123456789012",
      "linked_account_id": "123456789012",
      "record_type": "LineItem",
      "product_name": "Amazon DynamoDB",
      "rate_id": "816217",
      "subscription_id": "7490543",
      "pricing_plan_id": "189632",
      "usage_type": "ReadCapacityUnit-Hrs",
      "operation": "CommittedThroughput",
      "reserved_instance": false,
      "item_description": "$0.00 per hour for 10 units of read capacity for a month (free tier)",
      "usage_start_date": "2013-01-01T00:00:00Z",
      "usage_end_date": "2013-01-01T01:00:00Z",
      "usage_quantity": 0.63407806,
      "rate": 0E-10,
      "cost": 0E-8
    },
    {
      "id_": "20130112345678901200000000000000000001",
      "account_": "123456789012",
      "month_": "2013-01",
      "invoice_i_d": "26889551",
      "payer_account_id": "123456789012",
      "linked_account_id": "123456789012",
      "record_type": "LineItem",
      "product_name": "Amazon DynamoDB",
      "rate_id": "816217",
      "subscription_id": "7490543",
      "pricing_plan_id": "189632",
      "usage_type": "ReadCapacityUnit-Hrs",
      "operation": "CommittedThroughput",
      "reserved_instance": false,
      "item_description": "$0.00 per hour for 10 units of read capacity for a month (free tier)",
      "usage_start_date": "2013-01-01T01:00:00Z",
      "usage_end_date": "2013-01-01T02:00:00Z",
      "usage_quantity": 1.22933444,
      "rate": 0E-10,
      "cost": 0E-8
    }
  ]
}