Skip to main content

classifications

Creates, updates, deletes, gets or lists a classifications resource.

Overview​

Nameclassifications
TypeResource
Idokta.users.classifications

Fields​

The following fields are returned by SELECT queries:

NameDatatypeDescription
lastUpdatedstring (date-time)The timestamp when the user classification was last updated
typestringThe type of user classification (LITE, STANDARD)

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_user_classificationselectuserId, subdomainRetrieves a user's classification
replace_user_classificationreplaceuserId, subdomainReplaces the user's classification

Parameters​

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
subdomainstring(default: my-org)
userIdstringID of an existing Okta user

SELECT examples​

Retrieves a user's classification

SELECT
lastUpdated,
type
FROM okta.users.classifications
WHERE userId = '{{ userId }}' -- required
AND subdomain = '{{ subdomain }}' -- required
;

REPLACE examples​

Replaces the user's classification

REPLACE okta.users.classifications
SET
type = '{{ type }}'
WHERE
userId = '{{ userId }}' --required
AND subdomain = '{{ subdomain }}' --required
RETURNING
lastUpdated,
type;