projects

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

Overview

Name	projects
Type	Resource
Id	openai.projects.projects

Fields

Name	Datatype	Description
id	string	The identifier, which can be referenced in API endpoints
name	string	The name of the project. This appears in reporting.
archived_at	integer	The Unix timestamp (in seconds) of when the project was archived or null.
created_at	integer	The Unix timestamp (in seconds) of when the project was created.
object	string	The object type, which is always organization.project
status	string	active or archived

Methods

Name	Accessible by	Required Params	Description
list_projects	SELECT
retrieve_project	SELECT	project_id
create_project	INSERT	data__name
modify_project	UPDATE	project_id, data__name
archive_project	EXEC	project_id

SELECT examples

SELECT
id,
name,
archived_at,
created_at,
object,
status
FROM openai.projects.projects
;

INSERT example

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

All Properties

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

Manifest

- name: projects
  props:
    - name: data__name
      value: string
    - name: name
      value: string

UPDATE example

Updates a projects resource.

/*+ update */
UPDATE openai.projects.projects
SET 
name = '{{ name }}'
WHERE 
project_id = '{{ project_id }}'
AND data__name = '{{ data__name }}';