Overview
SAP OData is the generic SAP Gateway/Netweaver REST surface – exposes custom + standard OData services. The Automize SAP OData connector is a generic entity-CRUD + function-import + batch + metadata client for any SAP OData service.
- Regions: Wherever your SAP system runs.
- Plans: Customer's SAP licensing.
Setting up the connection
Auth type: OAuth 2.0 (Client Credentials).
- SAP admin → expose OData service + Communication Arrangement.
- OAuth Client Credentials OR Basic auth.
- In Automize → Settings → Connectors → SAP OData. Paste credentials + service base URL.
Find your credentials at https://help.sap.com/.
Rate limits
Per-SAP system capacity.
Data model
Generic OData:
Service ── Entity Sets ── Entities (typed records)
├─ Function Imports (custom server methods)
└─ $metadata (schema)Available operations
8 operations available. Click any row to jump to its detail.
| Operation | Category | What it does |
|---|---|---|
| Count entities | General | Get the count of entities in an SAP OData entity set. |
| Create entity | General | Create a new entity in an SAP OData service. |
| Delete entity | General | Delete an SAP OData entity by key. |
| Call function import | General | Execute an SAP OData function import. |
| Get entity | General | Get a single SAP OData entity by key. |
| Get metadata | General | Get the SAP OData service metadata document ($metadata). |
| Query entity set | General | Query an SAP OData entity set with $filter, $select, $expand, $top, $skip. |
| Update entity | General | Update an SAP OData entity (MERGE/PATCH). |
Operations
Count entities
Get the count of entities in an SAP OData entity set.
| Parameter | Required | Type | Description |
|---|---|---|---|
Service name service | Yes | text | |
Entity set entity_set | Yes | text |
Create entity
Create a new entity in an SAP OData service.
| Parameter | Required | Type | Description |
|---|---|---|---|
Service name service | Yes | text | |
Entity set entity_set | Yes | text | |
Fields (JSON) fields | Yes | textarea |
Tips
- entity_set + entity (object matching $metadata schema).
Delete entity
Delete an SAP OData entity by key.
| Parameter | Required | Type | Description |
|---|---|---|---|
Service name service | Yes | text | |
Entity set entity_set | Yes | text | |
Entity key key | Yes | text |
Tips
- By primary key.
Call function import
Execute an SAP OData function import.
| Parameter | Required | Type | Description |
|---|---|---|---|
Service name service | Yes | text | |
Function name function_name | Yes | text |
Get entity
Get a single SAP OData entity by key.
| Parameter | Required | Type | Description |
|---|---|---|---|
Service name service | Yes | text | |
Entity set entity_set | Yes | text | |
Entity key key | Yes | text |
Get metadata
Get the SAP OData service metadata document ($metadata).
| Parameter | Required | Type | Description |
|---|---|---|---|
Service name service | Yes | text |
Query entity set
Query an SAP OData entity set with $filter, $select, $expand, $top, $skip.
| Parameter | Required | Type | Description |
|---|---|---|---|
Service name service | Yes | text | |
Entity set entity_set | Yes | text | |
$filter $filter | No | text | |
$select $select | No | text | |
$expand $expand | No | text | |
$orderby $orderby | No | text | |
$top $top | No | number | |
$skip $skip | No | number |
Update entity
Update an SAP OData entity (MERGE/PATCH).
| Parameter | Required | Type | Description |
|---|---|---|---|
Service name service | Yes | text | |
Entity set entity_set | Yes | text | |
Entity key key | Yes | text | |
Fields (JSON) fields | Yes | textarea |
Tips
- key + entity changes. MERGE or PUT.
FAQ
- vs the slug-specific SAP connectors?
- SAP OData is generic – works for any service. SAP S/4HANA / B1 connectors are pre-shaped for those products. Use generic for custom services or unmapped surfaces.