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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Query and count specific identities for all profiles

Avatar

Level 1

Hi All,

 

Is there a way to query and find for a specific identity such as CRM ID whether a profile has more than 1 value of this type?

 

Cheers

Robert

 

1 Accepted Solution

Avatar

Correct answer by
Employee
  1. ID Graph Viewer
  2. Profile API
  3. ID Graph API
  4. Query Service on the Profile Snapshot Export xxx dataset

View solution in original post

5 Replies

Avatar

Correct answer by
Employee
  1. ID Graph Viewer
  2. Profile API
  3. ID Graph API
  4. Query Service on the Profile Snapshot Export xxx dataset

Avatar

Level 1

Thanks for the help, much appreciated.


I ended up creating a data set via the API and making a job that exported all the custom identities used on the profiles. 

Not entirely sure what other options there are to XDM Individual Profile Union Schema but since this is a system schema I assume it is the only schema that should be used in a case like this.

 

For others looking to see how it is done go to: 
https://experienceleague.adobe.com/docs/experience-platform/profile/api/export-jobs.html?lang=en

 

Kind regards

Robert

Avatar

Employee

@Robsayz If you want all the identities exported on a daily basis to a dataset, use the Profile Snapshot Export xxx system dataset.

Avatar

Level 4

Profile API will help you get this information, All of your identities (as an array) part of profile will be available including multiple CRM id. 

Avatar

Level 1

Hi Anil,

 

Thanks for the answer, do you know if this can be done across all profiles or is it per profile I would have to do this? 

I have just looked through the Profile API documentation and I can see I can access entities or even list of entities through the API but I am looking to see across ALL entities with more than one identifier value on a specific identity.

Maybe creating a target dataset and creating an export job would be the solution like @Danny-Miller  writes?

Kind regards
Robert