project_service_accounts

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

Overview

Name	project_service_accounts
Type	Resource
Id	openai.projects.project_service_accounts

Fields

Name	Datatype	Description
id	string	The identifier, which can be referenced in API endpoints
name	string	The name of the service account
created_at	integer	The Unix timestamp (in seconds) of when the service account was created
object	string	The object type, which is always organization.project.service_account
role	string	owner or member

Methods

Name	Accessible by	Required Params	Description
list_project_service_accounts	SELECT	project_id
retrieve_project_service_account	SELECT	project_id, service_account_id
create_project_service_account	INSERT	project_id, data__name
delete_project_service_account	DELETE	project_id, service_account_id

SELECT examples

SELECT
id,
name,
created_at,
object,
role
FROM openai.projects.project_service_accounts
WHERE project_id = '{{ project_id }}';

INSERT example

Use the following StackQL query and manifest file to create a new project_service_accounts resource.

All Properties

/*+ create */
INSERT INTO openai.projects.project_service_accounts (
data__name,
project_id
)
SELECT 
'{{ name }}',
'{{ project_id }}'
;

Manifest

- name: project_service_accounts
  props:
    - name: project_id
      value: string
    - name: data__name
      value: string
    - name: name
      value: string

DELETE example

Deletes the specified project_service_accounts resource.

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