Solved: How to get multiple dimensions with Analytics API ... - Page 2

Report Inappropriate Content · 06-01-2017 09:02 AM

Hi,

I have created a report with multiple dimensions, which are vin, username, pathsuffix , request timestamp and responseCode . Has only one metric Total_response_time.

I could see the report details when i drill down on each dimension. When i export to CSV file , i don't get all dimensions instead i get only first drilled down dimension. I realized to get all dimensions we can use Analytics API call.

But even with API call , i still get only one dimension at a time.

sample API call with filters is giving me only vin numbers.

https://api.enterprise.apigee.com/v1/organizations/nonprod/environments/dev/stats/vin?select=sum(mes... 00:00~05/30/2017 00:00&timeUnit=day&filter=(username in 'ABCD' and proxy_pathsuffix in '/v1/vin' and response_status_code eq 200)

Is it possible to get all dimensions by username in one call?

This should return

vin, pathsuffix, requesttimestap , responsecode

jonesfloyd

Hi @Nalini - With the API, you can include multiple dimensions separated by commas. It doesn't order the subdimensions like you have in your sample JSON, but it does group by specific dimension combos.

For example, take this API call that gets message counts grouped by proxy and verb:

https://api.enterprise.apigee.com/v1/organizations/apigeedocs/environments/test/stats/apiproxy,request_verb?select=sum(message_count)&timeRange=05%2F15%2F2017%2000%3A00~05%2F20%2F2017%2023%3A59"

The response will come out like this:

{
      "dimensions": [
        {
          "metrics": [
            {
              "name": "sum(message_count)",
              "values": [
                "34522.0"
              ]
            }
          ],
          "name": "testCache,POST"
        },
        {
          "metrics": [
            {
              "name": "sum(message_count)",
              "values": [
                "17259.0"
              ]
            }
          ],
          "name": "helloworld-sampleproxy,GET"
        }

This example shows traffic for 1) testCache proxy and POST, 2) helloworld-sampleproxy and GET.

So your metric counts would be grouped VERY granularly, like this:

{
      "dimensions": [
        {
          "metrics": [
            {
              "name": "sum(message_count)",
              "values": [
                "34522.0"
              ]
            }
          ],
          "name": "/v1/specs,vin1,user1,200,date"
        },
        {
          "metrics": [
            {
              "name": "sum(message_count)",
              "values": [
                "17259.0"
              ]
            }
          ],
          "name": "/v1/specs,vin1,user2,200,date"
        }

...and so on.

Not sure if this is helpful, but it's how multiple dimensions in a single API call are grouped.

View solution in original post

How to get multiple dimensions with Analytics API call?