is profileid in profile lookup page is queryable

[itsMeTechy]

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?

[AnkitJasani29 · Accepted solution]

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]

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]

@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"