# OData Integrations in Python

Query and update SAP and Microsoft business data over one uniform OData protocol.

## Get started

Filter, page, sort, read and write business entities with $filter, $select, $expand, $orderby and the other query options, in both OData V2 and V4.

[OData query options](https://zato.io/docs/dev/odata/query/index.html)

service.py

```
# Query any OData service
conn = self.odata['OData.Sample']
customers = conn.read('Customers',
    filter="City eq 'London'", top=20)

customers[0]['DisplayName']
'Northwind Traders'

conn.count('Orders')
42
```

## Work with OData services

[Query options $filter, $select, $expand, $orderby, $top, $skip, $count, $search and $apply in V2 and V4.](https://zato.io/docs/dev/odata/query/index.html) [OData security Basic Auth, Bearer tokens, OAuth2 client credentials with Entra ID and SAP CSRF tokens.](https://zato.io/docs/dev/odata/security/index.html) [System notes SAP S/4HANA, SuccessFactors, Dynamics 365 Finance and Operations and Business Central specifics.](https://zato.io/docs/dev/odata/systems/index.html)