EventSubscriptions
The event-based subscription management object that allows external applications to discover objects that can be subscribed.
Table-Specific Information
SELECT
The component will use the Oracle Service Cloud API to process WHERE clause conditions built with =,!=,<,>,<=,>=,IN,NOT_IN,IS,IS_NOT,LIKE operators. The rest of the filters are executed client side within the component.
SELECT * FROM EventSubscriptions WHERE id = 12 SELECT * FROM EventSubscriptions WHERE id > 15 SELECT * FROM EventSubscriptions WHERE lookUpName LIKE '%test' SELECT * FROM EventSubscriptions WHERE id IN (12, 23, 123) SELECT * FROM EventSubscriptions WHERE lookUpName IS NOT NULL
INSERT
Insert can be executed by specifying the class, endPoint, eventType, integrationUser, name, objectShapeXml and objectVersion columns. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.
INSERT INTO EventSubscriptions (class, endPoint, eventTypeId, integrationUserId, objectShapeXml, name, objectVersionId) VALUES ('Contact', 'https://abc.com', '2', '1', 'asdc', 'queryresults', '100200')
UPDATE
Update can be executed. The columns that are not read-only can be Updated.
For example:
UPDATE EventSubscriptions SET summary = 'Test Replacement' WHERE lookupName = 'Battery Replacement'
DELETE
Following is an example of how to Delete a record in this table.
DELETE FROM EventSubscriptions WHERE summary IS NULL
Columns
Name | Type | ReadOnly | Description |
Class | String | False |
The string which represents the type of object in the ObjectShapeXML. |
CreatedTime | Datetime | True |
The date and time when the event subscription was created. This attribute is read-only. |
EndPoint | String | False |
The URL to post the notification event. Note: If an endpoint is registered as a callback, it should contain the fully qualified domain name. For example: |
EventTypeId | Long | False |
Id of eventType. The types of event such as Create, Update, or Destroy. |
EventTypelookUpName | String | False |
LookUpName of eventType. The types of event such as Create, Update, or Destroy. |
Id [KEY] | Long | True |
The unique identifier of the event subscription. |
IntegrationUserId | Long | False |
Id of integrationUser. The credentials and connection method to use for the event subscription. |
IntegrationUserlookUpName | String | False |
LookUpName of integrationUser. The credentials and connection method to use for the event subscription. |
LookupName | String | True |
The name used to look up the event subscription. |
Name | String | False |
The unique name of the event subscription. |
ObjectShapeXml | String | False |
The shape of the template object used to send the notification. |
ObjectVersionId | Long | False |
Id of objectVersion. The Connect version of the object to be sent in the notification. |
ObjectVersionlookUpName | String | False |
LookUpName of objectVersion. The Connect version of the object to be sent in the notification. |
StatusId | Long | False |
Id of status. The status of the event subscription. |
StatuslookUpName | String | False |
LookUpName of status. The status of the event subscription. |
UpdatedTime | Datetime | True |
The date and time when the event subscription was last updated. This attribute is read-only. |