I was working on the integration of Adobe Campaign v6 with MS Dynamics 365 online. I have successfully imported contacts from MS dynamics to campaign.
Now I want to export campaign data to MS dynamics, While I was configuring the 'CRM connector' activity for doing the same. I came across this issue.
Mapping is needed in this activity.
Under the Adobe Campaign , there is an edit expression (highlighted part) icon . It is not working. When I click on it , nothing happens or no list of columns appear nor am I able to type anything there whereas Remote CRM columns are appearing.
Not sure as to why this is not enabled. Do I have to change/add something which might be causing this not to work as intended,
Using Microsoft CRM, you need to identify the Unique local/remote key/modification date properties as in below example snapshot:
Hope this helps,
I was searching and found your tips to Senthil.
I followed the same steps, first started with the Generic CRM tahat failed with the following error,
Synchronize CRM ClientDev(Import from CRM)
INT-150012 The HTTP query returned a 'Internal Server Error' type error (500)
Error during remote search query. Query: '<query i:type="b:QueryExpression" xmlns:b="http://schemas.microsoft.com/xrm/2011/Contracts" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <b:ColumnSet> <b:AllColumns>false</b:AllColumns> <b:Columns xmlns:c="http://schemas.microsoft.com/2003/10/Serialization/Arrays"> <c:string>leadid</c:string> <c:string>firstname</c:string> </b:Columns> </b:ColumnSet> <b:EntityName>lead</b:EntityName> <b:PageInfo> <b:Count>100</b:Count><b:PageNumber>1</b:PageNumber> </b:PageInfo> </query>', cause: 'Unexpected exception from plug-in (Execute): Client.Tools.SearchPlugin.SearchPlugin: System.NullReferenceException: Object reference not set to an instance of an object.'.
Then I changed to Microsoft CRM and started getting the issue below:
And I tried to give a try and navgated at Dynamics, by opening a Contact or Leads I got this.
Any clue on what is happening? I believe it is something at Dynamics API
I am using Dynamics 365 and try to integrate with Adobe campaign using adobe crm connector.
I am facing an error when configuring external accounts. Api registration in AAD is correct and Adobe was able to generate the table list and create a schema, but later days again it is requesting to configure the external accounts and stopped working. There was no change in configuration adobe, D365 or azure. Any pointers will be helpful
Thanks for the suggestion Florent.
I created the workflow using Dynamics CRM activity. Now I am able to map the values, although I am facing few errors after running the workflow.
|17/07/05 07:45:06||processed: 0, inserted: 0, updated: 0, rejected: 0, deleted: 0, ignored: 0.|
|2017/07/05 07:45:06||A remote key must be defined on a remote field and a local field.|
A local change date must be defined on a remote field an a local field.
A local key must be defined on a local fields.
A remote modification date must be defined on a local field.
|2017/07/05 07:45:05||Call Microsoft CRM - contact|
|2017/07/05 07:45:01||CRM deployment type: ondemand|
Could you please help me resolve this issue? I checked the docs. I could not find much of details regarding this activity. What is the property column meant for , in here?
This seems odd to me. Can you try to create the workflow from within a campaign (create a campaign and go to its workflow tab) and by using instead the "Dynamics CRM" (this one is located in the Actions tab of the activities) activity rather than the generic "CRM connector"?
Let me know,
I checked the workflow properties , Targeting dimension is Recipients.
I am using a Read List activity (it contains the recipients data that I want to export) before CRM connector in my workflow.
Issue hasn't resolved yet.
could there be any other reason as to why I am unable to select any of the campaign based columns.
Can you check that the targeting dimension defined in the workflow properties or in this specific activity does match nms:recipients or any other table you are actually using it for (in case you have custom profile table).
Let me know,