# Group Datawarehouse
Group of all datawarehouse-related resources.
## Stats [/datawarehouse/stats{?from_date,to_date,group_by,transaction_type_id}{&isrcIds}{&artistIds}{&releaseIds}{&trackIds}{&genreIds}{&countryIds}{&storeIds}{&imprintIds}{&socialIds}{&catalog_ids}]

+ Parameters

    + from_date (date, `2013-08-06`) ... date from which data should be retrieved
    + to_date (date, `2013-09-06`) ... date to which data should be retrieved
    + group_by (varchar, `channel`) ... dimension by which to group the data options are country, imprint, genre, artist, release, track, subaccount.  all data will be grouped by date also
    + transaction_type_id (number, `23`) ... required parameter specifying for which channel(transaction type) data should be retrieved
    + isrcIds (varchar, optional) ... comma separated filter list
    + artistIds (varchar, optional) ... comma separated filter list
    + releaseIds (varchar, optional) ... comma separated filter list
    + trackIds (varchar, optional) ... comma separated filter list
    + genreIds (varchar, optional) ... comma separated filter list
    + countryIds (varchar, optional) ... comma separated filter list
    + storeIds (varchar, optional) ... comma separated filter list
    + imprintIds (varchar, optional) ... comma separated filter list
    + socialIds (varchar, optional) ... comma separated filter list
    + catalog_ids (varchar, optional) ... comma separated filter list

### Retrieve Stats [GET]
In this example, we are getting data from 2013-08-06 through 2013-09-06.
The data is grouped by 'catalog' and we have specified two catalogIds, our results should show two sets of data

+ Request JSON Stats

    + Headers

            Accept: application/json

+ Response 200 (application/json)

    + Body

          {"envelope":{"header":{"apiVersion":"1.0","baseUrl":"stats.vapi.devorch.com","httpStatusCode":200},"request":"stats\/index?params=datawarehouse&stats&index&json&2013-08-06&2013-09-06&channel&23&&&&&&&&&&","response":{"stats":[{"display_date":"2013-08-08","transaction_type_id":23,"transaction_type_abbr":"DA","object_id":23,"name":"DA","activities":"843","activities_paid":743,"total_reported_sales_count":[[1375761600,25],[1375848000,23],[1375934400,64],[1376020800,39],[1376107200,28],[1376193600,36],[1376280000,34],[1376366400,29],[1376452800,30],[1376539200,21],[1376625600,26],[1376712000,25],[1376798400,23],[1376884800,22],[1376971200,14],[1377057600,25],[1377144000,21],[1377230400,23],[1377316800,32],[1377403200,19],[1377489600,12],[1377576000,37],[1377662400,16],[1377748800,35],[1377835200,21],[1377921600,16],[1378008000,15],[1378094400,42],[1378180800,29],[1378267200,21],[1378353600,18],[1378440000,22]]},{"display_date":"2013-08-21","transaction_type_id":19,"transaction_type_abbr":"DT","object_id":19,"name":"DT","activities":"2.857","activities_paid":2857,"total_reported_sales_count":[[1375761600,121],[1375848000,87],[1375934400,59],[1376020800,142],[1376107200,94],[1376193600,58],[1376280000,107],[1376366400,69],[1376452800,69],[1376539200,87],[1376625600,71],[1376712000,115],[1376798400,109],[1376884800,94],[1376971200,71],[1377057600,154],[1377144000,60],[1377230400,109],[1377316800,79],[1377403200,63],[1377489600,81],[1377576000,88],[1377662400,75],[1377748800,90],[1377835200,126],[1377921600,80],[1378008000,61],[1378094400,134],[1378180800,56],[1378267200,67],[1378353600,97],[1378440000,84]]},{"display_date":"2013-08-22","transaction_type_id":20,"transaction_type_abbr":"TD","object_id":20,"name":"TD","activities":"14.605","activities_paid":14605,"total_reported_sales_count":[[1375761600,406],[1375848000,565],[1375934400,542],[1376020800,309],[1376107200,435],[1376193600,377],[1376280000,310],[1376366400,340],[1376452800,525],[1376539200,508],[1376625600,465],[1376712000,469],[1376798400,497],[1376884800,384],[1376971200,402],[1377057600,413],[1377144000,1085],[1377230400,708],[1377316800,527],[1377403200,420],[1377489600,431],[1377576000,442],[1377662400,424],[1377748800,420],[1377835200,345],[1377921600,420],[1378008000,563],[1378094400,360],[1378180800,413],[1378267200,295],[1378353600,403],[1378440000,402]]},{"display_date":"2013-08-28","transaction_type_id":10,"transaction_type_abbr":"AS","object_id":10,"name":"AS","activities":"45.130","activities_paid":38763,"total_reported_sales_count":[[1375761600,1172],[1375848000,1205],[1375934400,1420],[1376020800,1006],[1376107200,951],[1376193600,928],[1376280000,1216],[1376366400,900],[1376452800,1326],[1376539200,1039],[1376625600,939],[1376712000,711],[1376798400,824],[1376884800,1108],[1376971200,1138],[1377057600,1042],[1377144000,1120],[1377230400,1733],[1377316800,1376],[1377403200,1405],[1377489600,1767],[1377576000,2161],[1377662400,2192],[1377748800,2047],[1377835200,1866],[1377921600,1501],[1378008000,1713],[1378094400,2142],[1378180800,1809],[1378267200,1822],[1378353600,1840],[1378440000,1711]]},{"display_date":"2013-09-03","transaction_type_id":1,"transaction_type_abbr":"S","object_id":1,"name":"S","activities":"83.090","activities_paid":82967,"total_reported_sales_count":[[1375761600,2384],[1375848000,2535],[1375934400,2502],[1376020800,2197],[1376107200,1946],[1376193600,1510],[1376280000,1921],[1376366400,2146],[1376452800,2118],[1376539200,2186],[1376625600,1897],[1376712000,1654],[1376798400,1354],[1376884800,1814],[1376971200,2202],[1377057600,1756],[1377144000,1979],[1377230400,3514],[1377316800,2730],[1377403200,2418],[1377489600,3183],[1377576000,3322],[1377662400,3431],[1377748800,3563],[1377835200,3563],[1377921600,2894],[1378008000,2583],[1378094400,3508],[1378180800,3756],[1378267200,3663],[1378353600,3678],[1378440000,3183]]}]}}}