Skip to main content

user_groups

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

Overview

Nameuser_groups
TypeResource
Idcloudflare.iam.user_groups

Fields

The following fields are returned by SELECT queries:

User Group Details response

NameDatatypeDescription
idstringUser Group identifier tag. (title: User Group Identifier, example: 023e105f4ecef8ad9ca31a8372d0c353)
namestringName of the user group. (example: My New User Group)
created_onstring (date-time)Timestamp for the creation of the user group (example: 2024-03-01T12:21:02.0000Z)
modified_onstring (date-time)Last time the user group was modified. (example: 2024-03-01T12:21:02.0000Z)
policiesarrayPolicies attached to the User group (title: User Group Policies)

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectaccount_id, user_group_idGet information about a specific user group in an account.
listselectaccount_idid, name, fuzzyName, page, per_page, directionList all the user groups for an account.
createinsertaccount_id, nameCreate a new user group under the specified account.
updatereplaceaccount_id, user_group_idModify an existing user group.
deletedeleteaccount_id, user_group_idRemove a user group from an account.

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.

NameDatatypeDescription
account_idstringThe Cloudflare account ID.
user_group_idstring
directionstring
fuzzyNamestring
idstringID of the user group to be fetched.
namestring
pagenumber
per_pagenumber

SELECT examples

Get information about a specific user group in an account.

SELECT
id,
name,
created_on,
modified_on,
policies
FROM cloudflare.iam.user_groups
WHERE account_id = '{{ account_id }}' -- required
AND user_group_id = '{{ user_group_id }}' -- required
;

INSERT examples

Create a new user group under the specified account.

INSERT INTO cloudflare.iam.user_groups (
name,
policies,
account_id
)
SELECT
'{{ name }}' /* required */,
'{{ policies }}',
'{{ account_id }}'
RETURNING
errors,
messages,
result,
success
;

REPLACE examples

Modify an existing user group.

REPLACE cloudflare.iam.user_groups
SET
name = '{{ name }}',
policies = '{{ policies }}'
WHERE
account_id = '{{ account_id }}' --required
AND user_group_id = '{{ user_group_id }}' --required
RETURNING
errors,
messages,
result,
success;

DELETE examples

Remove a user group from an account.

DELETE FROM cloudflare.iam.user_groups
WHERE account_id = '{{ account_id }}' --required
AND user_group_id = '{{ user_group_id }}' --required
;