# Group Datawarehouse
Group of all datawarehouse-related resources.

## Channels 

The Channels resource is used to return detailed information about all the available channels.

## Index with sort params [/datawarehouse/channels/index{?limit,sort_by,sort_order}]

### Index [GET]

+ Parameters

    + limit (optional, number, `5`)
    + sort_by (optional, varchar, `transaction_type_id`)
    + sort_order (optional, varchar, `desc`)

+ Request JSON Message
    
    + Headers

            Accept: application/json

+ Response 200 (application/json)

    + Body
{
  "envelope": {
    "header": {
      "apiVersion": "1.0",
      "baseUrl": "192.168.0.57",
      "httpStatusCode": 200
    },
    "request": "channels/index?params=datawarehouse&channels&index&json&<some_token>&5&transaction_type_id&desc",
    "response": {
      "channels": [
        {
          "transaction_type_id": 30,
          "transaction_type_abbr": "VS",
          "transaction_type_desc": "Video Season"
        },
        {
          "transaction_type_id": 29,
          "transaction_type_abbr": "TA",
          "transaction_type_desc": "Tethered Album"
        },
        {
          "transaction_type_id": 28,
          "transaction_type_abbr": "CL",
          "transaction_type_desc": "Cloud Match Unit"
        },
        {
          "transaction_type_id": 27,
          "transaction_type_abbr": "NR",
          "transaction_type_desc": "Non-interactive Radio Revenue"
        },
        {
          "transaction_type_id": 26,
          "transaction_type_abbr": "PR",
          "transaction_type_desc": "Pre Cut Ringtone"
        }
      ],
      "total_records": "30"
    }
  }
}


## Index with search params [/datawarehouse/channels/index{?search_by,search_value}]

### Index [GET]

+ Parameters

    + search_by (optional, varchar, `transaction_type_desc`)
    + search_value (optional, varchar, `album`)

+ Request JSON Message
    
    + Headers

            Accept: application/json

+ Response 200 (application/json)

    + Body
{
  "envelope": {
    "header": {
      "apiVersion": "1.0",
      "baseUrl": "192.168.0.57",
      "httpStatusCode": 200
    },
    "request": "channels/index?params=datawarehouse&channels&index&json&<some_token>&10&transaction_type_desc&album",
    "response": {
      "channels": [
        {
          "transaction_type_id": 23,
          "transaction_type_abbr": "DA",
          "transaction_type_desc": "Download Albums"
        },
        {
          "transaction_type_id": 29,
          "transaction_type_abbr": "TA",
          "transaction_type_desc": "Tethered Album"
        },
        {
          "transaction_type_id": 6,
          "transaction_type_abbr": "UA",
          "transaction_type_desc": "Upgraded Download Albums"
        }
      ],
      "total_records": "3"
    }
  }
}


+ **Optional Parameters**

    + search_by
    + search_value
    + limit
    + offset
    + sort_by - column to order by 
    + sort_order - direction in which to order the data