User email is not displayed in API for "people" type column

Hello,

I am using API to fetch the value of a column which has the user tagged in it. Is there a way to display the user’s email address along with the name?

Currently, I only get the value as name and not email address.

Cell(column=Customer, row=Tata, value=John Doe)

I know there is a way to achieve this by adding another column of type Calculate that calculates the Emails from the column Name but trying to see if there is a way to achieve this using API without having to create additional column.

Hello @Ammar_Anandwala ,

Have you tried using the valueFormat = rich query parameter? I believe that will return richer data information, including Person name + email.

1 Like