Where condition in Outlook 365 Connector (EventsForCalender)

phima — Mon, 24 Apr 2023 12:47:21 GMT

Hi!

Is it possible to add a where condition when extracting EventsForCalendar with the O365 Connector?

i would like to extract only events > year 2023.

Something like this will result in an Error (could not parse SELECT Statement):

SELECT subject
FROM EventsForCalendar
where subject = '26000'
WITH PROPERTIES (
calendarID='xxxxxxxx=',
maxResults='',
)
;

Thanks!

topic Where condition in Outlook 365 Connector (EventsForCalender) in Connectivity & Data Prep