# Group Datawarehouse
Group of all datawarehouse-related resources.

## Analytics Details 

The Analytics Detail resource is used to retrieve detailed Analytics information retrieved from stores for vendor/subaccount's content.

## Index [/datawarehouse/analyticsdetail/index{?vendorId,fromDate,toDate,groupBy,sortBy,sortOrder,limit,offset,access_token}]

### Index [GET]

+ Parameters

    + vendorId (optional, number, `8020`)
    + fromDate (optional, varchar, `2013-08-08`)
    + toDate (optional, varchar, `2013-09-09`)
    + groupBy (optional, varchar, `release`)
    + sortBy (required, varchar, `activities`)
    + sortOrder (required, varchar, `desc`)
    + limit (required, number, `10`)
    + offset (optional, number, `0`)
    + access_token (required, varchar, `some token`)

+ Request JSON Message
    
    + Headers

            Accept: application/json

+ Response 200 (application/json)

    + Body
{
  "envelope": {
    "header": {
      "apiVersion": "1.0",
      "baseUrl": "vapi.alpha.devorch.com",
      "httpStatusCode": 200
    },
    "request": "analyticsdetail/index?params=datawarehouse&analyticsdetail&index&json&8020&2013-08-08&2013-09-09&release&activities&desc&10&0&<some_token>",
    "response": {
      "analyticsDetail": [
        {
          "releaseid": 123456789123,
          "catalogname": "Release 6",
          "artistname": "Artist 5",
          "catalogid": 2809339,
          "artistid": 39143,
          "activities": "1"
        }
      ]
    }
  }
}


## Index [/datawarehouse/analyticsdetail/index{?vendorId,fromDate,toDate,groupBy,sortBy,sortOrder,limit,offset,access_token}]

### Index [GET]


+ Parameters

    + vendorId (optional, number, `8020`)
    + fromDate (optional, varchar, `2013-08-01`)
    + toDate (optional, varchar, `2013-08-20`)
    + groupBy (optional, varchar, `artist`)
    + sortBy (required, varchar, `activities`)
    + sortOrder (required, varchar, `desc`)
    + limit (required, number, `10`)
    + offset (optional, number, `0`)
    + access_token (required, varchar, `some token`)

+ Request JSON Message
    
    + Headers

            Accept: application/json

+ Response 200 (application/json)

    + Body
{
  "envelope": {
    "header": {
      "apiVersion": "1.0",
      "baseUrl": "vapi.alpha.devorch.com",
      "httpStatusCode": 200
    },
    "request": "analyticsdetail/index?params=datawarehouse&analyticsdetail&index&json&8020&2013-08-01&2013-08-20&artist&activities&desc&10&0&<some_token>",
    "response": {
      "analyticsDetail": [
        {
          "artistname": "7days 5",
          "artistid": 161611,
          "activities": "1"
        }
      ]
    }
  }
}


+ **Required Parameters**

    + fromDate - From date
    + toDate - to date 
    + groupBy - string separated by comma

+ **Optional Parameters**

    + isrcIds - array of dim_isrc IDS, to show analytic data for only these isrcs.
    + catalogIds - array of dim_catalog IDS, to filter result based on these catalogs Ids.
    + artistIds 
    + releaseIds
    + trackIds
    + genreIds
    + countryIds
    + storeIds
    + imprintIds
    + socialIds
    + transactionTypeIds
    + channel - channelName
    + countFlag(on/off) - Returns total count.
    + sortBy - column to order by 
    + sortOrder - direction in which to order the data