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"
},
"config": {
"auth_method": "SERVICE_PRINCIPAL_SECRET",
"storage_account_name": "storage_account_name",
"container_name": "container_name",
"connection_string": "BlobEndpoint=https://abc123.blob.core.windows.net/;TableEndpoint=https://abc123.table.core.windows.net/;SharedAccessSignature=xxxxxxxxx",
"schema": "schema_name"
},
"auth": {
"tenant_id": "41db1ebd-41a6-4dda-8029-5dd8f227d843",
"client_secret": "my_client_secret",
"client_id": "my_client_id"
}
}Config parameters
| Name | Description |
|---|---|
auth_method | Authentication Method |
storage_account_name | The name of the Azure Storage account. |
container_name | The name of the blob container. |
connection_string | The blob storage container's connection string. |
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_nameandconnection_stringparameters 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.