EventSubscriptions

The event-based subscription management object that allows external applications to discover objects that can be subscribed.

Table-Specific Information

SELECT

The connector 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 connector.

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.