Events
Read and update events in your organizations.
Table-specific Information
Note: Requires the rw_events OAuth scope. CData's embedded OAuth application does not support this scope. You must create a custom OAuth application and request access for Events Management API from the list of products (see Creating a Custom OAuth Application).To delete an event, delete its corresponding post. You can delete posts in your organization by executing DELETE statements on the CompanyStatusUpdates table.
Select
The = operator is fully supported server-side for the OrganizerURN column. The IN operator is partially supported server-side. Refer to the query examples below:SELECT * FROM Events WHERE OrganizerURN = 'urn:li:organization:4975021'
SELECT * FROM Events WHERE OrganizerURN IN ('urn:li:organization:4975021', 'urn:li:organization:6554901')
When the OrganizerURN column is not specified in the criteria as in the example below:
SELECT * FROM Events
, we internally post-process the query to the following before executing:
SELECT * FROM Events WHERE OrganizerURN IN (SELECT Id FROM CompanyList WHERE State = 'APPROVED' AND Role = 'ADMINISTRATOR')
Update
Update the vanity name of your events. The Id column must be specified in the criteria as in the query example below:UPDATE Events SET VanityName = 'mytestevent7382067115601719297456' WHERE Id = '7382067115601719297456'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Unique identifier for the event. | |
| URN | String | True |
URN of the event. | |
| OrganizerURN | String | True |
URN of the event organizer. | |
| Name | String | True |
Name of the event. | |
| Description | String | True |
Detailed description of the event. | |
| Type | String | True |
Type or category of the event. Data is returned in JSON format. | |
| VanityName | String | False |
Custom or user-friendly name for the event. | |
| StartsAt | Datetime | True |
Timestamp when the event starts. | |
| BackgroundImageURN | String | True |
URN of the event's background image. | |
| LeadFormURN | String | True |
URN of the lead generation form associated with the event. | |
| DiscoveryMode | String | True |
How the event is discovered or promoted. | |
| PostURN | String | True |
URN of the post associated with the event. | |
| CreatedBy | String | True |
URN of the actor who created the event. | |
| CreatedAt | Datetime | True |
Timestamp when the event was created. | |
| LastUpdatedBy | String | True |
URN of the actor who last updated the event. | |
| LastUpdatedAt | Datetime | True |
Timestamp when the event was last updated. |