topic API v2 results returned in JSON format. Are there options for CSV? in Open Q&A

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

runatyr — Mon, 19 Aug 2024 12:27:09 GMT

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 — Mon, 19 Aug 2024 13:16:36 GMT

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 — Mon, 19 Aug 2024 13:42:31 GMT

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