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

[rakku99]

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

[Romanenkov_Al3x · Accepted solution]

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-m...

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

Regards,

Romanenkov Alex

[rakku99 · Accepted solution]

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

[Tom_Eaton]

Hi Rakku99,

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

Tom