project_api_keys

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

Overview

Name	project_api_keys
Type	Resource
Id	openai.projects.project_api_keys

Fields

Name	Datatype	Description
id	string	The identifier, which can be referenced in API endpoints
name	string	The name of the API key
created_at	integer	The Unix timestamp (in seconds) of when the API key was created
object	string	The object type, which is always organization.project.api_key
owner	object
redacted_value	string	The redacted value of the API key

Methods

Name	Accessible by	Required Params	Description
list_project_api_keys	SELECT	project_id
retrieve_project_api_key	SELECT	key_id, project_id
delete_project_api_key	DELETE	key_id, project_id

SELECT examples

SELECT
id,
name,
created_at,
object,
owner,
redacted_value
FROM openai.projects.project_api_keys
WHERE project_id = '{{ project_id }}';

DELETE example

Deletes the specified project_api_keys resource.

/*+ delete */
DELETE FROM openai.projects.project_api_keys
WHERE key_id = '{{ key_id }}'
AND project_id = '{{ project_id }}';