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 カスタムOAuth アプリケーションの作成).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. |