Getting Calendar Details

[aburito]

I've got a quick question(hopefully). I've collected the calendar data. I'm trying to pull organizer of the meeting, the attendees, location and the start and end time. But I'm having trouble parsing the data from here. Any help would be appreciated. Thanks!

[ecederstrand]

What problems are you having? Can you post your current code and what you expected to happen?

[ecederstrand]

If you only have access to subject and location, you probably need to restrict the fields you are requesting. Instead of account.calendar.view(start=start, end=end), do account.calendar.view(start=start, end=end).only("start", "end", "subject", "location").

[NankuF]

If you only have access to subject and location, you probably need to restrict the fields you are requesting. Instead of account.calendar.view(start=start, end=end), do account.calendar.view(start=start, end=end).only("start", "end", "subject", "location").

Input:

...
    calendar_items = account.calendar.view(start=start, end=end).only("start", "end", "subject", "location")    # ok.
    for calendar_item in calendar_items:   # on this line raise exception.
        pass

Debug output:

calendar_items
<exchangelib.queryset.QuerySet object at 0x7f4cf16cb9d0>
calendar_items[0].location
Traceback (most recent call last):
  File "<string>", line 1, in <module>
  File "/home/pvv/projects/needdel/venv/lib64/python3.8/site-packages/exchangelib/queryset.py", line 286, in __getitem__
    return self._getitem_idx(idx_or_slice)
  File "/home/pvv/projects/needdel/venv/lib64/python3.8/site-packages/exchangelib/queryset.py", line 300, in _getitem_idx
    for item in new_qs.__iter__():
  File "/home/pvv/projects/needdel/venv/lib64/python3.8/site-packages/exchangelib/queryset.py", line 270, in __iter__
    yield from self._format_items(items=self._query(), return_format=self.return_format)
  File "/home/pvv/projects/needdel/venv/lib64/python3.8/site-packages/exchangelib/queryset.py", line 345, in _item_yielder
    for i in iterable:
  File "/home/pvv/projects/needdel/venv/lib64/python3.8/site-packages/exchangelib/account.py", line 713, in fetch
    yield from self._consume_item_service(
  File "/home/pvv/projects/needdel/venv/lib64/python3.8/site-packages/exchangelib/account.py", line 402, in _consume_item_service
    is_empty, items = peek(items)
  File "/home/pvv/projects/needdel/venv/lib64/python3.8/site-packages/exchangelib/util.py", line 151, in peek
    first = next(iterable)
  File "/home/pvv/projects/needdel/venv/lib64/python3.8/site-packages/exchangelib/folders/collections.py", line 211, in find_items
    yield from FindItem(account=self.account, page_size=page_size).call(
  File "/home/pvv/projects/needdel/venv/lib64/python3.8/site-packages/exchangelib/services/common.py", line 223, in _elems_to_objs
    for elem in elems:
  File "/home/pvv/projects/needdel/venv/lib64/python3.8/site-packages/exchangelib/services/common.py", line 791, in _paged_call
    pages = self._get_pages(payload_func, kwargs, len(paging_infos))
  File "/home/pvv/projects/needdel/venv/lib64/python3.8/site-packages/exchangelib/services/common.py", line 888, in _get_pages
    page_elems = list(self._get_elements(payload=payload))
  File "/home/pvv/projects/needdel/venv/lib64/python3.8/site-packages/exchangelib/services/common.py", line 305, in _get_elements
    yield from self._response_generator(payload=payload)
  File "/home/pvv/projects/needdel/venv/lib64/python3.8/site-packages/exchangelib/services/common.py", line 775, in <genexpr>
    return (self._get_page(message) for message in response)
  File "/home/pvv/projects/needdel/venv/lib64/python3.8/site-packages/exchangelib/services/common.py", line 862, in _get_page
    paging_elem = self._get_element_container(message=message, name=self.paging_container_name)
  File "/home/pvv/projects/needdel/venv/lib64/python3.8/site-packages/exchangelib/services/common.py", line 596, in _get_element_container
    raise self._get_exception(code=response_code, text=msg_text, msg_xml=msg_xml)
exchangelib.errors.ErrorAccessDenied: Access is denied. Check credentials and try again., Cannot query rows in a table.

Resume:
The code you suggested allows you to get the calendar (Queryset), but it doesn't allow you to get the CalendarItem object from the Queryset.

Simply put - the calendar is received, but I can not extract data from it.
calendar_items.all()[0],
calendar_items[0],
calendar_items[0].start #etc
for calendar_item in calendar_items:
doesn't work.

[ecederstrand]

Then it's possible that you only have access to this calendar via the Protocol.get_free_busy_info() method. You can try account.calendar.view(start=start, end=end).only("subject", "location") to see if you're allowed access to just the subject and location fields.

[NankuF]

Then it's possible that you only have access to this calendar via the Protocol.get_free_busy_info() method. You can try account.calendar.view(start=start, end=end).only("subject", "location") to see if you're allowed access to just the subject and location fields.

Its work.
If you need only start,end, subject and location OR start,end,free/busy then need use Protocol.get_free_busy_info()
Permissions in calendar: Free/Busy time; Free/Busy time, subject, location.

    infos = account.protocol.get_free_busy_info(
        accounts=[
            (account, 'Optional', False),
            # (account, 'Organizer', False),
            # (account, 'Required', False),
        ],
        start=start,
        end=end
    )

if you need more - you need permission calendar: Rewiever
and use: calendar_items = account.calendar.view(start=start, end=end) # its Queryset with CalendarItem.

tnx ecederstrand