Microsoft Dynamics 365 Finance & Operations
App · 7 actions
Query and manage public Finance and Operations data entities using your environment’s OData catalog.
Actions
| Action | What it does |
|---|---|
| Create record | Create a record in a Finance and Operations data entity from the field values you give. |
| Delete record | Delete one record from a Finance and Operations data entity, by its primary key values. |
| Get record | Get one record of a Finance and Operations data entity by its primary key values. |
| List entities | List the data entities available in the Finance and Operations environment, such as customers or vendors. |
| List entity fields | Read field names, types and primary keys from the environment’s OData metadata. |
| List records | List records of one Finance and Operations data entity, with an optional filter, sort order, chosen fields and records from all legal entities. |
| Update record | Change the named fields of one Finance and Operations record, found by its entity and primary key values. |
Create record
Create a record in a Finance and Operations data entity from the field values you give. Returns the new record.
Inputs
- Entity
entitytextRequired - Entity.
- Record
recordobjectRequired - Record.
Outputs
dataobject- Microsoft Dynamics 365 Finance & Operations response data.
Example output
{
"data": {}
}Delete record
Delete one record from a Finance and Operations data entity, by its primary key values.
Inputs
- Entity
entitytextRequired - Entity.
- Key
keyobjectRequired - Primary key fields and values from your entity metadata, for example {"dataAreaId":"USMF","CustomerAccount":"C-001"}.
Outputs
dataobject- Microsoft Dynamics 365 Finance & Operations response data.
Example output
{
"data": {}
}Get record
Get one record of a Finance and Operations data entity by its primary key values. Returns the record's fields.
Inputs
- Entity
entitytextRequired - Entity.
- Key
keyobjectRequired - Primary key fields and values from your entity metadata, for example {"dataAreaId":"USMF","CustomerAccount":"C-001"}.
Outputs
dataobject- Microsoft Dynamics 365 Finance & Operations response data.
Example output
{
"data": {}
}List entities
List the data entities available in the Finance and Operations environment, such as customers or vendors. Returns each entity's name, which the record actions need.
Inputs
None.
Outputs
dataobject- Microsoft Dynamics 365 Finance & Operations response data.
Example output
{
"data": {
"value": []
}
}List entity fields
Read field names, types and primary keys from the environment’s OData metadata.
Inputs
- Entity
entitytext - Entity.
Outputs
dataobject- Microsoft Dynamics 365 Finance & Operations response data.
Example output
{
"data": {
"fields": []
}
}List records
List records of one Finance and Operations data entity, with an optional filter, sort order, chosen fields and records from all legal entities. Returns the matching records.
Inputs
- Entity
entitytextRequired - Entity.
- Top
topnumber - Top.From 1 to 1000. Default:
100. - Next page token
skiptokentext - Use next_page_token from the preceding result; leave empty for the first page.
- Filter
filtertext - Filter.
- Cross company
cross_companytrue/false - Cross company.
- Select
selecttext - Select.
- Order by
order_bytext - Order by.
Outputs
dataobject- Microsoft Dynamics 365 Finance & Operations response data.
Example output
{
"data": {
"@odata.nextLink": "example",
"next_page_token": "example",
"value": []
}
}Update record
Change the named fields of one Finance and Operations record, found by its entity and primary key values.
Inputs
- Entity
entitytextRequired - Entity.
- Key
keyobjectRequired - Primary key fields and values from your entity metadata, for example {"dataAreaId":"USMF","CustomerAccount":"C-001"}.
- Changes
changesobjectRequired - Changes.
Outputs
dataobject- Microsoft Dynamics 365 Finance & Operations response data.
Example output
{
"data": {}
}