Get data straight into a CSV or Excel file utilizing rest API

[Rohitk]

Can we get data straight into a csv or excel file utilizing a rest API?

[JamesKitson · Accepted solution]

It depends on the endpoint.

The metrics API can return CSV data if you specify the proper Accept request header. But the monitored entities API can only return JSON data.

Mostly it's metrics that you can get in CSV, but you can check the doc page for the specific API endpoint to know for sure and see how it request it. Otherwise that processing would need to be done client-side.

[tibebe_m_digafe]

Hi,

I do not think you can do that directly. I assume you already have looked at using external tools to covert form json to csv.

Thanks. Tibebe