Attached the step by step description to access the data base with python. The data base can be accessed via an REST api from every where. The machine where this code runs can be anywhere. The minimal Sample time is around is 1 minute. It can be decreased for specific values if needed.
Since you decided to use python as your programming language I expect you are already having an IDE on your machine. If not I would recommend you to install pycharm or Anaconda. If you have little experience with python I strongly recommend you the tutorials of this guy.
Copy python file
You can directly download it here. As soon as you downloaded the zip file you can unzip it.
Open IDE and install needed libraries
Open the pycharm on your machine and open the folder “restclient”. Open the python script “main.py” and enter your credentials. The credentials (username and password) are the same as the one for the visualizer.
import restclient import pandas as pd rest = restclient.client(username='username', password='password') # Example username='kner', password='babybell' df_read = rest.read(df_data=pd.DataFrame(columns=['401190042', '401190043','401190044', '401190045','401190046']), startDate='2019-4-02 11:01:00', endDate='2019-4-04 12:30:00') print(df_read)
Issues & tipps
- If you want to see what actually happens, you can change the logging level from “logging.WARNING” to “logging.INFO”