Skip to main content
New Member
Aug 17, 2022 6:33 PM UTC
Solved

IdentityMap

my identyMap contains something like this - [ECID -> "{(00217892182081596154117317023817799037,f)}"]

what i want to see is 00217892182081596154117317023817799037 , could someone help how to extract

Danny-Miller
Danny-MillerAccepted solution
Adobe Employee
Aug 17, 2022 7:49 PM UTC

@askapr2014 If you are referring to how should your SQL look in Query Service, this is how you get the first element in the array:

SELECT identitymap['ECID '][0].ID FROM dataset

7 replies

Anil_Umachigi
Adobe Employee
Adobe Employee
Aug 17, 2022 7:44 PM UTC

Where are you seeing this? i.e where do you want to extract it from? Could you elaborate on usecase. 

Is it the dataset which contains web events? 

 

Translate
Danny-Miller
Adobe Employee
Danny-MillerAdobe EmployeeAccepted solution
Adobe Employee
Aug 17, 2022 7:49 PM UTC

@askapr2014 If you are referring to how should your SQL look in Query Service, this is how you get the first element in the array:

SELECT identitymap['ECID '][0].ID FROM dataset

Translate
May 28, 2024 3:22 PM UTC

Thank you for your reply, do you know how to fetch identitymap emails?

 

Translate
Level 4
Aug 19, 2022 1:29 AM UTC

@askapr2014  seems your query has * , thus result is ("values inside by ,"). 

Put Were condition and you should be fine.

Translate