Common Data Service

Common Data Service

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

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

The outputs of this operation are dynamic.

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

Table

DisplayName
string
Name
string

Key

KeyValue
string

TablesList

value
array of Table