Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
phima
Contributor II
Contributor II

Where condition in Outlook 365 Connector (EventsForCalender)

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!

 

Labels (1)
0 Replies