At this time, I’m afraid it is not possible to query custom User fields via the API. In this specific case, it seems like you could query the “name” field instead, but I definitely understand you might have wanted to query a custom field that stores information not available in other user fields.
I’ve passed this as an improvement suggestion to our product team That said, I can’t confirm when or whether this would be part of our API at this time.
any updates here? This functionality would make my life a lot easier since I work on a project that is heavily based on user details/extended fields. The standard fields force me to get hacky by misusing fields that are intended to be used otherwise. Using a field this way works somehow but it is a mess for any user.
I’m afraid this is still not an option that our API provides just yet, although I can clearly see how this would benefit you in your use case. At this time, I can’t share any kind of ETA, but I’ve made sure ou team is aware of your needs here
Thank you for checking in, I appreciate your help in making our API more and more robust for different purposes.
I think if I understand the issue correctly, there is a way to extract a first name from a field using the formula column. You could use the following formula in a formula column and then extract that information using your API.