# Group Datawarehouse
Group of all datawarehouse-related resources.

## Channeldetail 

Fetch channel details data by by option parameters

## Index [/datawarehouse/channeldetail/index{?from_date,to_date,group_by,catalog_ids,access_token}]

### Index [GET] 
In this example, we are getting data from 2014-01-01 through 2014-05-01.  The data is grouped by 'catalog' meaning we would see a breakdown of data by catalog

+ Parameters

    + from_date (required, date, `2014-01-01`)
    + to_date (required, date, `2014-05-01`)
    + group_by (required, varchar, `catalog`)
    + catalog_ids (required, varchar, `2586511,2809339,2074238`)
    + access_token (required, varchar, `some token`)

+ Request JSON Channeldetail
    
    + Headers

            Accept: application/json

+ Response 200 (application/json)

    + Body
{
  "envelope": {
    "header": {
      "apiVersion": "1.0",
      "baseUrl": "192.168.0.55",
      "httpStatusCode": 200
    },
    "request": "channeldetail/index?params=datawarehouse&channeldetail&index&json&2014-01-01&2014-05-01&catalog&2586511,2809339,2074238&<some_token>",
    "response": {
      "channel_details": [
        {
          "total": "189",
          "child_count": 2,
          "children": {
            "885686547977": {
              "total": "189",
              "release_id": "885686547977",
              "release_name": "Unknown Version",
              "percentage": "100"
            }
          },
          "name": "compilation test 1",
          "object_id": 2074238,
          "percentage": "99"
        },
        {
          "total": "1",
          "child_count": 1,
          "children": {
            "123456789123": {
              "total": "1",
              "release_id": "123456789123",
              "release_name": "Unknown Version",
              "percentage": "100"
            }
          },
          "name": "Release 6",
          "object_id": 2809339,
          "percentage": "1"
        },
        {
          "total": "1",
          "child_count": 1,
          "children": {
            "885686441466": {
              "total": "1",
              "release_id": "885686441466",
              "release_name": "Unknown Version",
              "percentage": "100"
            }
          },
          "name": "For Tomorrow",
          "object_id": 2586511,
          "percentage": "1"
        }
      ]
    }
  }
}

## Index [/datawarehouse/channeldetail/index{?from_date,to_date,group_by,isrc_ids,access_token,vendor_id}]

### Index [GET] 
In this example, we are getting data from 2014-01-01 through 2014-05-01.  The data is grouped by 'isrc' meaning we would see a breakdown of data by isrc

+ Parameters

    + from_date (required, date, `2013-08-06`)
    + to_date (required, date, `2013-09-06`)
    + group_by (required, varchar, `isrc`)
    + isrc_ids (required, varchar, `260527`)
    + access_token (required, varchar, `some token`)
    + vendor_id (optional, number, `8869`)
+ Request JSON Channeldetail
    
    + Headers

            Accept: application/json

+ Response 200 (application/json)

    + Body
{
  "envelope": {
    "header": {
      "apiVersion": "1.0",
      "baseUrl": "192.168.0.69",
      "httpStatusCode": 200
    },
    "request": "channeldetail/index?params=datawarehouse&channeldetail&index&json&2013-08-06&2013-09-06&isrc&260527&<some_token>&8869",
    "response": {
      "channel_details": []
    }
  }
}


+ **Other Optional Parameters**

    + limit
    + offset
    + from_date
    + to_date
    + vendor_id
    + group_by // catalog,country,imprint,genre,artist,release,track,subaccount,isrc,store,channel
    + with group respective ids are required ids // catalog_ids,country_ids,imprint_ids,genre_ids,artist_ids,release_ids,track_ids,subaccount_ids,isrc_ids,store_ids
    + sort_by
    + sort_order
