turbot/oci

steampipe plugin install ocisteampipe plugin install oci
On This Page
Get Involved

Table: oci_apigateway_api

The API Gateway service enables you to publish APIs with private endpoints that are accessible from within your network, and which you can expose with public IP addresses if you want them to accept internet traffic.

Examples

Basic info

select
id,
display_name,
time_created,
lifecycle_state as state
from
oci_apigateway_api;

List active APIs

select
id,
display_name,
time_created,
lifecycle_state as state
from
oci_apigateway_api
where
lifecycle_state = 'ACTIVE';

List APIs older than 90 days

select
id,
lifecycle_state,
time_created
from
oci_apigateway_api
where
time_created <= (current_date - interval '90' day)
order by
time_created;

.inspect oci_apigateway_api

OCI Apigateway Api

NameTypeDescription
compartment_idtextThe OCID of the compartment in Tenant in which the resource is located.
defined_tagsjsonbDefined tags for resource. Defined tags are set up in your tenancy by an administrator. Only users granted permission to work with the defined tags can apply them to resources.
display_nametextA user-friendly name. Does not have to be unique, and it's changeable.
freeform_tagsjsonbFree-form tags for resource. This tags can be applied by any user with permissions on the resource.
idtextThe OCID of the resource.
lifecycle_detailstextA message describing the current lifecycleState.
lifecycle_statetextThe current state of the API.
specification_typetextType of API Specification file.
tagsjsonbA map of tags for the resource.
tenant_idtextThe OCID of the Tenant in which the resource is located.
time_createdtimestamp without time zoneThe time this resource was created.
time_updatedtimestamp without time zoneThe time this resource was last updated.
titletextTitle of the resource.
validation_resultsjsonbStatus of each feature available from the API.