Long sum values not human readable (Analytics API)

[chungss]

I have to query for number of transactions (sum(message_count)) for the past month via the Analytics API, but the value returned are not human readable (eg. 6.8154176E7). I am suspecting the value returned is too long (>9,999,999.0).

Is there a way to fix this?

curl -u username:password http://onpremise/v1/o/org/environments/production/stats/proxy_basepath,proxy_pathsuffix?"select=sum(message_count)&timeRange=12/31/2018+16:00~01/31/2019+15:59&filter=(proxy_basepath+eq+'/base/path'+and+proxy_pathsuffix+eq+'/pathsuffix')"

{
  "environments" : [ {
    "dimensions" : [ {
      "metrics" : [ {
        "name" : "sum(message_count)",
        "values" : [ "6.8154176E7" ]
      } ],
      "name" : "/base/path,/pathsuffix"
    } ],
    "name" : "production"
  } ],
  "metaData" : {
    "errors" : [ ],
    "notices" : [ "source pg:731c8c43-8c35-4b58-ad1a-1234567890", "Table used: org.production.fact", "query served by:55529e78-c110-4d1c-9df9-1234567890" ]
  }
}

Cheers.

[chungss · Accepted solution]

Answering myself in case someone needs it.

I did not find an answer to this. Instead, I copied the value and paste it into Excel and change the format to Number.