Skip to main content

service_resource_accounts

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

Overview​

Nameservice_resource_accounts
TypeResource
Idovh.email_exchange.service_resource_accounts

Fields​

The following fields are returned by SELECT queries:

successful operation

NameDatatypeDescription
task_pending_idintegertask pending id (wire: taskPendingId)
display_namestringname of resource (wire: displayName)
add_organizer_to_subjectbooleanmeeting organizer's name is used as the subject of the meeting request (wire: addOrganizerToSubject)
allow_conflictbooleanresource can be scheduled by more than one person during the same time period (wire: allowConflict)
booking_windowintegermaximum number of days in advance that the resource can be reserved (wire: bookingWindow)
capacityintegernumber of the same equipment or capacity of a room
companystringCompany name
creation_datestring (date-time)Creation date (wire: creationDate)
delete_commentsbooleanremove any text in the message body of incoming meeting requests on resourceAccount (wire: deleteComments)
delete_subjectbooleanremove email subject of incoming meeting requests on resourceAccount (wire: deleteSubject)
locationstringresource location name
maximum_durationintegermaximum duration in minutes for meeting requests (wire: maximumDuration)
resource_email_addressstringresource as email (wire: resourceEmailAddress)
show_meeting_detailsstringgranted right on a calendar of that resourceAccount (availabilityOnly, limitedDetails, reviewer) (wire: showMeetingDetails)
statestringaccount state (creating, deleting, internalMigration, ok, reopening, suspended, suspending)
typestringresource type (equipment, room)

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectexchange_service, organization_name, resource_email_addressGet a resource account. Returns the type, capacity, location, booking settings and state of the room or equipment resource account.
listselectexchange_service, organization_namecompany, resource_email_address, x_pagination_modeList resource accounts. Returns the email addresses of the room and equipment resource accounts. Filter them by resourceEmailAddress or company.
createinsertexchange_service, organization_name, capacity, resource_email_address, typeCreate a resource account. Creates a room or equipment resource account from its resourceEmailAddress and capacity, and returns the task.
updateupdateexchange_service, organization_name, resource_email_addressUpdate a resource account. Updates the display name, capacity, location and booking settings of the resource account, such as allowConflict, bookingWindow or maximumDuration.
deletedeleteexchange_service, organization_name, resource_email_addressDelete a resource account. Deletes the resource account (room or equipment) and its delegates, and returns the task.

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
api_hoststringThe OVHcloud API host. Selected by OVH_ENDPOINT (ovh-eu, ovh-ca or ovh-us; default ovh-eu). (default: api.eu.ovhcloud.com, x-stackQL-envVarSelector: {"envVar":"OVH_ENDPOINT","default":"ovh-eu","values":{"ovh-eu":"api.eu.ovhcloud.com","ovh-ca":"api.ca.ovhcloud.com","ovh-us":"api.us.ovhcloud.com"}})
exchange_servicestringThe internal name of your exchange service (wire: exchangeService)
organization_namestringThe internal name of your exchange organization (wire: organizationName)
resource_email_addressstringresource as email (wire: resourceEmailAddress)
companystringFilter the value of company property (like)
resource_email_addressstringFilter the value of resourceEmailAddress property (like) (wire: resourceEmailAddress)
x_pagination_modestringSent as CachedObjectList-Pages by default so the list returns the full objects rather than their identifiers. (wire: X-Pagination-Mode)

SELECT examples​

Get a resource account. Returns the type, capacity, location, booking settings and state of the room or equipment resource account.

SELECT
task_pending_id,
display_name,
add_organizer_to_subject,
allow_conflict,
booking_window,
capacity,
company,
creation_date,
delete_comments,
delete_subject,
location,
maximum_duration,
resource_email_address,
show_meeting_details,
state,
type
FROM ovh.email_exchange.service_resource_accounts
WHERE exchange_service = '{{ exchange_service }}' -- required
AND organization_name = '{{ organization_name }}' -- required
AND resource_email_address = '{{ resource_email_address }}' -- required
;

INSERT examples​

Create a resource account. Creates a room or equipment resource account from its resourceEmailAddress and capacity, and returns the task.

INSERT INTO ovh.email_exchange.service_resource_accounts (
add_organizer_to_subject,
allow_conflict,
booking_window,
capacity,
company,
delete_comments,
delete_subject,
display_name,
location,
maximum_duration,
resource_email_address,
show_meeting_details,
type,
exchange_service,
organization_name
)
SELECT
{{ add_organizer_to_subject }},
{{ allow_conflict }},
{{ booking_window }},
{{ capacity }} /* required */,
'{{ company }}',
{{ delete_comments }},
{{ delete_subject }},
'{{ display_name }}',
'{{ location }}',
{{ maximum_duration }},
'{{ resource_email_address }}' /* required */,
'{{ show_meeting_details }}',
'{{ type }}' /* required */,
'{{ exchange_service }}',
'{{ organization_name }}'
RETURNING
id,
finish_date,
function,
status,
todo_date
;

UPDATE examples​

Update a resource account. Updates the display name, capacity, location and booking settings of the resource account, such as allowConflict, bookingWindow or maximumDuration.

UPDATE ovh.email_exchange.service_resource_accounts
SET
add_organizer_to_subject = {{ add_organizer_to_subject }},
allow_conflict = {{ allow_conflict }},
booking_window = {{ booking_window }},
capacity = {{ capacity }},
company = '{{ company }}',
delete_comments = {{ delete_comments }},
delete_subject = {{ delete_subject }},
display_name = '{{ display_name }}',
location = '{{ location }}',
maximum_duration = {{ maximum_duration }},
resource_email_address = '{{ resource_email_address }}',
show_meeting_details = '{{ show_meeting_details }}'
WHERE
exchange_service = '{{ exchange_service }}' --required
AND organization_name = '{{ organization_name }}' --required
AND resource_email_address = '{{ resource_email_address }}' --required;

DELETE examples​

Delete a resource account. Deletes the resource account (room or equipment) and its delegates, and returns the task.

DELETE FROM ovh.email_exchange.service_resource_accounts
WHERE exchange_service = '{{ exchange_service }}' --required
AND organization_name = '{{ organization_name }}' --required
AND resource_email_address = '{{ resource_email_address }}' --required
;