Dynamics365 CRM application integration with Saviynt EIC Version 2022

[sksuresh2k20]

Hello Team

Since we are trying to integrate Dynamics 365 CRM application with Saviynt EIC Version 2022 to pull the D365 CRM account using the REST connector, but we are getting a null result after completing the account Import job, however, it's working for Dynamics 365 Finance and Operation application.

We would need to know the Saviynt feasibility for CRM application integration, Please share with us your experience if you have done anywhere the CRM implementation.

[sksuresh2k20]

Team,

Any update please

[rushikeshvartak]

Please share API documentation or API you are used and configured

[sksuresh2k20]

Hi Rushikesh,

Thank you for the response!

Attached FS document followed for configuring, D365 and REST connection, however Documents says for F&O application, but we are trying to integrate CRM application

https://org806ca454.api.crm8.dynamics.com

[sksuresh2k20]

Hi Rushikesh,

Do you have a chance to look this request please

[rushikeshvartak]

I dont have access to link shared.

If rest api are available you can use REST COnnector

[sksuresh2k20]

Yes, we have tried REST Connector but it's not picking the CRM accounts, below is the account import JSON and connection JSON are using

We would need to understand the Saviynt feasibility for CRM application. Please advise

Connection:

{
"authentications": {
"userAuth": {
"authType": "oauth2",
"url": "https://login.microsoftonline.com/Tenant_ID/oauth2/token",
"httpMethod": "POST",
"httpParams": {
"client_id": " ",
"client_secret": " ",
"grant_type": "client_credentials",
"resource": "https://org806ca454.crm8.dynamics.com"
},
"httpHeaders": {
"Content-Type": "application/x-www-form-urlencoded"
},
"httpContentType": "application/x-www-form-urlencoded",
"expiryError": "ExpiredAuthenticationToken",
"authError": [
"USER_AUTHENTICATION_FAILED",
"PARTNER_AUTHENTICATION_FAILED",
"AuthenticationFailed"
],
"timeOutError": "Read timed out",
"errorPath": "errorCode",
"maxRefreshTryCount": 5,
"tokenResponsePath": "access_token",
"tokenType": "Bearer",
"retryFailureStatusCode": [
401
],
"accessToken": "Bearer abc"
}
}
}

Account Import :

{
"accountParams": {
"connection": "userAuth",
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {
"statusColumn": "customproperty10",
"activeStatus": [
true
],
"deleteLinks": true,
"accountThresholdValue": 100,
"correlateInactiveAccounts": true,
"inactivateAccountsNotInFile": true,
"deleteAccEntForActiveAccounts": true
},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://org806ca454.api.crm8.dynamics.com/api/data/v9.2/$metadata#accounts",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "value",
"keyField": "accountID",
"colsToPropsMap": {
"accountID": "UserID~#~char",
"customproperty1": "Alias~#~char",
"customproperty10": "Enabled~#~char",
"customproperty45": "WorkflowLineItemNotificationFormat~#~char",
"customproperty11": "DocumentHandlingActive~#~char",
"customproperty12": "UserInfo_defaultPartition~#~char",
"customproperty13": "GlobalListPageLinkMode~#~char",
"customproperty14": "GlobalExcelExportMode~#~char",
"customproperty15": "ShowAttachmentStatus~#~char",
"customproperty16": "EventPopUpLinkDestination~#~char",
"customproperty17": "NetworkDomain~#~char",
"customproperty18": "Company~#~char",
"customproperty19": "SqmGUID~#~char",
"customproperty2": "Email~#~char",
"customproperty20": "SendNotificationsInEmail~#~char",
"customproperty21": "Density~#~char",
"customproperty22": "DefaultCountryRegion~#~char",
"customproperty23": "SendAlertAsEmailMessage~#~char",
"customproperty24": "SqmEnabled~#~char",
"customproperty25": "GlobalExcelExportFilePath~#~char",
"customproperty26": "Language~#~char",
"customproperty27": "EventPopUpDisplayWhen~#~char",
"customproperty28": "EventPollFrequency~#~char",
"customproperty29": "EventWorkflowShowPopup~#~char",
"customproperty3": "EmailProviderID~#~char",
"customproperty30": "StartPage~#~char",
"customproperty31": "PreferredTimeZone~#~char",
"customproperty32": "HomePageRefreshDuration~#~char",
"customproperty33": "UserInfo_language~#~char",
"customproperty34": "AutoLogOff~#~char",
"customproperty35": "Theme~#~char",
"customproperty36": "MarkEmptyLinks~#~char",
"customproperty37": "Enabled~#~char",
"customproperty38": "ShowNotificationsInTheMicrosoftDynamicsAX7Client~#~char",
"customproperty39": "Helplanguage~#~char",
"customproperty4": "PersonName~#~char",
"customproperty40": "EventPopUps~#~char",
"customproperty41": "PreferredCalendar~#~char",
"customproperty42": "PreferredLocale~#~char",
"customproperty43": "ExternalUser~#~char",
"customproperty44": "AutomaticUrlUpdate~#~char",
"displayName": "UserName~#~char",
"name": "UserName~#~char"
},
"pagination": {
"offset": {
"offsetParam": "$skip",
"batchParam": "$top",
"batchSize": 10000,
"totalCountPath": 999999999
}
}
}
}
}
}

