Microsoft Dynamics 365 Business Central API Configuration

For more information about authentication, accessing the Fivetran REST API, and request and response formats, see Getting Started with the Fivetran REST API.

Request

POST https://api.fivetran.com/v1/connections

{
  "group_id": "group_id",
  "service": "business_central",
  "trust_certificates": true,
  "trust_fingerprints": true,
  "run_setup_tests": true,
  "paused": false,
  "pause_after_trial": false,
  "sync_frequency": 1440,
  "data_delay_sensitivity": "NORMAL",
  "data_delay_threshold": 0,
  "daily_sync_time": "14:00",
  "schedule_type": "auto",
  "connect_card_config": {
    "redirect_uri": "https://your.site/path",
    "hide_setup_guide": true,
    "all_fields": true
  },
  "proxy_agent_id": "proxy_agent_id",
  "private_link_id": "private_link_id",
  "networking_method": "Directly",
  "hybrid_deployment_agent_id": "hybrid_deployment_agent_id",
  "destination_configuration": {
    "virtual_warehouse": "virtual_warehouse"
  },
  "destination_schema_names": "FIVETRAN_NAMING",
  "external_secrets_manager_id": "esm_id",
  "config": {
    "companies": [
      "string"
    ],
    "environment_name": "your_business_central_environment_name",
    "tenant_id": "your_business_central_tenant_id",
    "schema": "schema_name"
  },
  "auth": {
    "client_access": {
      "client_id": "your_business_central_client_id",
      "client_secret": "your_business_central_client_secret"
    },
    "refresh_token": "your_refresh_token"
  }
}

Config parameters

Name	Description
`companies`	List of companies to sync
`environment_name`	Name of the environment
`tenant_id`	`Tenant ID` of your Business Central application
`schema` (required)	Destination schema name. Schema name is permanent and cannot be changed after connection creation

Authorization

There are two ways to authorize this connector type:

By specifying the values for the client_access and refresh_token parameters in the auth section.

POST https://api.fivetran.com/v1/connections

{
  "service": "business_central",
  "group_id": "group_id",
  "auth": {
    "client_access": {
      "client_id": "your_business_central_client_id",
      "client_secret": "your_business_central_client_secret"
    },
    "refresh_token": "your_refresh_token"
  }
}

Auth Parameters

Name	Description
`client_access`
`client_access.client_id`	`Client ID` of your Airtable client application.
`client_access.client_secret`	`Client Secret` of your Airtable client application.
`refresh_token`	The long-lived refresh token along with the client ID and client secret parameters carry the information necessary to get a new access token for API resources.

By using the Connect Card or the Fivetran dashboard.