Skip to main content

members

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

Overview

Namemembers
TypeResource
Idcloudflare.accounts.members

Fields

The following fields are returned by SELECT queries:

Member Details response

NameDatatypeDescription
idstringMembership identifier tag. (example: 4536bcfad5faccb111b47003c79917fa)
emailstringThe contact email address of the user. (example: user@example.com)
policiesarrayAccess policy for the membership
rolesarrayRoles assigned to this Member.
statusstringA member's status in the account. (accepted, pending) (example: accepted)
userobjectDetails of the user associated to the membership.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectmember_id, account_idGet information about a specific member of an account.
listselectaccount_idorder, status, page, per_page, directionList all members of an account.
createinsertaccount_id, emailAdd a user to the list of members for this account.
updatereplacemember_id, account_id, policiesModify an account member.
deletedeletemember_id, account_idRemove a member 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.
member_idstringThe account member ID.
directionstring
orderstring
pagenumber
per_pagenumber
statusstring

SELECT examples

Get information about a specific member of an account.

SELECT
id,
email,
policies,
roles,
status,
user
FROM cloudflare.accounts.members
WHERE member_id = '{{ member_id }}' -- required
AND account_id = '{{ account_id }}' -- required
;

INSERT examples

Add a user to the list of members for this account.

INSERT INTO cloudflare.accounts.members (
email,
roles,
status,
policies,
account_id
)
SELECT
'{{ email }}' /* required */,
'{{ roles }}',
'{{ status }}',
'{{ policies }}',
'{{ account_id }}'
RETURNING
errors,
messages,
result,
success
;

REPLACE examples

Modify an account member.

REPLACE cloudflare.accounts.members
SET
roles = '{{ roles }}',
policies = '{{ policies }}'
WHERE
member_id = '{{ member_id }}' --required
AND account_id = '{{ account_id }}' --required
AND policies = '{{ policies }}' --required
RETURNING
errors,
messages,
result,
success;

DELETE examples

Remove a member from an account.

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