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

Get primary key of Recipient in Adobe Standard workflow - Query Activity

Avatar

Avatar
Give Back 5
Level 3
santhoshsrg
Level 3

Likes

22 likes

Total Posts

56 posts

Correct Reply

2 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile

Avatar
Give Back 5
Level 3
santhoshsrg
Level 3

Likes

22 likes

Total Posts

56 posts

Correct Reply

2 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile
santhoshsrg
Level 3

05-03-2019

How to get primary of Recipient key passed to the next transition in Query Activity in ACS?

Replies

Avatar

Avatar
Give Back 5
Level 3
santhoshsrg
Level 3

Likes

22 likes

Total Posts

56 posts

Correct Reply

2 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile

Avatar
Give Back 5
Level 3
santhoshsrg
Level 3

Likes

22 likes

Total Posts

56 posts

Correct Reply

2 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile
santhoshsrg
Level 3

05-03-2019

How to get primary key of Recipient passed to the next transition in Query Activity in ACS?

Avatar

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

370 likes

Total Posts

726 posts

Correct Reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

370 likes

Total Posts

726 posts

Correct Reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
Vapsy
Employee

06-03-2019

Hi santhoshsrg,

The PK value is automatically moved forward in the transition but if you will try to view it, it will appear as encrypted. It has been done to enhance security.

What is the exact use case?

Regards,
Vipul

Avatar

Avatar
Give Back 5
Level 3
santhoshsrg
Level 3

Likes

22 likes

Total Posts

56 posts

Correct Reply

2 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile

Avatar
Give Back 5
Level 3
santhoshsrg
Level 3

Likes

22 likes

Total Posts

56 posts

Correct Reply

2 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile
santhoshsrg
Level 3

07-03-2019

Hi Vipul,

I want to query a custom resource cusRes in query activity. The custom resource is linked to profile(recipient).

I want to pass the exact(Without encryption) "profile primary key"(cusRes/profile/id) to the next activity through the "ADDITIONAL DATA" section in Query activity. Is this possible?

Avatar

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

370 likes

Total Posts

726 posts

Correct Reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

370 likes

Total Posts

726 posts

Correct Reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
Vapsy
Employee

07-03-2019

Hi santhoshsrg,

Any reason why you wish to pass the ID of profile (linked to your cusResource?

If you fetch an attribute of profile schema inside the next activity, system is intelligent enough to make use of ID value to create an inner join.

Sorry of this is a redundant question but I'm trying to assist on your business use case.

Regards,
Vipul

Avatar

Avatar
Give Back 5
Level 3
santhoshsrg
Level 3

Likes

22 likes

Total Posts

56 posts

Correct Reply

2 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile

Avatar
Give Back 5
Level 3
santhoshsrg
Level 3

Likes

22 likes

Total Posts

56 posts

Correct Reply

2 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile
santhoshsrg
Level 3

07-03-2019

Hi Vipul,

I want to store the Profile Id field in a file or database table

Avatar

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

370 likes

Total Posts

726 posts

Correct Reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

370 likes

Total Posts

726 posts

Correct Reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
Vapsy
Employee

11-03-2019

Hi santhoshsrg,

Better to make use of customerID from CRM (if there is one). It will be a more relatable value which can be used across solutions.

Campaign PK value is not the right field to lookout for.

Regards,
Vipul

Avatar

Avatar
Give Back 5
Level 3
santhoshsrg
Level 3

Likes

22 likes

Total Posts

56 posts

Correct Reply

2 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile

Avatar
Give Back 5
Level 3
santhoshsrg
Level 3

Likes

22 likes

Total Posts

56 posts

Correct Reply

2 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile
santhoshsrg
Level 3

12-03-2019

Hi Vipul,

I have another case where i want to remove duplicate recipient records using Primary key in Deduplication activity. Kindly provide your feedback if this is feasible or not in Adobe campaign standard?

Avatar

Avatar
Give Back 5
Level 4
prasannakumarmarru
Level 4

Likes

51 likes

Total Posts

59 posts

Correct Reply

17 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 10
Give Back
Boost 50
View profile

Avatar
Give Back 5
Level 4
prasannakumarmarru
Level 4

Likes

51 likes

Total Posts

59 posts

Correct Reply

17 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 10
Give Back
Boost 50
View profile
prasannakumarmarru
Level 4

03-12-2019

You will never have duplicate profiles based on primary key because primary key is always unique. I think you might have to deduplicate based on other field like email address.

Thanks!