I cant seem to get the api/v6/timeseries data with curl. Can anyone post a snippet to get me going

ranks — Thu, 17 Jul 2014 14:56:07 GMT

I have been able to get other data from the api, but everytime I try and use timeseries, I just get Http 400 bad request

Re: I cant seem to get the api/v6/timeseries data with curl. Can anyone post a snippet to get me go

smark — Thu, 17 Jul 2014 15:23:41 GMT

Hi ranks,

In Cloudera Manager 5 and higher, every chart you see in the web UI will provide you a direct /timeseries URL showing exactly how that chart itself retrieved metrics with the /timeseries endpoint! You can grab this same URL and use it with curl.

Find any chart and click on the blue arrow that will appear at the top-right. Choose "Export JSON". This will open a new window with the location bar already populated. This URL is a fully-formatted /timeseries API endpoint! Feel free to use any of them as a springboard for your curl testing. I tried to post one here but the forum doesn't like the URL and won't let me post. However it'd look like this:

I can use this now directly with my curl command ($curl -v -u $USER:$PASS '$URL') and I get json output as requested.

$ curl -v -u $USER:$PASS 'http://my.cluster.com:7180/api/v6/timeseries?query=select+cpu_percent_across_hosts+where+category+%3D+CLUSTER+and+clusterId+%3D+%221%22&contentType=application%2Fjson&from=2014-07-17T14%3A31%3A57.948Z&to=2014-07-17T15%3A01%3A57.948Z'

Hope this helps! Add -v and/or -i to your curl testing to get more information about the 400 error you're getting, as needed.

--
Mark S.

Re: I cant seem to get the api/v6/timeseries data with curl. Can anyone post a snippet to get me go

ranks — Thu, 17 Jul 2014 17:12:09 GMT

Thanks, I was missing replacing spaces with + signs in the select statement

question Re: I cant seem to get the api/v6/timeseries data with curl. Can anyone post a snippet to get me go in Archives of Support Questions (Read Only)

I cant seem to get the api/v6/timeseries data with curl. Can anyone post a snippet to get me going

Re: I cant seem to get the api/v6/timeseries data with curl. Can anyone post a snippet to get me go

Re: I cant seem to get the api/v6/timeseries data with curl. Can anyone post a snippet to get me go