Using the API to retrive the value of a custom user field from a user

I think a Data Explorer query would be the best approach. Have a look at the second query in this post: Data explorer plugin - filter users by sign-up 'custom fields'. It should give you the data you are looking for.

2 Likes