project_certificates

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

Overview

Name	project_certificates
Type	Resource
Id	openai_admin.certificates.project_certificates

Fields

The following fields are returned by SELECT queries:

list

Certificates listed successfully.

Name	Datatype	Description
id	string	The identifier, which can be referenced in API endpoints
name	string	The name of the certificate.
active	boolean	Whether the certificate is currently active at the project level.
certificate_details	object
created_at	integer (unixtime)	The Unix timestamp (in seconds) of when the certificate was uploaded.
object	string	The object type, which is always organization.project.certificate. (organization.project.certificate)

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	project_id	limit, after, order
activate	exec	project_id, certificate_ids
deactivate	exec	project_id, certificate_ids

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
project_id	string	The ID of the project.
after	string	A cursor for use in pagination. after is an object ID that defines your place in the list. For instance, if you make a list request and receive 100 objects, ending with obj_foo, your subsequent call can include after=obj_foo in order to fetch the next page of the list.
limit	integer	A limit on the number of objects to be returned. Limit can range between 1 and 100, and the default is 20.
order	string	Sort order by the created_at timestamp of the objects. asc for ascending order and desc for descending order.

SELECT examples

list

Certificates listed successfully.

SELECT
id,
name,
active,
certificate_details,
created_at,
object
FROM openai_admin.certificates.project_certificates
WHERE project_id = '{{ project_id }}' -- required
AND limit = '{{ limit }}'
AND after = '{{ after }}'
AND order = '{{ order }}'
;

Lifecycle Methods

activate

Certificates activated successfully.

EXEC openai_admin.certificates.project_certificates.activate 
@project_id='{{ project_id }}' --required 
@@json=
'{
"certificate_ids": "{{ certificate_ids }}"
}'
;

deactivate

Certificates deactivated successfully.

EXEC openai_admin.certificates.project_certificates.deactivate 
@project_id='{{ project_id }}' --required 
@@json=
'{
"certificate_ids": "{{ certificate_ids }}"
}'
;