SAP OData (Preview)
An OData connector that can be used to invoke SAP ODATA services for performing various operations like create, read, update and delete of entities, as well as invoking functions on the service.
This connector is available in the following products and regions:
Service | Class | Regions |
---|---|---|
Logic Apps | Standard | All Logic Apps regions except the following: - Azure China regions - US Department of Defense (DoD) |
Power Automate | Premium | All Power Automate regions |
Power Apps | Premium | All Power Apps regions |
Contact | |
---|---|
Name | Microsoft |
URL | Microsoft LogicApps Support Microsoft Power Automate Support Microsoft Power Apps Support |
Connector Metadata | |
---|---|
Publisher | Microsoft |
Website | https://www.odata.org/ |
Privacy policy | https://privacy.microsoft.com/privacystatement |
Creating a connection
The connector supports the following authentication types:
Anonymous | Use anonymous access for OData Service. | All regions | Not shareable |
Basic | Use username and password to access OData Service. | All regions | Not shareable |
Microsoft Entra ID Integrated (with APIM) | Use Microsoft Entra ID to access your SAP instance. | All regions | Not shareable |
Default [DEPRECATED] | This option is only for older connections without an explicit authentication type, and is only provided for backward compatibility. | All regions | Not shareable |
Anonymous
Auth ID: Anonymous
Applicable: All regions
Use anonymous access for OData Service.
This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.
Name | Type | Description | Required |
---|---|---|---|
OData Base URI | string | True | |
Gateway | gatewaySetting | On-prem gateway (see https://docs.microsoft.com/data-integration/gateway for more details | |
API Key Name | string | ||
API Key Value | securestring |
Basic
Auth ID: Basic
Applicable: All regions
Use username and password to access OData Service.
This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.
Name | Type | Description | Required |
---|---|---|---|
OData Base URI | string | True | |
Username | securestring | True | |
Password | securestring | True | |
Gateway | gatewaySetting | On-prem gateway (see https://docs.microsoft.com/data-integration/gateway for more details | |
API Key Name | string | ||
API Key Value | securestring |
Microsoft Entra ID Integrated (with APIM)
Auth ID: oauth
Applicable: All regions
Use Microsoft Entra ID to access your SAP instance.
This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.
Name | Type | Description | Required |
---|---|---|---|
Microsoft Entra ID Resource URI (Application ID URI) | string | The identifier used in Microsoft Entra ID to identify the target resource. | True |
OData Base URI | string | True | |
Gateway | gatewaySetting | On-prem gateway (see https://docs.microsoft.com/data-integration/gateway for more details | |
API Key Name | string | ||
API Key Value | securestring |
Default [DEPRECATED]
Applicable: All regions
This option is only for older connections without an explicit authentication type, and is only provided for backward compatibility.
This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.
Name | Type | Description | Required |
---|---|---|---|
OData Base URI | string | True | |
Authentication Type | string | Authentication type to connect to the OData Service. | True |
Username | securestring | The username to be used to connect to the OData Service. | True |
Password | securestring | The password to be used to connect to the OData Service. | True |
Gateway | gatewaySetting | On-prem gateway (see https://docs.microsoft.com/data-integration/gateway for more details |
Throttling Limits
Name | Calls | Renewal Period |
---|---|---|
API calls per connection | 2500 | 60 seconds |
Actions
Create any type of OData request (Preview) |
Create any type of OData request. |
Create OData entity (Preview) |
Create OData entity. |
Delete OData entity (Preview) |
Delete OData entity. |
Query OData entities (Preview) |
Query OData entities Data. |
Read OData entity (Preview) |
Read OData entity. |
Update OData entity (Preview) |
Update OData entity. |
Create any type of OData request (Preview)
Create any type of OData request.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
httpMethod
|
httpMethod | True | string | |
relativePath
|
relativePath | True | string | |
queryString
|
queryString | object | ||
payload
|
payload | object |
Returns
Name | Path | Type | Description |
---|---|---|---|
statusCode
|
statusCode | integer | |
structured
|
response.structured | object | |
unstructured
|
response.unstructured | string |
Create OData entity (Preview)
Create OData entity.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
OData Entity name
|
entity | True | string |
Please specify OData Entity name. |
OData Entity input
|
entryInput | True | dynamic |
Please specify OData Entity input. |
Returns
Delete OData entity (Preview)
Delete OData entity.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
OData Entity name
|
entity | True | string |
Please specify OData Entity name. |
OData Entity input
|
entryInput | True | dynamic |
Please specify OData Entity input. |
Returns
- response
- object
Query OData entities (Preview)
Query OData entities Data.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
OData Entity name
|
entity | True | string |
Please specify OData Entity name. |
$top
|
top | number |
Optional $top query option. |
|
$skip
|
skip | number |
Optional $skip query option. |
|
$select
|
select | string |
Optional $select query option. |
|
$filter
|
filter | string |
Optional $filter query option. |
|
$expand
|
expand | string |
Optional $expand query option. |
|
$orderby
|
orderby | string |
Optional $orderby query option. |
|
$search
|
search | string |
Optional $search query option. |
Returns
Read OData entity (Preview)
Read OData entity.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
OData Entity name
|
entity | True | string |
Please specify OData Entity name. |
OData Entity input
|
entryInput | True | dynamic |
Please specify OData Entity input. |
$top
|
top | number |
Optional $top query option. |
|
$skip
|
skip | number |
Optional $skip query option. |
|
$select
|
select | string |
Optional $select query option. |
|
$filter
|
filter | string |
Optional $filter query option. |
|
$expand
|
expand | string |
Optional $expand query option. |
|
$orderby
|
orderby | string |
Optional $orderby query option. |
|
$search
|
search | string |
Optional $search query option. |
Returns
Update OData entity (Preview)
Update OData entity.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
OData Entity name
|
entity | True | string |
Please specify OData Entity name. |
OData Entity input
|
entryInput | True | dynamic |
Please specify OData Entity input. |
Returns
Definitions
object
This is the type 'object'.