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.
Solved! Go to 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.