API service integration instances.

Table Specific Information

Required Scopes

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

Select

The driver uses the Okta API to process WHERE clause conditions built with the following columns and operators.

• Id supports the '=' operator

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

For example, the following query is processed server-side:

SELECT * FROM ApiServiceIntegrations WHERE Id = '0oa72lrepvp4WqEET1d9'

Insert

The Type and GrantedScopes are required to insert into this table. Note that Okta's API will only accept certain predefined types for the Type, such as 'acsenseapiservice' or 'anzennaapiservice', and each Type can only accept specific GrantedScopes.

A sample Insert is given below.

INSERT INTO ApiServiceIntegrations (Type, GrantedScopes) VALUES ('anzennaapiservice', '\"okta.groups.read\", \"okta.logs.read\", \"okta.users.read\"')

Update

Updates are not supported for this table.

Delete

A sample Delete is given below.

DELETE FROM ApiServiceIntegrations WHERE Id='0oambfz4fgyfcXJeC5d7'

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	True	Id of the api service
Type	String	False	The type of the API service integration. This is an underscore-concatenated, lowercased API service integration name.
Name	String	True	Full name of the API service integration listed in the Okta Integration Network (OIN) catalog.
CreatedAt	Datetime	True	When the item was created
CreatedBy	String	True	The user ID of the API Service Integration instance creator
ConfigGuideUrl	String	True	The URL to the API service integration configuration guide
GrantedScopes	String	False	The list of Okta management scopes granted to the API Service Integration instance