topic Support for .csv when extracting Problems via api/v2 in Dynatrace API

Support for .csv when extracting Problems via api/v2

AlanFoley — Thu, 18 Nov 2021 10:32:45 GMT

Currently Problems can only be extracted in .json format via the API

When will Problem export from API to .csv be supported

Thanks

Alan

Re: Support for .csv when extracting Problems via api/v2

monitoringteam1 — Tue, 05 Oct 2021 14:53:00 GMT

Hello,

did you try to perform the API call forcing the "Accept" header to csv?

text/csv; header=present

Re: Support for .csv when extracting Problems via api/v2

ct_27 — Tue, 05 Oct 2021 20:36:36 GMT

Any chance your company has Excel (some do not). Excel Power Query is a built in feature and very very good at converting a JSON to a table. I actually find that it's better to receive JSON instead of CSV because some fields could contain multiple values (such as impacted and affected data).

With JSON you can choose if you want to expand out those data points or leave them compressed. If it output as CSV it would have to use a different delimiter between the commas to support that.

Re: Support for .csv when extracting Problems via api/v2

AlanFoley — Wed, 06 Oct 2021 03:36:18 GMT

I did try that but header is npt supported:

I used the following: -H "accept: text/csv; header=present; charset=utf-8"

Gave this error: {"error":{"code":406,"message":"Unsupported/Missing 'Accept' header."}}

Re: Support for .csv when extracting Problems via api/v2

AlanFoley — Wed, 06 Oct 2021 03:44:59 GMT

Yes I have used Power Query to convert to a table but you need to be M Code proficient to handle the next page loops and I have not mastered that yet - if you have some sample M Code that you are willing to share that handles the looping that would be great - thanks

Re: Support for .csv when extracting Problems via api/v2

Radoslaw_Szulgo — Wed, 06 Oct 2021 07:45:14 GMT

Have you tried to use a converter JSON to CSV? Should do the trick. For instance: https://data.page/json/csv

Re: Support for .csv when extracting Problems via api/v2

AlanFoley — Wed, 06 Oct 2021 15:40:47 GMT

Appreciate the reply but my requirement is to implement this in a batch process - It would be great if Monitored Entities could be extracted via API in the same way that Metrics are extracted - that would solve a lot of limitations with nextpage issues in json output - thanks