Fin & Ops Apps (Dynamics 365)
Fin & Ops Apps (Dynamics 365) connector provides access to data entities.
This connector is available in the following products and regions:
Service | Class | Regions |
---|---|---|
Logic Apps | Standard | All Logic Apps regions except the following: - US Department of Defense (DoD) |
Power Automate | Premium | All Power Automate regions except the following: - US Government (GCC High) - US Department of Defense (DoD) |
Power Apps | Premium | All Power Apps regions except the following: - US Government (GCC High) - US Department of Defense (DoD) |
Contact | |
---|---|
Name | Microsoft |
URL | Microsoft LogicApps Support Microsoft Power Automate Support Microsoft Power Apps Support |
Connector Metadata | |
---|---|
Publisher | Microsoft |
Website | https://dynamics.microsoft.com/finance-and-operations-to-finance-and-scm/ |
For more information about the connector, see the in-depth section.
The connector supports the following authentication types:
Default | Parameters for creating connection. | All regions | Not shareable |
Applicable: All regions
Parameters for creating connection.
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 | Calls | Renewal Period |
---|---|---|
API calls per connection | 200 | 60 seconds |
Create record |
Create a new record in an entity |
Delete record |
Deletes a single record in an entity |
Execute action |
Execute action |
Get a record |
Retrieves a single record |
Get list of entities |
Retrieves a list of entities |
Lists items present in table |
Lists items present in table |
Update a record |
Updates a single record in an entity |
Create a new record in an entity
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Instance
|
dataset | True | string |
The Dynamics 365 for Fin & Ops instance |
Entity name
|
table | True | string |
Entity name |
Object
|
item | True | dynamic |
Object to create |
Returns
Deletes a single record in an entity
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Instance
|
dataset | True | string |
The Dynamics 365 for Fin & Ops instance |
Entity name
|
table | True | string |
Entity name |
Object id
|
id | True | string |
Unique identifier of the object to delete |
Execute action
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Instance
|
dataset | True | string |
The Dynamics 365 for Fin & Ops instance |
Action
|
procedure | True | string |
Name of action |
Parameters
|
parameters | True | dynamic |
Input parameters to the action |
Returns
Retrieves a single record
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Instance
|
dataset | True | string |
The Dynamics 365 for Fin & Ops instance |
Entity name
|
table | True | string |
Entity name |
Object id
|
id | True | string |
Unique identifier of the object to retrieve |
Returns
Retrieves a list of entities
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Instance
|
dataset | True | string |
The Dynamics 365 for Fin & Ops instance |
Returns
Represents a list of tables.
- Body
- TablesList
Lists items present in table
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Instance
|
dataset | True | string |
The Dynamics 365 for Fin & Ops instance |
Entity name
|
table | True | string |
Entity name |
Aggregation transformation
|
$apply | string |
A sequence of OData aggregation transformations |
|
Filter Query
|
$filter | string |
An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123). |
|
Order By
|
$orderby | string |
An ODATA orderBy query for specifying the order of entries. |
|
Top Count
|
$top | integer |
Total number of entries to retrieve (default = all). |
|
Skip Count
|
$skip | integer |
The number of entries to skip (default = 0). |
|
Select Query
|
$select | string |
Specific fields to retrieve from entries (default = all). |
|
Cross Company
|
cross-company | boolean |
Query across companies (default = no). |
Returns
Updates a single record in an entity
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Instance
|
dataset | True | string |
The Dynamics 365 for Fin & Ops instance |
Entity name
|
table | True | string |
Entity name |
Object id
|
id | True | string |
Unique identifier of the object to update |
Object
|
item | True | dynamic |
Object with changed properties |
Returns
When a Business Event occurs |
Triggers a flow when a Business Event occurs in Dynamics 365. |
Triggers a flow when a Business Event occurs in Dynamics 365.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Instance
|
dataset | True | string |
Select an Environment. |
Category
|
businesseventcategory | True | string |
Business event category. |
Business event
|
businessevent | True | string |
Name of the business event. |
Legal entity
|
legalEntity | string |
Name of the legal entity. |
Returns
- response
- object
Represents a table.
Name | Path | Type | Description |
---|---|---|---|
Name
|
Name | string |
The name of the table. The name is used at runtime. |
DisplayName
|
DisplayName | string |
The display name of the table. |
DynamicProperties
|
DynamicProperties | object |
Additional table properties provided by the connector to the clients. |
Represents a list of tables.
Name | Path | Type | Description |
---|---|---|---|
value
|
value | array of Table |
List of Tables |
This is the type 'object'.