Common Data Service (Legacy)

Common Data Service (Legacy)

Provides access to the org-based database on the Microsoft Common Data Service

Note:

  • This is a Premium connector.
  • Connector unavailable in Flow and PowerApps.

Connections per account: 1

Creating a connection

To connect your account, you will need the following information:

Environment id
string
Environment id

Actions

Create a new file

Create a new blob file for an entity

Required Parameters

Namespace of the entity database
string
Folder Path
string
File name
string
File Content
binary
Content of the file

Returns

Create a new record

Creates a new record in the entity

Required Parameters

The database
string
The database for the entities
The entity
string
The entity
Record
dynamic
Record to create

Returns

The outputs of this operation are dynamic.

Delete a record

Deletes a record in the entity

Required Parameters

The database
string
The database for the entities
The entity
string
The entity
Key value
string
Unique identifier of the record to delete

Returns

Generate key value

Generates a key value

Required Parameters

The database
string
The database for the entities
The entity
string
The entity
Record
dynamic
Record with changed properties

Returns

Body
Key

Get entity file content by path

Retrieves a blob file's content for an entity from the specified path

Required Parameters

Namespace of the entity database
string
File path
string

Returns

File content
binary

Get list of entities

Retrieves a list of entities in a database

Required Parameters

The database
string
The database for the tables

Returns

Body
TablesList

Get list of records

Retrieves a list of records of a particular entity

Required Parameters

The database
string
The database for the entities
The entity
string
The entity

Optional Parameters

Filter Query
string
An ODATA filter query to restrict the number of records
Order By
string
An ODATA orderBy query for specifying the order of records
Skip Count
integer
Number of records to skip (default = 0)
Maximum Get Count
integer
Maximum number of records to retrieve (default = 256)

Returns

The outputs of this operation are dynamic.

Get record

Retrieves a single record

Required Parameters

The database
string
The database for the entities
The entity
string
The entity
Key value
string
Unique identifier of the record to retrieve

Returns

The outputs of this operation are dynamic.

Update a record

Updates a record

Required Parameters

The database
string
The database for the entities
The entity
string
The entity
Key value
string
Unique identifier of the record to update
Record
dynamic
Record with changed properties

Returns

The outputs of this operation are dynamic.

Triggers

When a record is created

Triggers a flow when a new record is created

Required Parameters

The database
string
The database for the entity
The entity
string
The entity

Optional Parameters

Skip Count
integer
Number of records to skip (default = 0)
Maximum Get Count
integer
Maximum number of records to retrieve (default = 256)
Filter Query
string
An ODATA filter query to restrict the number of records
Order By
string
An ODATA orderBy query for specifying the order of records

Returns

The outputs of this operation are dynamic.

When a record is updated

Triggers a flow when an existing record is updated

Required Parameters

The database
string
The database for the entitites
The entity
string
The entity

Optional Parameters

Skip Count
integer
Number of records to skip (default = 0)
Maximum Get Count
integer
Maximum number of records to retrieve (default = 256)
Filter Query
string
An ODATA filter query to restrict the number of records
Order By
string
An ODATA orderBy query for specifying the order of records

Returns

The outputs of this operation are dynamic.

Definitions

BlobMetadata

DisplayName
string
ETag
string
FileLocator
string
Id
string
IsFolder
boolean
LastModified
date-time
MediaType
string
Name
string
Path
string
Size
integer

Table

DisplayName
string
Name
string

Key

KeyValue
string

TablesList

value
array of Table