README.md

python-odata for Business Central

REMARK This fork does not promise anything beyond that it will work with the Business Central API

It does enforce all other Growy coding standards (configured in pre-commit) - so, code might look a bit different.

python-odata

A simple library for read/write access to OData services.

• Supports OData version 4.0
• Requires JSON format support from the service
• Should work on both Python 2.x and 3.x

Documentation

Available on readthedocs.org

Dependencies

• requests >= 2.0
• python-dateutil
• rich >= 13.3.1

Demo

Reading data from the Northwind service.

from odata import ODataService
url = 'http://services.odata.org/V4/Northwind/Northwind.svc/'
Service = ODataService(url, reflect_entities=True)
Supplier = Service.entities['Supplier']

query = Service.query(Supplier)
query = query.limit(2)
query = query.order_by(Supplier.CompanyName.asc())

for supplier in query:
    print('Company:', supplier.CompanyName)

    for product in supplier.Products:
        print('- Product:', product.ProductName)

Writing changes. Note that the real Northwind service is read-only and the data modifications do not work against it.

import datetime

Order = Service.entities['Order']
Employee = Service.entities['Employee']

empl = Service.query(Employee).first()

query = Service.query(Order)
query = query.filter(Order.ShipCity == 'Berlin')

for order in query:
    order.ShippedDate = datetime.datetime.utcnow()
    order.Employee = empl
    Service.save(order)