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. You can use this connector with Dynamics NAV 2017 or later.
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 - US Department of Defense (DoD) |
| Power Automate | Premium | All Power Automate regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Power Apps | Premium | All Power Apps regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Connector Metadata | |
|---|---|
| Publisher | Microsoft |
| Website | https://dynamics.microsoft.com/nav-overview/ |
Creating a connection
The connector supports the following authentication types:
| Default | Parameters for creating connection. | All regions | Shareable |
Default
Applicable: All regions
Parameters for creating connection.
This is shareable connection. If the power app is shared with another user, connection is shared as well. For more information, please see the Connectors overview for canvas apps - Power Apps | Microsoft Docs
| Name | Type | Description | Required |
|---|---|---|---|
| OData Feed URL | string | OData Feed URL | True |
| Username | securestring | Username | True |
| Password | securestring | Password | True |
| Company | string | Company | True |
Throttling Limits
| Name | Calls | Renewal Period |
|---|---|---|
| API calls per connection | 100 | 60 seconds |
Actions
| Create item |
Creates a DynamicsNavision item |
| Delete item |
Deletes a DynamicsNavision item |
| Get item |
Retrieves a DynamicsNavision item |
| Get item types |
Retrieves Dynamics NAV item types |
| Update item |
Updates an existing DynamicsNavision item |
Create item
Creates a DynamicsNavision item
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Table name
|
table | True | string |
Name of Dynamics NAV table |
|
Row
|
item | True | dynamic |
Row to insert into the specified table in Dynamics NAV |
Returns
Delete item
Deletes a DynamicsNavision item
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Table name
|
table | True | string |
Name of Dynamics NAV table |
|
Row id
|
id | True | string |
Unique identifier of the row to delete |
Get item
Retrieves a DynamicsNavision item
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Table name
|
table | True | string |
Name of Dynamics NAV table |
|
Row id
|
id | True | string |
Unique identifier of the row to retrieve |
Returns
Get item types
Update item
Updates an existing DynamicsNavision item
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Table name
|
table | True | string |
Name of Dynamics NAV table |
|
Row id
|
id | True | string |
Unique identifier of the row to update |
|
Row
|
item | True | dynamic |
Row with updated values |
Returns
Triggers
| When a record is created [DEPRECATED] |
Triggers a flow when a record is created in Dynamics NAV |
| When a record is deleted [DEPRECATED] |
Triggers a flow when a record is deleted in Dynamics NAV |
| When a record is modified [DEPRECATED] |
Triggers a flow when a record is modified in Dynamics NAV |
When a record is created [DEPRECATED]
Triggers a flow when a record is created in Dynamics NAV
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Table name
|
table | True | string |
Name of Dynamics NAV table |
|
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). |
Returns
When a record is deleted [DEPRECATED]
Triggers a flow when a record is deleted in Dynamics NAV
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Table name
|
table | True | string |
Name of Dynamics NAV table |
|
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). |
Returns
When a record is modified [DEPRECATED]
Triggers a flow when a record is modified in Dynamics NAV
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Table name
|
table | True | string |
Name of Dynamics NAV table |
|
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). |
Returns
Definitions
Table
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. |
TablesList
Represents a list of tables.
| Name | Path | Type | Description |
|---|---|---|---|
|
value
|
value | array of Table |
List of Tables |