SAP OData
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 |
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 |
Microsoft Entra ID using SuccessFactors (Preview) | Use Microsoft Entra ID for authentication to SuccessFactors. | 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 |
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 |
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 |
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 |
Auth ID: oauthsuccessfactors
Applicable: All regions
Use Microsoft Entra ID for authentication to SuccessFactors.
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 |
---|---|---|---|
Success Factors token URL | string | Your SuccessFactors OAuth token endpoint URL (format: https:///oauth/token). | True |
Service Provider Client Id | string | Your SuccessFactors OAuth2 Client ID. | True |
Company Id | string | CompanyId | True |
Microsoft Entra Resource URL (Application ID URI) | string | The identifier used in Microsoft Entra ID to identify the target resource. | True |
OData Base URI | string | True |
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 |
Name | Calls | Renewal Period |
---|---|---|
API calls per connection | 2500 | 60 seconds |
Create any type of OData request |
Create any type of OData request. |
Create OData entity |
Create OData entity. |
Delete OData entity |
Delete OData entity. |
Query OData entities |
Query OData entities Data. |
Read OData entity |
Read OData entity. |
Update OData entity |
Update OData entity. |
Create any type of OData request.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
relativePath
|
relativePath | True | string |
Combined with OData URI from the connection to create the full URI to interact with. |
httpMethod
|
httpMethod | 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.
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. |
relativePath
|
relativePath | string |
Combined with OData URI from the connection to create the full URI to interact with. |
Returns
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. |
relativePath
|
relativePath | string |
Combined with OData URI from the connection to create the full URI to interact with. |
Returns
- response
- object
Query OData entities Data.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
OData Entity name
|
entity | True | string |
Please specify OData Entity name. |
relativePath
|
relativePath | string |
Combined with OData URI from the connection to create the full URI to interact with. |
|
$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. |
|
$inlinecount
|
inlinecount | string |
Optional $inlinecount query option. |
Returns
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. |
relativePath
|
relativePath | string |
Combined with OData URI from the connection to create the full URI to interact with. |
|
$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. |
|
$inlinecount
|
inlinecount | string |
Optional $inlinecount query option. |
Returns
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. |
relativePath
|
relativePath | string |
Combined with OData URI from the connection to create the full URI to interact with. |
Returns
This is the type 'object'.