Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Display Adobe campaign marketing History in Dynamics CRM

Avatar

Avatar
Ignite 1
Level 2
anjalis9208738
Level 2

Likes

7 likes

Total Posts

12 posts

Correct Reply

0 solutions
Top badges earned
Ignite 1
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Ignite 1
Level 2
anjalis9208738
Level 2

Likes

7 likes

Total Posts

12 posts

Correct Reply

0 solutions
Top badges earned
Ignite 1
Validate 1
Boost 5
Boost 3
Boost 1
View profile
anjalis9208738
Level 2

20-02-2018

Hi,

Can some one please help.

Goal- Display Adobe Campaign marketing history in Dynamics CRM.

Initial Steps-

1) Created contact in Dynamics 365.

2) Imported contact using CRM connector in Adobe Campaign

1424144_pastedImage_0.png

1424145_pastedImage_1.png

3) Sent an email to the above contact in Adobe campaign.

4) In CRM Dynamics Contact record, I want to Show the same below summary from Adobe Campaign

1424146_pastedImage_2.png

5) I added an iframe in CRM contact form editor. Where URL=https://ac366ap.adobesandbox.com/crm/marketingHistory.jssp?object=Contact&crm=EXT51

1424147_pastedImage_3.png

6) After saving and Publishing, I am getting below error-

1424148_pastedImage_4.png

Thanks a lot in advance!!

Replies

Avatar

Avatar
Validate 1
Level 2
shivak41694392
Level 2

Likes

3 likes

Total Posts

20 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
shivak41694392
Level 2

Likes

3 likes

Total Posts

20 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
shivak41694392
Level 2

25-02-2018

Hi ,

How did you go with the integration with CRM.

We are planning to do this integration and wanted to know how the template sharing works.

thanks

Avatar

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile
florentlb
Level 10

13-03-2018

Hi,

So in your use case you are trying to display Campaign information directly in Dynamics, without having all the info in Dynamics? I'm not sure it's very clear to me.

Thanks,

Florent

Avatar

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile
florentlb
Level 10

04-04-2018

Hi,

Any update on this?

Florent

Avatar

Avatar
Boost 1
Level 1
glvarrichio
Level 1

Like

1 like

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
glvarrichio
Level 1

Like

1 like

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
glvarrichio
Level 1

04-01-2019

Hi,

Were you able to address the issue and make it happen?

Please comment how you did it please, we are having the same issue from our side.

Regards

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

960 likes

Total Posts

1,087 posts

Correct Reply

506 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

960 likes

Total Posts

1,087 posts

Correct Reply

506 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

04-01-2019

Hi,

Alter the marketingHistory.jssp to use the CRM's key in its queries.

You should also be adding a layer of security here, via IP whitelisting, HTTP auth, or authenticating in jssp against user id param (and sync'ing user table).

Thanks,

-Jon

Avatar

Avatar
Boost 1
Level 1
glvarrichio
Level 1

Like

1 like

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
glvarrichio
Level 1

Like

1 like

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
glvarrichio
Level 1

04-01-2019

Hi Jon,

All IPs were whitelisted, config were done like the description of the initial question in this forum and here is what I came up with:

"Error while querying the database"

No other message is displayed so I dont know if it is the leadid, remoteID, or anything else that is causing the issue.

Any Ideas Jon?

Regards

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

960 likes

Total Posts

1,087 posts

Correct Reply

506 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

960 likes

Total Posts

1,087 posts

Correct Reply

506 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

04-01-2019

You can find the code in crm:marketingHistoryCommon.js, function LogContext.prototype.getSpecificData.

The relevant section is this first block, which looks up the recipient id:

  // It is a contact requested by its Neolane recipient Id, assert its existence

  if( this.m_iRecipientId )

  {

    var xmlQuery =

      <queryDef schema="nms:recipient" operation="select">

        <select>

          <node expr="[@id]" alias="[@recipientId]"/>

          <node expr="[@crmInstance-id]" alias="[@crmInstanceId]"/>

          <node expr="[@id]"/>

        </select>

        <where>

          <condition expr={"[@id] = " + this.m_iRecipientId}/>

        </where>

      </queryDef>;

  }

Change this block to look up the recipient by the crm's id, the remaining blocks can be discarded (lines 979-1065).

Much of the code here is for the deprecated Leads module, with this page being repurposed for non-Leads use.

Avatar

Avatar
Level 1
varrichio
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
varrichio
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
View profile
varrichio
Level 1

05-01-2019

Great, I found it, thank you....

It is saying it cannot be modified? Any trick?

"This is an application built-in object. It cannot be modified"

Should I create another one with the same name with the modifications or is there any trick to allow me to change the code?

I have full admin access to the instance

Sorry for for all these questions.....

thanks in advance

Avatar

Avatar
Level 1
varrichio
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
varrichio
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
View profile
varrichio
Level 1

05-01-2019

I duplicated and changed the name and namespace of the js and jssp:

MyNameSpace:marketingHistoryV2.jssp

MyNameSpace:marketingHistoryCommonV2.js

and changed the where condition to <condition expr={"[@id] = " + this.m_sCtm_leadid}/>

Please let me know if I´m on the right path.

Thank you

// It is a contact requested by its Neolane recipient Id, assert its existence

  if( this.m_iRecipientId )

  {

    var xmlQuery =

      <queryDef schema="nms:recipient" operation="select">

        <select>

          <node expr="[@id]" alias="[@recipientId]"/>

          <node expr="[@crmInstance-id]" alias="[@crmInstanceId]"/>

          <node expr="[@id]"/>

        </select>

        <where>

          <condition expr={"[@id] = " + this.m_sCtm_leadid}/>

        </where>

      </queryDef>;

  }