ePrivacy and GPDR Cookie Consent by Cookie Consent Skip to main content

Connector Microsoft Dynamics

This connector enables you to connect to Microsoft data sources.

Data In/Data Out

Data In N/A
Data Out Output CSV file will be named as specified in the Endpoint and Extract All sections.

Requirements

It is needed to generate a token, client ID and client Secret in order to access the account.

Parameters

dynamics 01.png

Client ID (required) ID name that was used. 

Learn more: about Client ID here
Client Secret (required) Client secret is obtained upon registering your app here.
Redirect URI (required)

It is the location where the authorization server sends the user once the app has been successfully authorized and granted an authorization code or access token. 

 

Learn more:  about Redirect URI, please refer to this article.

Resource (required) this is the URL of your CRM.
Refresh Token (required) The

Refresh tokens are the credentials that can be used to acquire new access tokens.

 

dynamics 02.png

Hours Back (required)

hours_back can be set to a value of infinity to download the whole history. Otherwise, it can be specified to the particular number of hours.
Endpoint (required) This describes the entity you want to download from the CRM. You can choose to download only few hours/days/weeks of data.
Tablename (required) Specify table name. Otherwise, it will be fetched from the Endpoint
Primary Key (required)

Primary key indicates which column from the downloaded table (endpoint) is unique (used as primary key). 

 

dynamics 03.png

Endpoint (required)

  This describes the entity you want to download from the CRM and it will download the whole table.
Tablename (optional) Name of table to extract. 

 

 

 

Back to top