OData (Preview)

The OData connector can be used to invoke an ODATA service 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)

Contact
Name	Microsoft
URL	Microsoft LogicApps 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	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 shareable connection. If the power app is shared with another user, connection is shared as well. For more information, please see the Connectors overview for canvas apps - Power Apps | Microsoft Docs

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
Username	securestring		True
Password	securestring		True

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

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.
Get OData Entity Set schema (Preview)	Get OData Entity Set schema.
Get OData Entity Set schema for Single Entry (Preview)	Get OData Entity Set schema for Single Entry.
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)

Operation ID:

CreateEntry

Create OData entity.

Parameters

Name	Key	Required	Type	Description
OData Service Uri	odataUri	True	string	Please specify OData Service Uri.
OData Entity name	entity	True	string	Please specify OData Entity name.
OData Entity input	entryInput		dynamic	Please specify OData Entity input.

Returns

The outputs of this operation are dynamic.

Delete OData entity (Preview)

Operation ID:

DeleteEntry

Delete OData entity.

Parameters

Name	Key	Required	Type	Description
OData Service Uri	odataUri	True	string	Please specify OData Service Uri.
OData Entity name	entity	True	string	Please specify OData Entity name.
OData Entity input	entryInput		dynamic	Please specify OData Entity input.

Returns

response

object

Get OData Entity Set schema (Preview)

Operation ID:

GetSchema

Get OData Entity Set schema.

Parameters

Name	Key	Required	Type	Description
OData Service Uri	odataUri	True	string	Please specify OData Service Uri.
OData Entity name	entity	True	string	Please specify OData Entity name.

Returns

response

object

Get OData Entity Set schema for Single Entry (Preview)

Operation ID:

GetSingleSchema

Get OData Entity Set schema for Single Entry.

Parameters

Name	Key	Required	Type	Description
OData Service Uri	odataUri	True	string	Please specify OData Service Uri.
OData Entity name	entity	True	string	Please specify OData Entity name.
Schema Option	option		integer	Schema option value depending on operation. (1,2,3)

Returns

response

object

Query OData entities (Preview)

Operation ID:

GetEntityData

Query OData entities Data.

Parameters

Name	Key	Required	Type	Description
OData Service Uri	odataUri	True	string	Please specify OData Service Uri.
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

The outputs of this operation are dynamic.

Read OData entity (Preview)

Operation ID:

GetEntry

Read OData entity.

Parameters

Name	Key	Required	Type	Description
OData Service Uri	odataUri	True	string	Please specify OData Service Uri.
OData Entity name	entity	True	string	Please specify OData Entity name.
OData Entity input	entryInput		dynamic	Please specify OData Entity input.

Returns

The outputs of this operation are dynamic.

Update OData entity (Preview)

Operation ID:

UpdateEntry

Update OData entity.

Parameters

Name	Key	Required	Type	Description
OData Service Uri	odataUri	True	string	Please specify OData Service Uri.
OData Entity name	entity	True	string	Please specify OData Entity name.
OData Entity input	entryInput		dynamic	Please specify OData Entity input.

Returns

The outputs of this operation are dynamic.

Definitions

object

This is the type 'object'.