Microsoft Dynamics 365 Finance & Operations

App · 7 actions

Query and manage public Finance and Operations data entities using your environment’s OData catalog.

Actions

ActionWhat it does
Create recordCreate a record in a Finance and Operations data entity from the field values you give.
Delete recordDelete one record from a Finance and Operations data entity, by its primary key values.
Get recordGet one record of a Finance and Operations data entity by its primary key values.
List entitiesList the data entities available in the Finance and Operations environment, such as customers or vendors.
List entity fieldsRead field names, types and primary keys from the environment’s OData metadata.
List recordsList records of one Finance and Operations data entity, with an optional filter, sort order, chosen fields and records from all legal entities.
Update recordChange 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

EntityentitytextRequired
Entity.
RecordrecordobjectRequired
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

EntityentitytextRequired
Entity.
KeykeyobjectRequired
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

EntityentitytextRequired
Entity.
KeykeyobjectRequired
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

Entityentitytext
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

EntityentitytextRequired
Entity.
Toptopnumber
Top.From 1 to 1000. Default: 100.
Next page tokenskiptokentext
Use next_page_token from the preceding result; leave empty for the first page.
Filterfiltertext
Filter.
Cross companycross_companytrue/false
Cross company.
Selectselecttext
Select.
Order byorder_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

EntityentitytextRequired
Entity.
KeykeyobjectRequired
Primary key fields and values from your entity metadata, for example {"dataAreaId":"USMF","CustomerAccount":"C-001"}.
ChangeschangesobjectRequired
Changes.

Outputs

dataobject
Microsoft Dynamics 365 Finance & Operations response data.
Example output
{
  "data": {}
}

On this page