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

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

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

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

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

The outputs of this operation are dynamic.

Delete OData entity

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

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

The outputs of this operation are dynamic.

Read OData entity

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

The outputs of this operation are dynamic.

Update OData entity

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

The outputs of this operation are dynamic.

Definitions

object

This is the type 'object'.