topic Re: How to Push the external data (csv/excel files) to Dynatrace to generate the dashboard. in Open Q&A

How to Push the external data (csv/excel files) to Dynatrace to generate the dashboard.

rakku99 — Wed, 25 Jan 2023 10:58:06 GMT

I want to generate the dashboard on Dynatrace by pushing the files (csv/excel files) from external system. How can i push these files to Dynatrace. The files contain the columns like CustomerId, ClientID, Name, surname, email and want to create the dashboard with same columns name on Dynatrace.

Regards,

Rakesh

Re: How to Push the external data (csv/excel files) to Dynatrace to generate the dashboard.

Romanenkov_Al3x — Fri, 20 Jan 2023 11:15:22 GMT

Hello Rakesh.

As far as I know, at the moment there is no such possibility (like to display big file with more than 100 rows) . If I'm wrong, other users will correct me.

But maybe these examples will help you achieve a goal.

For example - list of tickets without answers

Using a custom script on a python - we take this information from internal CRM system and change the dashboard using APIs ( dashboard API ) and tile ( markdown )

This can be used, for example, as a list of users with problems - if there are several of them.

Another example:

You can create custom device and send data to custom device.

With data explorer you can display the list.

Example payload:

{'displayName': 'Coffee machine', 'listenPorts': ['1521'], 'type': 'coffee machine', 'favicon': 'https://www.freefavicon.com/freefavicons/food/cup-of-coffee-152-78475.png', 'configUrl': 'http://coffemachine.internal.settings:8080', 'tags': ['Coffee', 'Example'], 'properties': {'dns-name': 'coffemachine.internal.settings', 'ip-address': '192.168.1.249'}, 'series': [{'timeseriesId': 'custom:coffee_metric', 'dimensions': {'coffee': 'Espresso', 'cup_size': 'small', 'addings': 'milk', 'price': '120'}, 'dataPoints': [[1674210255137, 1]]}]}

Result:

https://www.dynatrace.com/support/help/shortlink/api-custom-device-report-metric#request-body-json-model

https://www.dynatrace.com/support/help/dynatrace-api/environment-api/metric-v2/post-ingest-metrics

Regards,

Romanenkov Alex

Re: How to Push the external data (csv/excel files) to Dynatrace to generate the dashboard.

rakku99 — Fri, 20 Jan 2023 16:33:42 GMT

Hi Alex,

Thank for comments!

Did you mean to say that we can push files with having the rows less than 100?

If we can push then do we have scroll facility in dashboard?

Is it possible to push the JSON files instead of csv/excel to Dynatrace to generate the dashboard.

Regards

Rakesh

Re: How to Push the external data (csv/excel files) to Dynatrace to generate the dashboard.

Tom_Eaton — Sat, 21 Jan 2023 14:42:19 GMT

Hi Rakku99,

Yeah, the Dynatrace API's use JSON, so that will work.

Tom