Query and count specific identities for all profiles | Community
Skip to main content
R
Robsayz
September 14, 2022
Solved

Query and count specific identities for all profiles

  • September 14, 2022
  • 2 replies
  • 1898 views

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

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Danny-Miller
  1. ID Graph Viewer
  2. Profile API
  3. ID Graph API
  4. Query Service on the Profile Snapshot Export xxx dataset

2 replies

Danny-Miller
Adobe Employee
Danny-MillerAdobe EmployeeAccepted solution
Adobe Employee
September 14, 2022
  1. ID Graph Viewer
  2. Profile API
  3. ID Graph API
  4. Query Service on the Profile Snapshot Export xxx dataset
    R
    RobsayzAuthor
    September 15, 2022

    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

    Danny-Miller
    Adobe Employee
    Danny-MillerAdobe Employee
    Adobe Employee
    September 15, 2022

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

      Anil_Umachigi
      Adobe Employee
      Anil_UmachigiAdobe Employee
      Adobe Employee
      September 14, 2022

      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. 

      R
      RobsayzAuthor
      September 15, 2022

      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

      Terms & ConditionsAccessibility statement

      Loading footer...