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

Operation ID:

AdHocRequest

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

Operation ID:

CreateEntry

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

Operation ID:

DeleteEntry

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

Operation ID:

GetEntityData

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

Operation ID:

GetEntry

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

Operation ID:

UpdateEntry

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'.