Skip to main content

envgroups

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

Overview

Nameenvgroups
TypeResource
Idgoogle.apigee.envgroups

Fields

NameDatatypeDescription
namestringID of the environment group.
createdAtstringOutput only. The time at which the environment group was created as milliseconds since epoch.
hostnamesarrayRequired. Host names for this environment group.
lastModifiedAtstringOutput only. The time at which the environment group was last updated as milliseconds since epoch.
statestringOutput only. State of the environment group. Values other than ACTIVE means the resource is not ready to use.

Methods

NameAccessible byRequired ParamsDescription
organizations_envgroups_getSELECTenvgroupsId, organizationsIdGets an environment group.
organizations_envgroups_listSELECTorganizationsIdLists all environment groups.
organizations_envgroups_createINSERTorganizationsIdCreates a new environment group.
organizations_envgroups_deleteDELETEenvgroupsId, organizationsIdDeletes an environment group.
organizations_envgroups_patchUPDATEenvgroupsId, organizationsIdUpdates an environment group.

SELECT examples

Lists all environment groups.

SELECT
name,
createdAt,
hostnames,
lastModifiedAt,
state
FROM google.apigee.envgroups
WHERE organizationsId = '{{ organizationsId }}';

INSERT example

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

/*+ create */
INSERT INTO google.apigee.envgroups (
organizationsId,
name,
hostnames
)
SELECT
'{{ organizationsId }}',
'{{ name }}',
'{{ hostnames }}'
;

UPDATE example

Updates a envgroups resource.

/*+ update */
UPDATE google.apigee.envgroups
SET
name = '{{ name }}',
hostnames = '{{ hostnames }}'
WHERE
envgroupsId = '{{ envgroupsId }}'
AND organizationsId = '{{ organizationsId }}';

DELETE example

Deletes the specified envgroups resource.

/*+ delete */
DELETE FROM google.apigee.envgroups
WHERE envgroupsId = '{{ envgroupsId }}'
AND organizationsId = '{{ organizationsId }}';