Dynamics NAV (Preview)

Dynamics NAV (Preview)

Dynamics NAV is a business management solution for small and mid-sized organizations that automates and streamlines business processes and helps you manage your business.

This connector is available in the following products and regions:

Service Class Regions
Logic Apps Standard All Logic Apps regions except the following:
     -   Azure Government regions
     -   Azure China regions
Flow Standard All Flow regions
PowerApps Standard All PowerApps regions

Throttling Limits

Name Calls Renewal Period
API calls per connection 100 60 seconds

Creating a connection

To connect your account, you will need the following information:

OData Feed URL
string
OData Feed URL
Username
securestring
Username
Password
securestring
Password
Company
string
Company

Actions

Create item

Creates a DynamicsNavision item

Required Parameters

Table name
string
Name of Dynamics NAV table
Row
dynamic
Row to insert into the specified table in Dynamics NAV

Returns

The outputs of this operation are dynamic.

Delete item

Deletes a DynamicsNavision item

Required Parameters

Table name
string
Name of Dynamics NAV table
Row id
string
Unique identifier of the row to delete

Returns

The outputs of this operation are dynamic.

Get item

Retrieves a DynamicsNavision item

Required Parameters

Table name
string
Name of Dynamics NAV table
Row id
string
Unique identifier of the row to retrieve

Returns

The outputs of this operation are dynamic.

Get item types

Retrieves Dynamics NAV item types

Required Parameters

Table name
string
Name of Dynamics NAV table
Row
dynamic
Row to insert into the specified table in Dynamics NAV

Returns

Body
TablesList

Represents a list of tables.

Update item

Updates an existing DynamicsNavision item

Required Parameters

Table name
string
Name of Dynamics NAV table
Row id
string
Unique identifier of the row to update
Row
dynamic
Row with updated values

Returns

The outputs of this operation are dynamic.

Triggers

When a record is created [DEPRECATED]

Triggers a flow when a record is created in Dynamics NAV

Required Parameters

Table name
string
Name of Dynamics NAV table

Optional Parameters

Filter Query
string
An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).
Order By
string
An ODATA orderBy query for specifying the order of entries.
Top Count
integer
Total number of entries to retrieve (default = all).
Skip Count
integer
The number of entries to skip (default = 0).

Returns

The outputs of this operation are dynamic.

When a record is deleted [DEPRECATED]

Triggers a flow when a record is deleted in Dynamics NAV

Required Parameters

Table name
string
Name of Dynamics NAV table

Optional Parameters

Filter Query
string
An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).
Order By
string
An ODATA orderBy query for specifying the order of entries.
Top Count
integer
Total number of entries to retrieve (default = all).
Skip Count
integer
The number of entries to skip (default = 0).

Returns

The outputs of this operation are dynamic.

When a record is modified [DEPRECATED]

Triggers a flow when a record is modified in Dynamics NAV

Required Parameters

Table name
string
Name of Dynamics NAV table

Optional Parameters

Filter Query
string
An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).
Order By
string
An ODATA orderBy query for specifying the order of entries.
Top Count
integer
Total number of entries to retrieve (default = all).
Skip Count
integer
The number of entries to skip (default = 0).

Returns

The outputs of this operation are dynamic.

Definitions

Table

Represents a table.

DisplayName
string
The display name of the table.
Name
string
The name of the table. The name is used at runtime.

TablesList

Represents a list of tables.

value
array of Table
List of Tables