Microsoft Dynamics 365 Finance and Operations API Configuration

Request

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

{
  "group_id": "group_id",
  "service": "microsoft_dynamics_365_fno",
  "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": {
    "auth_method": "CONNECTION_STRING | SERVICE_PRINCIPAL_SECRET",
    "connection_string": "BlobEndpoint=https://abc123.blob.core.windows.net/;TableEndpoint=https://abc123.table.core.windows.net/;SharedAccessSignature=xxxxxxxxx",
    "container_name": "container_name",
    "source_file_type": "PARQUET | CSV",
    "storage_account_name": "storage_account_name",
    "sync_all_versions": true,
    "schema": "schema_name"
  },
  "auth": {
    "client_id": "my_client_id",
    "client_secret": "my_client_secret",
    "tenant_id": "41db1ebd-41a6-4dda-8029-5dd8f227d843"
  }
}

Config parameters

Name	Description
`auth_method`	Authentication Method
`connection_string`	The blob storage container's connection string.
`container_name`	The name of the blob container.
`source_file_type`	The file type of the source files. Supported file types are `CSV` and `PARQUET`.
`storage_account_name`	The name of the Azure Storage account.
`sync_all_versions`	Specify if all versions of the records should be synced. If set to `true`, all versions of the records will be synced. If set to `false`, only the latest version of the records will be synced.
`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 container_name and connection_string parameters in the request.

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

{
  "service": "microsoft_dynamics_365_fno",
  "group_id": "group_id",
  "config": {
    "container_name": "container_name",
    "connection_string": "BlobEndpoint=https://abc123.blob.core.windows.net/;TableEndpoint=https://abc123.table.core.windows.net/;SharedAccessSignature=xxxxxxxxx"
  }
}

By using the Connect Card or the Fivetran dashboard.