Skip to main content

members

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

Overview

Namemembers
TypeResource
Idcloudflare.cloudforce_one.members

Fields

The following fields are returned by SELECT queries:

Returns the group members.

NameDatatypeDescription
accountIdstring
accountTagstring
createdAtstring (date-time)
updatedAtstring (date-time)
uuidstring

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectaccount_id, group_idList group members
post_group_member_createinsertaccount_id, group_idCreate a group member
delete_group_member_deletedeleteaccount_id, group_id, member_idDelete a group member

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.
group_idstringThe Access group ID.
member_idstringThe account member ID.

SELECT examples

List group members

SELECT
accountId,
accountTag,
createdAt,
updatedAt,
uuid
FROM cloudflare.cloudforce_one.members
WHERE account_id = '{{ account_id }}' -- required
AND group_id = '{{ group_id }}' -- required
;

INSERT examples

Create a group member

INSERT INTO cloudflare.cloudforce_one.members (
accountId,
accountTag,
account_id,
group_id
)
SELECT
'{{ accountId }}',
'{{ accountTag }}',
'{{ account_id }}',
'{{ group_id }}'
RETURNING
accountId,
accountTag,
createdAt,
updatedAt,
uuid
;

DELETE examples

Delete a group member

DELETE FROM cloudflare.cloudforce_one.members
WHERE account_id = '{{ account_id }}' --required
AND group_id = '{{ group_id }}' --required
AND member_id = '{{ member_id }}' --required
;