Agile Central - Notifications: How to export a list of all project users along with their email notifications status

Document ID : KB000111833
Last Modified Date : 21/08/2018
Show Technical Document Details
How can we find the Email Notification selection of all users in our project?
The Email Notification is a preference of each user. It is part of the User endpoint, in a field named: EmailNotificationsEnabled
However, this field is not part of any of the Agile Central screens and can not be added to apps such as Custom List. The reason is that this field is not queriable:

User-added image

However, we can use the Excel add-in to get this information. In the Excel add-in we shall use the ProjectPermission endpoint , filter it by the project we need and manually include the 'User.UserProfile.EmailNotificationEnabled' column. Below is a screenshot showing how to create the query along with the spreadsheet.

User-added image
Additional Information:
More on how to set up email notifications:

More articles on the Excel add-in, see here

More on how query your projects users by permission, see here