Microsoft Dataverse Connection

Base URL address: https://[instance]/api/data/v9.0.

The authentication uses an authorized token. The token will be refreshed with the following expression: {{=Date.now() + (response.expires_in - 300) * 1000}}.

The authentication has the following user-defined parameters:

• client_id: Required. Identifier of application that is associated with the authentication token.
• client_secret: Specify application client secret. Optional.
• tenant: Required. Specify tenant identifier.

The following request parameters will be automatically processed during the authentication process:

• Authorization: Bearer {{=token.Access}}

Documentation: https://docs.microsoft.com/en-us/powerapps/developer/data-platform/authenticate-oauth.

---

The external resource list is extracted from: {{=Dataverse.getResources()}}.

{{=Dataverse.getResourceName(resource.external.name)}}

[Read] action

Endpoint URL address: /{{=resource.external.entitySetName}}.
The result is extracted from: {{=response.value}}.
The result is paginated.

The action has the following user-defined parameters:

• $expand: Specify for expandable property. Optional.

The following request parameters will be automatically processed:

• $select: {{=function() { /* var fields = resource.getFields(); return _.filter(parameters.fields, function(field) { return fields[field].external.canSelect; }).join();*/ return undefined; }()}}
• $skiptoken: {{=parameters.iterator}}
• Prefer: odata.include-annotations="OData.Community.Display.V1.FormattedValue, Microsoft.Dynamics.CRM.lookuplogicalname", odata.maxpagesize={{=parameters.batchSize}}
• _includeUserParameters: {{=parameters}}

Documentation: https://docs.microsoft.com/en-us/powerapps/developer/data-platform/webapi/query-data-web-api.

---

[Read FetchXml] action

Endpoint URL address: /{{=resource.external.entitySetName}}.
The result is extracted from: {{=response.value}}.
The result is paginated.

The action has the following user-defined parameters:

• FetchXml: Required. Specify FetchXML statement.

The following request parameters will be automatically processed:

• fetchXml: {{=Dataverse.prepareFetchXml(parameters)}}
• Prefer: odata.include-annotations="OData.Community.Display.V1.FormattedValue, Microsoft.Dynamics.CRM.lookuplogicalname, Microsoft.Dynamics.CRM.fetchxmlpagingcookie"

Documentation: https://docs.microsoft.com/en-us/powerapps/developer/data-platform/webapi/retrieve-and-execute-predefined-queries#use-custom-fetchxml.

---

[Create] action

Endpoint URL address: .
The result is extracted from: {{=Dataverse.executeAction('create', resource, batch)}}.

The action has the following user-defined parameters:

• IgnoreNullValue: Specify to ignore NULL values and not send for processing.
• IgnoreMissingIdentifier: Specify how unrecognized lookup identifiers are to be handled. When this parameter is set to True, the component will ignore an identifier field if it does not match any entity record in the system.
• $expand: Specify for expandable property. Optional.

Documentation: https://docs.microsoft.com/en-us/powerapps/developer/data-platform/webapi/create-entity-web-api.

---

[Update] action

Endpoint URL address: .
The result is extracted from: {{=Dataverse.executeAction('update', resource, batch, parameters)}}.

The action has the following user-defined parameters:

• IgnoreNullValue: Specify to ignore NULL values and not send for processing.
• IgnoreUnchanged: Specify to avoid sending fields where input data matches existing data.
• IgnoreMissingIdentifier: Specify how unrecognized lookup identifiers are to be handled. When this parameter is set to True, the component will ignore an identifier field if it does not match any entity record in the system.
• AlternateKey: Specify alternative key identifier column. Optional.
• $expand: Specify for expandable property. Optional.

Documentation: https://docs.microsoft.com/en-us/powerapps/developer/data-platform/webapi/update-delete-entities-using-web-api.

---

[Upsert] action

Endpoint URL address: .
The result is extracted from: {{=Dataverse.executeAction('upsert', resource, batch, parameters)}}.

The action has the following user-defined parameters:

• IgnoreNullValue: Specify to ignore NULL values and not send for processing.
• IgnoreUnchanged: Specify to avoid sending fields where input data matches existing data.
• IgnoreMissingIdentifier: Specify how unrecognized lookup identifiers are to be handled. When this parameter is set to True, the component will ignore an identifier field if it does not match any entity record in the system.
• AlternateKey: Specify alternative key identifier column. Optional.
• DuplicateDetectionRules: Specify to update existing records using the system-defined duplicate detection rules.
• MultipleMatch: Specify how to handle multiple matches.
• $expand: Specify for expandable property. Optional.

Documentation: https://docs.microsoft.com/en-us/powerapps/developer/data-platform/webapi/update-delete-entities-using-web-api.

---

[Delete] action

Endpoint URL address: .
The result is extracted from: {{=Dataverse.executeAction('delete', resource, batch)}}.

Documentation: https://docs.microsoft.com/en-us/powerapps/developer/data-platform/webapi/update-delete-entities-using-web-api.

---

Fields

@odata.etag

Template: ShortText.

External Fields

[External]

The external fields list is extracted from: {{=Dataverse.getFields(resource, parameters)}}.

ShortText

Data type: DT_WSTR ( length 255 )

---

LongText

Data type: DT_WSTR ( length 1000 )

---

Lookup

The gathered value is processed with {{=Dataverse.getLookupValue(field, item)}} expression. Before setting, the value is processed with {{=Dataverse.getLookupItemValue(field, value, parameters)}} expression. Field components:

• Uses template: ShortText.
• Contains the following components: value, entity, formatted.

---

Double

Data type: DT_R8

---

Boolean

Data type: DT_BOOL

---

BigInt

Data type: DT_I8

---

Integer

Data type: DT_I4

---

Money

Data type: DT_CY

---

DateTime

Data type: DT_DBTIMESTAMP

---

Uniqueidentifier

Data type: DT_GUID

---

Decimal

Data type: DT_DECIMAL

---

Date

Data type: DT_DBDATE Before setting, the value is processed with {{=value && dateFormat(value, 'yyyy-mm-dd')}} expression.

---

Picklist

Template: ShortText. Before setting, the value is processed with {{=Dataverse.getPicklistCode(field, value)}} expression.

---