Click HERE to see how Saviynt Intelligence is transforming the industry. |
11/28/2022 07:31 AM
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.
12/01/2022 09:38 AM
Team,
Any update please
12/01/2022 09:43 AM
Please share API documentation or API you are used and configured
12/01/2022 10:00 AM
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
12/02/2022 10:27 AM
Hi Rushikesh,
Do you have a chance to look this request please
12/02/2022 10:31 AM
I dont have access to link shared.
If rest api are available you can use REST COnnector
12/02/2022 11:14 AM
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
}
}
}
}
}
}
12/02/2022 01:08 PM
What is error ?
12/02/2022 01:40 PM
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. |
12/02/2022 03:08 PM
Please change threshold limit
accountThresholdValue": 10000,
12/04/2022 07:54 PM
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
},
12/04/2022 08:37 PM
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
12/05/2022 06:43 AM
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
12/05/2022 03:33 PM
Enable additional logs on connector and validate
12/05/2022 10:13 PM
@sksuresh2k20please try encoding all the special characters ->$skip=0&$top=10000
12/06/2022 10:01 AM
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 |
12/07/2022 09:32 AM
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
12/13/2022 06:59 AM
Team,
Any feedback/Suggestions for CRM application integration