# Group Datawarehouse
Group of all datawarehouse-related resources.

## Countries 

The Countries resource is used to return detailed information about all the available countries.

## Index with sort params [/datawarehouse/countries/index{?limit,sortBy,sortOrder}]

### Index [GET]

+ Parameters

    + limit (optional, number, `5`)
    + sortBy (optional, varchar, `id`)
    + sortOrder (optional, varchar, `asc`)

+ 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": "countries/index?params=datawarehouse&countries&index&json&<some_token>&5&id&asc",
    "response": {
      "countries": [
        {
          "id": "1",
          "name": "USA"
        },
        {
          "id": "2",
          "name": "Canada"
        },
        {
          "id": "3",
          "name": "United Kingdom"
        },
        {
          "id": "4",
          "name": "Germany"
        },
        {
          "id": "5",
          "name": "Sweden"
        }
      ],
      "totalRecords": "244"
    }
  }
}



## Index with search params [/datawarehouse/countries/index{?searchBy,searchValue}]

### Index [GET]

+ Parameters

    + searchBy (optional, varchar, `name`)
    + searchValue (optional, varchar, `ind`)

+ 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": "countries/index?params=datawarehouse&countries&index&json&<some_token>&name&ind",
    "response": {
      "countries": [
        {
          "id": "217",
          "name": "British Indian Ocean Territory"
        },
        {
          "id": "86",
          "name": "India"
        },
        {
          "id": "87",
          "name": "Indonesia"
        }
      ],
      "totalRecords": "3"
    }
  }
}




+ **Optional Parameters**

    + searchBy
    + searchValue
    + limit
    + offset
    + sortBy - column to order by 
    + sortOrder - direction in which to order the data