project_users

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

Overview

Name	project_users
Type	Resource
Id	openai.projects.project_users

Fields

Name	Datatype	Description
id	string	The identifier, which can be referenced in API endpoints
name	string	The name of the user
added_at	integer	The Unix timestamp (in seconds) of when the project was added.
email	string	The email address of the user
object	string	The object type, which is always organization.project.user
role	string	owner or member

Methods

Name	Accessible by	Required Params	Description
list_project_users	SELECT	project_id
retrieve_project_user	SELECT	project_id, user_id
create_project_user	INSERT	project_id, data__role, data__user_id
delete_project_user	DELETE	project_id, user_id
modify_project_user	UPDATE	project_id, user_id, data__role

SELECT examples

SELECT
id,
name,
added_at,
email,
object,
role
FROM openai.projects.project_users
WHERE project_id = '{{ project_id }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO openai.projects.project_users (
data__user_id,
data__role,
project_id
)
SELECT 
'{{ user_id }}',
'{{ role }}',
'{{ project_id }}'
;

Manifest

- name: project_users
  props:
    - name: project_id
      value: string
    - name: data__role
      value: string
    - name: data__user_id
      value: string
    - name: user_id
      value: string
    - name: role
      value: string

UPDATE example

Updates a project_users resource.

/*+ update */
UPDATE openai.projects.project_users
SET 
role = '{{ role }}'
WHERE 
project_id = '{{ project_id }}'
AND user_id = '{{ user_id }}'
AND data__role = '{{ data__role }}';

DELETE example

Deletes the specified project_users resource.

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