Windsor brings all your Okta data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Okta Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| custom_roles___links | OBJECT | custom_roles._links | custom_roles._links | custom_roles |
| custom_roles__created | TEXT | custom_roles.created | custom_roles.created | custom_roles |
| custom_roles__description | TEXT | custom_roles.description | custom_roles.description | custom_roles |
| custom_roles__id | TEXT | custom_roles.id | custom_roles.id | custom_roles |
| custom_roles__label | TEXT | custom_roles.label | custom_roles.label | custom_roles |
| custom_roles__lastupdated | TEXT | custom_roles.lastUpdated | custom_roles.lastUpdated | custom_roles |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| group_members___links | OBJECT | group_members._links | group_members._links | group_members |
| group_members__activated | TEXT | group_members.activated | group_members.activated | group_members |
| group_members__created | TEXT | group_members.created | group_members.created | group_members |
| group_members__credentials | OBJECT | group_members.credentials | group_members.credentials | group_members |
| group_members__groupid | TEXT | group_members.groupId | group_members.groupId | group_members |
| group_members__id | TEXT | group_members.id | group_members.id | group_members |
| group_members__lastlogin | TEXT | group_members.lastLogin | group_members.lastLogin | group_members |
| group_members__lastupdated | TEXT | group_members.lastUpdated | group_members.lastUpdated | group_members |
| group_members__passwordchanged | TEXT | group_members.passwordChanged | group_members.passwordChanged | group_members |
| group_members__profile | OBJECT | group_members.profile | group_members.profile | group_members |
| group_members__status | TEXT | group_members.status | group_members.status | group_members |
| group_members__statuschanged | TEXT | group_members.statusChanged | group_members.statusChanged | group_members |
| group_members__type | OBJECT | group_members.type | group_members.type | group_members |
| group_role_assignments___links | OBJECT | group_role_assignments._links | group_role_assignments._links | group_role_assignments |
| group_role_assignments__assignmenttype | TEXT | group_role_assignments.assignmentType | group_role_assignments.assignmentType | group_role_assignments |
| group_role_assignments__created | TEXT | group_role_assignments.created | group_role_assignments.created | group_role_assignments |
| group_role_assignments__groupid | TEXT | group_role_assignments.groupId | group_role_assignments.groupId | group_role_assignments |
| group_role_assignments__id | TEXT | group_role_assignments.id | group_role_assignments.id | group_role_assignments |
| group_role_assignments__label | TEXT | group_role_assignments.label | group_role_assignments.label | group_role_assignments |
| group_role_assignments__lastupdated | TEXT | group_role_assignments.lastUpdated | group_role_assignments.lastUpdated | group_role_assignments |
| group_role_assignments__resource-set | TEXT | group_role_assignments.resource-set | group_role_assignments.resource-set | group_role_assignments |
| group_role_assignments__role | TEXT | group_role_assignments.role | group_role_assignments.role | group_role_assignments |
| group_role_assignments__status | TEXT | group_role_assignments.status | group_role_assignments.status | group_role_assignments |
| group_role_assignments__type | TEXT | group_role_assignments.type | group_role_assignments.type | group_role_assignments |
| groups___links | OBJECT | groups._links | groups._links | groups |
| groups__created | TEXT | groups.created | groups.created | groups |
| groups__id | TEXT | groups.id | groups.id | groups |
| groups__lastmembershipupdated | TEXT | groups.lastMembershipUpdated | groups.lastMembershipUpdated | groups |
| groups__lastupdated | TEXT | groups.lastUpdated | groups.lastUpdated | groups |
| groups__objectclass | OBJECT | groups.objectClass | groups.objectClass | groups |
| groups__profile | OBJECT | groups.profile | groups.profile | groups |
| groups__type | TEXT | groups.type | groups.type | groups |
| logs__actor | OBJECT | logs.actor | logs.actor | logs |
| logs__authenticationcontext | OBJECT | logs.authenticationContext | logs.authenticationContext | logs |
| logs__client | OBJECT | logs.client | logs.client | logs |
| logs__debugcontext | OBJECT | logs.debugContext | logs.debugContext | logs |
| logs__device | TEXT | logs.device | logs.device | logs |
| logs__displaymessage | TEXT | logs.displayMessage | logs.displayMessage | logs |
| logs__eventtype | TEXT | logs.eventType | logs.eventType | logs |
| logs__legacyeventtype | TEXT | logs.legacyEventType | logs.legacyEventType | logs |
| logs__outcome | OBJECT | logs.outcome | logs.outcome | logs |
| logs__published | TEXT | logs.published | logs.published | logs |
| logs__request | OBJECT | logs.request | logs.request | logs |
| logs__securitycontext | OBJECT | logs.securityContext | logs.securityContext | logs |
| logs__severity | TEXT | logs.severity | logs.severity | logs |
| logs__target | OBJECT | logs.target | logs.target | logs |
| logs__transaction | OBJECT | logs.transaction | logs.transaction | logs |
| logs__uuid | TEXT | logs.uuid | logs.uuid | logs |
| logs__version | TEXT | logs.version | logs.version | logs |
| permissions___links | OBJECT | permissions._links | permissions._links | permissions |
| permissions__conditions | OBJECT | permissions.conditions | permissions.conditions | permissions |
| permissions__created | TEXT | permissions.created | permissions.created | permissions |
| permissions__label | TEXT | permissions.label | permissions.label | permissions |
| permissions__lastupdated | TEXT | permissions.lastUpdated | permissions.lastUpdated | permissions |
| resource_sets___links | OBJECT | resource_sets._links | resource_sets._links | resource_sets |
| resource_sets__created | TEXT | resource_sets.created | resource_sets.created | resource_sets |
| resource_sets__description | TEXT | resource_sets.description | resource_sets.description | resource_sets |
| resource_sets__id | TEXT | resource_sets.id | resource_sets.id | resource_sets |
| resource_sets__label | TEXT | resource_sets.label | resource_sets.label | resource_sets |
| resource_sets__lastupdated | TEXT | resource_sets.lastUpdated | resource_sets.lastUpdated | resource_sets |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| user_role_assignments___links | OBJECT | user_role_assignments._links | user_role_assignments._links | user_role_assignments |
| user_role_assignments__assignmenttype | TEXT | user_role_assignments.assignmentType | user_role_assignments.assignmentType | user_role_assignments |
| user_role_assignments__created | TEXT | user_role_assignments.created | user_role_assignments.created | user_role_assignments |
| user_role_assignments__id | TEXT | user_role_assignments.id | user_role_assignments.id | user_role_assignments |
| user_role_assignments__label | TEXT | user_role_assignments.label | user_role_assignments.label | user_role_assignments |
| user_role_assignments__lastupdated | TEXT | user_role_assignments.lastUpdated | user_role_assignments.lastUpdated | user_role_assignments |
| user_role_assignments__resource-set | TEXT | user_role_assignments.resource-set | user_role_assignments.resource-set | user_role_assignments |
| user_role_assignments__role | TEXT | user_role_assignments.role | user_role_assignments.role | user_role_assignments |
| user_role_assignments__status | TEXT | user_role_assignments.status | user_role_assignments.status | user_role_assignments |
| user_role_assignments__type | TEXT | user_role_assignments.type | user_role_assignments.type | user_role_assignments |
| user_role_assignments__userid | TEXT | user_role_assignments.userId | user_role_assignments.userId | user_role_assignments |
| users___links | OBJECT | users._links | users._links | users |
| users__activated | TEXT | users.activated | users.activated | users |
| users__created | TEXT | users.created | users.created | users |
| users__credentials | OBJECT | users.credentials | users.credentials | users |
| users__id | TEXT | users.id | users.id | users |
| users__lastlogin | TEXT | users.lastLogin | users.lastLogin | users |
| users__lastupdated | TEXT | users.lastUpdated | users.lastUpdated | users |
| users__passwordchanged | TEXT | users.passwordChanged | users.passwordChanged | users |
| users__profile | OBJECT | users.profile | users.profile | users |
| users__status | TEXT | users.status | users.status | users |
| users__statuschanged | TEXT | users.statusChanged | users.statusChanged | users |
| users__type | OBJECT | users.type | users.type | users |