Microsoft Dynamics 365 Business Central API Configuration
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 }, "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": "SOURCE_NAMING", "config": { "tenant_id": "your_business_central_tenant_id", "companies": [ "string" ], "environment_name": "your_business_central_environment_name", "schema": "schema_name" }, "auth": { "refresh_token": "your_refresh_token", "client_access": { "client_secret": "your_business_central_client_secret", "client_id": "your_business_central_client_id" } } }
Config parameters
| Name | Description |
|---|---|
tenant_id | Tenant ID of your Business Central application |
companies | List of companies to sync |
environment_name | Name of the environment |
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_accessandrefresh_tokenparameters in theauthsection.POST https://api.fivetran.com/v1/connections{ "service": "business_central", "group_id": "group_id", "auth": { "client_access": { "client_secret": "your_business_central_client_secret", "client_id": "your_business_central_client_id" }, "refresh_token": "your_refresh_token" } }Auth Parameters
Name Description refresh_tokenThe 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. client_accessclient_access.client_secretClient Secretof your Airtable client application.client_access.client_idClient IDof your Airtable client application. By using the Connect Card or the Fivetran dashboard.