Data import
Connection details
| Parameter | Value |
|---|---|
| Base URL | https://api.businesscentral.dynamics.com/v2.0/{enviroment_name}/api/microsoft/automation/v2.0/companies({company_id})/ |
| Authentication type | OAuth2 Custom |
| Token endpoint | https://login.microsoftonline.com/{tenant_id}/oauth2/v2.0/token |
| OAuth token type | Bearer |
| Auth request body | grant_type=refresh_token&client_id={client_id}&client_secret={client_secret}&refresh_token={refresh_token}&scope=https://api.businesscentral.dynamics.com/.default offline_access |
| Auth request content type | application/x-www-form-urlencoded |
| Authentication server response format | JSON |
| Access Token Location | access_token |
| Authorization header | Authorization |
| Test connection | Select the checkbox |
| Test query | users |
Queries and mappings
The following mappings are available out of the box:
Users - accounts
Parameters:
| Tab | Parameter | Value |
|---|---|---|
| General | URL | users |
| Advanced | HTTP verb | GET |
Mappings:
| Destination | Operator | Source |
|---|---|---|
| Business key | Map | userSecurityId |
| Unique ID | Map | userSecurityId |
| Account Name | Map | userName |
| Status | Expression | state == "Enabled" ? "Active" : state |
| Distinguished name | Map | userSecurityId |
Permission sets – resources
Parameters:
| Tab | Parameter | Value |
|---|---|---|
| General | URL | permissionSets |
| Advanced | HTTP verb | GET |
Mappings:
| Destination | Operator | Source |
|---|---|---|
| Business key | Map | id |
| Security resource business key | Map | id |
| Name | Map | displayName |
| Category | Constant | Permission |
| Type | Constant | Business Central Permissions |
| Short name | Map | roleId |
| appId | Map | appId |
Permission sets – assignments
Parameters:
| Tab | Parameter | Value |
|---|---|---|
| General | URL | users |
| Advanced | HTTP verb | GET |
| Nested Requests | Nested URL | users({PARENT_userSecurityId})/userPermissions |
Mappings:
| Destination | Operator | Source |
|---|---|---|
| Resource business key | Map | roleId |
| Account – business key | Map | userSecurityId |
| userPermissionId | Map | id |
User groups – resources
Parameters:
| Tab | Parameter | Value |
|---|---|---|
| General | URL | userGroups |
| Advanced | HTTP verb | GET |
Mappings:
| Destination | Operator | Source |
|---|---|---|
| Business key | Map | code |
| Security resource business key | Map | code |
| Name | Map | displayName |
| Category | Constant | Permission |
| Type | Constant | Business Central Group |
| Short name | Map | code |
User groups - assignments
Parameters:
| Tab | Parameter | Value |
|---|---|---|
| General | URL | userGroups |
| Advanced | HTTP verb | GET |
| Nested Requests | Nested URL | users({PARENT_userSecurityId})/userGroupMembers |
Mappings:
| Destination | Operator | Source |
|---|---|---|
| Resource business key | Map | code |
| Account – business key | Map | userSecurityId |
| userGroupMemberId | Map | id |
Security groups – resources
Parameters:
| Tab | Parameter | Value |
|---|---|---|
| General | URL | securityGroups |
| Advanced | HTTP verb | GET |
Mappings:
| Destination | Operator | Source |
|---|---|---|
| Business key | Map | code |
| Security resource business key | Map | code |
| Name | Map | groupName |
| Category | Constant | Permission |
| Type | Constant | Business Central - security groups |
| Short name | Map | code |
Security groups – assignments
Parameters:
| Tab | Parameter | Value |
|---|---|---|
| General | URL | securityGroupMembers |
| Advanced | HTTP verb | GET |
Mappings:
| Destination | Operator | Source |
|---|---|---|
| Resource business key | Map | securityGroupCode |
| Account – business key | Map | userSecurityId |
Account rules
The Omada Business Central connectivity has the following Account rules:
Ownership rule
The account owner is set to the identity where the Identity's unique ID value of the identity matches the Name value of the account.
| Field | Value |
|---|---|
| Type | Identity lookup |
| Join reason | Exact Match |
| Account attribute | Name |
| Identity attribute | Identity’s unique ID |
Classification rule
If an account with the account attribute Identity join reason equals Exact Match, the account type is set to Personal.
| Field | Value |
|---|---|
| Account type | Personal |
| Scope attribute | Identity join reason |
| Scope operator | Equals |
| Scope value | Exact Match |