API v2 results returned in JSON format. Are there options for CSV?

[runatyr]

Hello:

Is it possible to get API results in the API v2 returned as CSV results?

At the end of the day. I am trying to find a way to take the data returned in a file and import it into 

a MSSQL database. 

I could go down the path of figuring out how to import JSON into MSSQL, but if CSV/txt files are an option then 

this may expedite the learning time.

Thanks!

-runatyr 

[AntonPineiro]

Hi,

It depends, for example, you can get CSV value if your metric is in Data Explorer.

I think this depends of API as well. Some of them are only available in JSON format.

Best regards

[paulo_calaxa · Accepted solution]

Hi @runatyr 
You might check each endpoint definition... For instance, it's a yes for the Metrics data

So, if in your call you change/add the Accept header parameter to "text/csv..."

you'll get the requested data in a csv format.

Kind regards,
Paulo