Windsor brings all your Auth0 data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL

Auth0 Field Reference

Fields

ID	Type	Name	Description	Report
clients__addons	OBJECT	clients.addons	clients.addons	clients
clients__allowed_clients	OBJECT	clients.allowed_clients	clients.allowed_clients	clients
clients__allowed_logout_urls	OBJECT	clients.allowed_logout_urls	clients.allowed_logout_urls	clients
clients__allowed_origins	OBJECT	clients.allowed_origins	clients.allowed_origins	clients
clients__app_type	TEXT	clients.app_type	clients.app_type	clients
clients__callback_url_template	BOOLEAN	clients.callback_url_template	clients.callback_url_template	clients
clients__callbacks	OBJECT	clients.callbacks	clients.callbacks	clients
clients__client_aliases	OBJECT	clients.client_aliases	clients.client_aliases	clients
clients__client_authentication_methods	OBJECT	clients.client_authentication_methods	clients.client_authentication_methods	clients
clients__client_id	TEXT	clients.client_id	clients.client_id	clients
clients__client_metadata	OBJECT	clients.client_metadata	clients.client_metadata	clients
clients__client_secret	TEXT	clients.client_secret	clients.client_secret	clients
clients__cross_origin_auth	BOOLEAN	clients.cross_origin_auth	clients.cross_origin_auth	clients
clients__cross_origin_authentication	BOOLEAN	clients.cross_origin_authentication	clients.cross_origin_authentication	clients
clients__cross_origin_loc	TEXT	clients.cross_origin_loc	clients.cross_origin_loc	clients
clients__custom_login_page	TEXT	clients.custom_login_page	clients.custom_login_page	clients
clients__custom_login_page_on	BOOLEAN	clients.custom_login_page_on	clients.custom_login_page_on	clients
clients__custom_login_page_preview	TEXT	clients.custom_login_page_preview	clients.custom_login_page_preview	clients
clients__description	TEXT	clients.description	clients.description	clients
clients__encryption_key	OBJECT	clients.encryption_key	clients.encryption_key	clients
clients__form_template	TEXT	clients.form_template	clients.form_template	clients
clients__global	BOOLEAN	clients.global	clients.global	clients
clients__grant_types	OBJECT	clients.grant_types	clients.grant_types	clients
clients__initiate_login_uri	TEXT	clients.initiate_login_uri	clients.initiate_login_uri	clients
clients__is_first_party	BOOLEAN	clients.is_first_party	clients.is_first_party	clients
clients__is_token_endpoint_ip_header_trusted	BOOLEAN	clients.is_token_endpoint_ip_header_trusted	clients.is_token_endpoint_ip_header_trusted	clients
clients__jwt_configuration	OBJECT	clients.jwt_configuration	clients.jwt_configuration	clients
clients__logo_uri	TEXT	clients.logo_uri	clients.logo_uri	clients
clients__mobile	OBJECT	clients.mobile	clients.mobile	clients
clients__name	TEXT	clients.name	clients.name	clients
clients__native_social_login	OBJECT	clients.native_social_login	clients.native_social_login	clients
clients__oidc_backchannel_logout	OBJECT	clients.oidc_backchannel_logout	clients.oidc_backchannel_logout	clients
clients__oidc_conformant	BOOLEAN	clients.oidc_conformant	clients.oidc_conformant	clients
clients__organization_require_behavior	TEXT	clients.organization_require_behavior	clients.organization_require_behavior	clients
clients__organization_usage	TEXT	clients.organization_usage	clients.organization_usage	clients
clients__owners	OBJECT	clients.owners	clients.owners	clients
clients__refresh_token	OBJECT	clients.refresh_token	clients.refresh_token	clients
clients__signing_keys	OBJECT	clients.signing_keys	clients.signing_keys	clients
clients__sso	BOOLEAN	clients.sso	clients.sso	clients
clients__sso_disabled	BOOLEAN	clients.sso_disabled	clients.sso_disabled	clients
clients__tenant	TEXT	clients.tenant	clients.tenant	clients
clients__token_endpoint_auth_method	TEXT	clients.token_endpoint_auth_method	clients.token_endpoint_auth_method	clients
clients__web_origins	OBJECT	clients.web_origins	clients.web_origins	clients
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
organization_member_roles__description	TEXT	organization_member_roles.description	organization_member_roles.description	organization_member_roles
organization_member_roles__id	TEXT	organization_member_roles.id	organization_member_roles.id	organization_member_roles
organization_member_roles__name	TEXT	organization_member_roles.name	organization_member_roles.name	organization_member_roles
organization_member_roles__org_id	TEXT	organization_member_roles.org_id	organization_member_roles.org_id	organization_member_roles
organization_member_roles__user_id	TEXT	organization_member_roles.user_id	organization_member_roles.user_id	organization_member_roles
organization_members__email	TEXT	organization_members.email	organization_members.email	organization_members
organization_members__name	TEXT	organization_members.name	organization_members.name	organization_members
organization_members__org_id	TEXT	organization_members.org_id	organization_members.org_id	organization_members
organization_members__picture	TEXT	organization_members.picture	organization_members.picture	organization_members
organization_members__user_id	TEXT	organization_members.user_id	organization_members.user_id	organization_members
organizations__branding	OBJECT	organizations.branding	organizations.branding	organizations
organizations__display_name	TEXT	organizations.display_name	organizations.display_name	organizations
organizations__id	TEXT	organizations.id	organizations.id	organizations
organizations__metadata	OBJECT	organizations.metadata	organizations.metadata	organizations
organizations__name	TEXT	organizations.name	organizations.name	organizations
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date
users___links	OBJECT	users._links	users._links	users
users__app_metadata	OBJECT	users.app_metadata	users.app_metadata	users
users__blocked	BOOLEAN	users.blocked	users.blocked	users
users__created_at	TEXT	users.created_at	users.created_at	users
users__email	TEXT	users.email	users.email	users
users__email_verified	BOOLEAN	users.email_verified	users.email_verified	users
users__family_name	TEXT	users.family_name	users.family_name	users
users__given_name	TEXT	users.given_name	users.given_name	users
users__identities	OBJECT	users.identities	users.identities	users
users__last_ip	TEXT	users.last_ip	users.last_ip	users
users__last_login	TEXT	users.last_login	users.last_login	users
users__logins_count	NUMERIC	users.logins_count	users.logins_count	users
users__multifactor	OBJECT	users.multifactor	users.multifactor	users
users__name	TEXT	users.name	users.name	users
users__nickname	TEXT	users.nickname	users.nickname	users
users__phone_number	TEXT	users.phone_number	users.phone_number	users
users__phone_verified	BOOLEAN	users.phone_verified	users.phone_verified	users
users__picture	TEXT	users.picture	users.picture	users
users__updated_at	TEXT	users.updated_at	users.updated_at	users
users__user_id	TEXT	users.user_id	users.user_id	users
users__user_metadata	OBJECT	users.user_metadata	users.user_metadata	users
users__username	TEXT	users.username	users.username	users