ODBC Driver for Okta

Build 24.0.9060

TrustedOrigins

External Urls in the list of trusted origins.

View Specific Information

Required Scopes

To query this view, Scope must include okta.trustedOrigins.read.

Select

The driver uses the Okta API to process WHERE clause conditions built with the following columns and operators.
  • Id supports the '=' operator
  • Name supports the '=' operator
  • Origin supports the '=' operator
  • Status supports the '=' operator
  • Type supports the '=' operator

All other filters are processed client-side within the driver.

For example, the following queries are processed server-side:

SELECT * FROM TrustedOrigins WHERE Id = 'tos10hu7rkbtrFt1M0g4'

SELECT * FROM TrustedOrigins WHERE Status = 'ACTIVE'

Columns

Name Type Description
Id [KEY] String Id of the trusted origins
Name String Name of the trusted origin
Origin String Url for the trusted origin
Status String Status of the trusted origin
Created Datetime When the item was created
CreatedBy String Who created the item
LastUpdated Datetime When the item was last updated
LastUpdatedBy String Who last updated the item
Scopes String Scope types for which the trusted origin is used

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements, and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Type String Type of scopes to filter

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060