is profileid in profile lookup page is queryable | Community
Skip to main content
itsMeTechy
itsMeTechy
Level 4
July 22, 2025
Solved

is profileid in profile lookup page is queryable

  • July 22, 2025
  • 2 replies
  • 448 views

 

is the profileid which is available in profile lookup page, is that available to use in query service as well in any attribute from snapshot table or any other system table?

 

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 AnkitJasani29

Hi @itsmetechy ,

Yes - the same GUID you see as Profile ID in the Profile Lookup UI is exposed in Query Service, but only in the hidden system‐metadata column. To surface it, prepend your session with: 

SET drop_system_columns = false;

and then you can select it as:

SELECT _acp_system_metadata.recordId AS profile_id, ... FROM profile_attribute_<yourSchemaUUID>;

See Access dataset batch metadata in the Adobe Experience Platform Query Service here.

Thanks,

Ankit

2 replies

AnkitJasani29
AnkitJasani29Accepted solution
Level 6
July 22, 2025

Hi @itsmetechy ,

Yes - the same GUID you see as Profile ID in the Profile Lookup UI is exposed in Query Service, but only in the hidden system‐metadata column. To surface it, prepend your session with: 

SET drop_system_columns = false;

and then you can select it as:

SELECT _acp_system_metadata.recordId AS profile_id, ... FROM profile_attribute_<yourSchemaUUID>;

See Access dataset batch metadata in the Adobe Experience Platform Query Service here.

Thanks,

Ankit

    itsMeTechy
    itsMeTechyAuthor
    Level 4
    July 22, 2025

    Hi @ankitjasani29 

     

    Thanks for the information. 

     

    id what i see in _acp_system_metadata is not the same as visible in the profile lookup page. 

    Tof_Jossic
    Adobe Employee
    Tof_JossicAdobe Employee
    Adobe Employee
    August 8, 2025

    @itsmetechy not sure I fully understand what you want to achieve but in case that helps a little, the only way I found to use the profileID (XID) so far is through something like:

    GET https://platform.adobe.io/data/core/identity/cluster/members?xid=[value]

     

    .. which would return all profileIDs stitched together for that initial profile:

     

    "clusters": [
    {
    "xid": "G6j9GQFBY5xxxx",
    "members": [
    "G6j9GQFBY5Jsxxx",
    "G6j9GQFBY5Jtxxx",
    "G6DNKQFZxxxglEkzjBEfiD0gKxxx",
    "G6DNKQFZxxxrxglEkzjBEfxxxxx"
    ]
    }
    ],
    "algo_type": "STITCH_ALL"
      Terms & ConditionsAccessibility statement

      Loading footer...