Retrieving Specific Records through a Drill Down Search via REST API

Overview

Description	Retrieving matching records through a drill-down search
Resource Path	/analytics/drilldown
HTTP Method	POST
Request/Response Format	application/json
Authentication	Basic

Example

POST https://localhost:9443/analytics/drillDown

{
           "tableName": "testtable",
            "categories": [
                {
                          "fieldName": "location",
                            "path" : ["Sri lanka", "Colombo"]
                },
                {
                          "fieldName": "publishedDate",
                            "path" : ["2015", "Mar", "23"]
                }
            ],
            "query" : "timestamp : [1243214324532 TO 4654365223]",
            "recordStart" : 0,
            "recordCount" : 100
}

Sample output

 [  
   {  
      "id":"14242656601230.5739142271249453",
      "tableName":"testtable",
      "timestamp":1424265660123,
      "values":{  
         "timestamp":"value1",
         "product":"wso2cdm",
     "location" : ["Srilanka", "Colombo"],
     "publishedData" : ["2015", "Mar", "23"]
      }
   }
]

REST API response

HTTP status code

200

For descriptions of the HTTP status codes, see HTTP Status Codes.