Hi,
Using the Klaviyo API, I would like to get the email of a user having a specific custom property with a specific ID.
My custom property is : Loyoly_Referral_Id
and the ID would be a variable.
Is it possible ? I don’t find it in the api documentation
Thanks a lot,
Laurent
Best answer by dartacus
There’s a curated list of properties which /profiles API endpoint allows you to filter by, so off the top of my head the only way I could think of doing this is to use a relatively unfiltered call to /profiles to get all your subscribers, paginate through and put them into a temporary table or similar, then go through that table looking for matches on your custom property.
You could speed this up by creating a segment with users who have the custom property set, and use segments/{id}/relationships/profiles/ to only fetch the profiles related to that segment.
It *might* be possible to use a POST to segments/ to dynamically create a segment which has that particular ID in the custom property, and then just fetch that, which should have only a single profile, maybe? Problem there is segments take a while to create, so there’ll be a delay.
Hopefully someone else has a quicker way!
G
There’s a curated list of properties which /profiles API endpoint allows you to filter by, so off the top of my head the only way I could think of doing this is to use a relatively unfiltered call to /profiles to get all your subscribers, paginate through and put them into a temporary table or similar, then go through that table looking for matches on your custom property.
You could speed this up by creating a segment with users who have the custom property set, and use segments/{id}/relationships/profiles/ to only fetch the profiles related to that segment.
It *might* be possible to use a POST to segments/ to dynamically create a segment which has that particular ID in the custom property, and then just fetch that, which should have only a single profile, maybe? Problem there is segments take a while to create, so there’ll be a delay.
Hopefully someone else has a quicker way!
G
Thanks for your help. I’ll try the solution. unfortunately, this custom property is set at the account creation, so basically all my users have one...
Would it be possible to use one of the “curated” property to duplicate the value of the ID I’m looking for, and them make my search within this curated property ?
I could not find the list of those properties in the API. I know for example that birthday is one of them, and that we don’t use it.
There’s also something called external_id and I don’t know what that is.
external_id is one of the three ‘identifiers’ for a profile along with ID and email, and appears to be something that you can control yourself and Klaviyo won’t mess with unless you ask it to, so yes that might work, but I’d check with a Klaviyo person before taking that as gospel.
It’s one of the filters listed in the Get Profiles docs here: https://developers.klaviyo.com/en/reference/get_profiles
G
Maybe
If i udnerstand well, i cannot look for a specific variable from a custom property in the API and retrieving the email of this specific user ? The solution that I’m thinking of would be to duplicate the infos of my custom property to one of your allowed properties ?
Can you help ?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
