Apps in the organization.

Table Specific Information

Required Scopes

To query this table, Scope must include okta.apps.read. To edit this table, it must include okta.apps.manage.

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
• Status supports the '=' operator

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

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

SELECT * FROM Apps WHERE Id = '0oakva05cbY4t9oGG5d7'

SELECT * FROM Apps WHERE Name = 'okta_oin_submission_tester_app'

Insert

At minimum the Label and SignOnMode are required to insert into this table. Note that depending on the SignOnMode, additional values may need to be set.

A sample Insert is given below.

INSERT INTO Apps (Label, SignOnMode, AutoSubmitToolbar, Settings) VALUES ('InsertedApp1', 'AUTO_LOGIN', false, '{"signOn":{"redirectUrl":"https://www.example.com","loginUrl":"https://www.example.com"}}')

Update

The SignOnMode cannot be updated. Note that depending on the SignOnMode, fields such as Settings must contain additional values.

Sample Updates are given below.

UPDATE Apps SET Label = 'OAuthApp' WHERE Id = '0oakva05cbY4t9oGG5d7'

UPDATE Apps SET Settings = '{"signOn":{"redirectUrl":"https://www.cdata.com","loginUrl":"https://www.cdata.com"}}' where Id = '0oakva05cbY4t9oGG5d7'

Delete

Only apps that have been deactivated can be deleted.

A sample Delete is given below.

DELETE FROM Apps WHERE Id = '0oakva05cbY4t9oGG5d7'

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	True	Id of the app
Label	String	False	Display label for the app
Name	String	True	Display name for the app
ErrorRedirectUrl	String	False	Custom error page URL for the app
LoginRedirectUrl	String	False	Custom login page URL for the app
SelfService	Boolean	False	Whether the app can be self-assignable by users
Features	String	True	Enabled app features
Created	Datetime	True	When the item was created
LastUpdated	Datetime	True	When the item was last updated
SignOnMode	String	False	Authentication mode for the app
Status	String	True	App instance status
AutoSubmitToolbar	Boolean	False	Whether to automatically sign in when user lands on the sign-in page
Credentials	String	False	Credentials for the specified signOnMode
Settings	String	False	App instance setting