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 Government regions - Azure China regions - US Department of Defense (DoD) |
| Power Automate | Premium | All Power Automate regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Power Apps | Premium | All Power Apps regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| 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 |
| 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 |
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 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 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. |
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. |
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'.