20 Jan 2023
02:10 AM
- last edited on
25 Jan 2023
02:58 AM
by
MaciejNeumann
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
Solved! Go to 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/dynatrace-api/environment-api/metric-v2/post-ingest-metrics
Regards,
Romanenkov Alex
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
Hi Rakku99,
Yeah, the Dynatrace API's use JSON, so that will work.
Tom