[rushikeshvartak]

What is error ?

[sksuresh2k20]

Getting below error

ob Name	Application Data Import (Single Threaded)
Job Type	full
Import Type	accounts
Error WebService call failed After retrying 5 times with responseStatusCode null	Failed url-https://org806ca454.api.crm8.dynamics.com/api/data/v9.2/$metadata#accounts?$skip=0&$top=10000 with Error Message-null
Error while getting Account Import Response WebService call failed with responseStatusCode null	Failed url-https://org806ca454.api.crm8.dynamics.com/api/data/v9.2/$metadata#accounts?$skip=0&$top=10000 with Error Message-null
Warning ThresholdValueExceeded	accountThresholdValue limit exceeded. No changes has been imported from Recon.

[rushikeshvartak]

Please change threshold limit

accountThresholdValue": 10000,

[sksuresh2k20]

same issue has occurred after modifying the "accountThresholdValue": 10000, Please advise.

Error - to Import Data correctly: Failed
url-https://org806ca454.api.crm8.dynamics.com/api/
data/v9.2/$metadata#accounts?$skip=0&$top=10000
with Error Message-null

},

[Vedanth_BK]

Hi @sksuresh2k20,

The URL needs to be encoded. Please try the below URL-

https://org806ca454.api.crm8.dynamics.com/api/data/v9.2/%24metadata%23accounts

Thank you

[sksuresh2k20]

Thanks, Vedanth unfortunately, we have the same issue. Have you guys implemented the CRM application with any of your customers? because I was tested earlier F&O was working fine with REST connection.

Failed url-https://org806ca454.api.crm8.dynamics.com/api/data/v9.2/%24metadata%23accounts?$skip=0&$top=10000 with Error Message-null

[rushikeshvartak]

Enable additional logs on connector and validate

[Vedanth_BK]

@sksuresh2k20please try encoding all the special characters ->$skip=0&$top=10000

[sksuresh2k20]

Still same error

Failed url-https://org806ca454.api.crm8.dynamics.com/api/data/v9.2/%24metadata%23accounts?$skip=0=0&$top=10000=10000 with Error Message-null

[sksuresh2k20]

Hi Vedanth_BK,

The below article says that the Saviynt Out of Box connector to Integrating CRM capabilities, please let me know if you have documentation or KB article for this 

Saviynt_AAG_MSDynamics365.pdf

[sksuresh2k20]

Team,

Any feedback/Suggestions for CRM application integration