I have a project where I need to pull data from an NAV server, I found only this https://www.cdata.com/drivers/dynamicsnav/python/ for reference. I also somewhere this snippet but was unable to use it.
import pandas
import matplotlib.pyplot as plt
from sqlalchemy import create_engine
engine = create_engine("dynamicsnav:///?http://myserver:7048&User=myserver\Administrator&
Password=admin&ServerInstance=DYNAMICSNAV71")
df = pandas.read_sql("SELECT Name, Prices_Including_VAT FROM Customer WHERE Name = 'Bob'", engine)
df.plot(kind="bar", x="Name", y="Prices_Including_VAT")
plt.show()
Is there a way to connect to NAV using Python? If this doesn't work I'm planning on using a bot but the data is quite big and it will take several hours if not days. Thankyou.
(This is my first question so please forgive me for any nonprofessional behaviour.)