cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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

rakku99
Visitor

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

3 REPLIES 3

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.

 

Romanenkov_Al3x_2-1674213124757.png

 

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:

Romanenkov_Al3x_0-1674212191532.png

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

 

DT_NGINX_ALL_WHITELISTED=1

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
Dynatrace Contributor
Dynatrace Contributor

Hi Rakku99,

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

Tom