Skip to main content
Robsayz
Level 2
Sep 14, 2022 12:10 PM UTC
Solved

Query and count specific identities for all profiles

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.
Danny-Miller
Danny-MillerAccepted solution
Adobe Employee
Sep 14, 2022 4:12 PM UTC
  1. ID Graph Viewer
  2. Profile API
  3. ID Graph API
  4. Query Service on the Profile Snapshot Export xxx dataset
View in thread

5 replies

Danny-Miller
Adobe Employee
Danny-MillerAdobe EmployeeAccepted solution
Adobe Employee
Sep 14, 2022 4:12 PM UTC
  1. ID Graph Viewer
  2. Profile API
  3. ID Graph API
  4. Query Service on the Profile Snapshot Export xxx dataset
Translate
    RobsayzAuthor
    Level 2
    Sep 15, 2022 11:53 AM UTC

    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

    Translate
    Danny-Miller
    Adobe Employee
    Danny-MillerAdobe Employee
    Adobe Employee
    Sep 15, 2022 2:46 PM UTC

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

    Translate
      Anil_Umachigi
      Adobe Employee
      Anil_UmachigiAdobe Employee
      Adobe Employee
      Sep 14, 2022 8:13 PM UTC

      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. 

      Translate
      RobsayzAuthor
      Level 2
      Sep 15, 2022 7:41 AM UTC

      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

      Translate
      Terms & ConditionsAccessibility statement

      Loading footer...