topic Re: Getting metrics via API in Open Q&A

Getting metrics via API

Paulo1989 — Thu, 27 Apr 2023 07:17:16 GMT

Good Afternoon Everyone

I´d like to ask if someone can help me with an extraction report from Dynatrace to Excel or PowerBI

I did all the metrics via apiv2 everything seems ok when I´m uploading the file to excel I put the token and select the the level i pretend to I was receive an info message that says It´s only possible to specify an API Web key when provided by an API KEY NAME

I pretend to receive an automatic report about my apps or hosts from dynatrace to Excel or PowerBI

Thank you

Re: Getting metrics via API

AntonPineiro — Thu, 27 Apr 2023 07:03:20 GMT

Hi,

I extract information as plain text normally, a CSV format. You can open CSV in a spreadsheet application as Excel.

Just to provide some alternative.

Best regards

Re: Getting metrics via API

Paulo1989 — Thu, 27 Apr 2023 07:33:22 GMT

Thanks for the help but I tried this one before and it works perfetly but I need from an API REQUEST to export automatically to Excel or PowerBI if it possible

Re: Getting metrics via API

AntonPineiro — Thu, 27 Apr 2023 10:52:23 GMT

Hi,

You have a Dynatrace webinar about Dynatrace and PowerBi.

Best regards

Re: Getting metrics via API

Paulo1989 — Thu, 27 Apr 2023 11:41:03 GMT

Hi AntonPineiro,

thank you. I'll go through it

Re: Getting metrics via API

Paulo1989 — Sat, 29 Apr 2023 18:53:18 GMT

hi AntonPineiro

thanks for the video it worked perfect

Re: Getting metrics via API

AntonPineiro — Sat, 29 Apr 2023 19:45:20 GMT

Hi,

You are welcome and happy to read it! 😉

Best regards