Missing calendar events

[Jeroen Thunnissen]

I am trying to request all my calendar events of the day using the Calendar Event Query block, but for some reason I only get some of them. And I have not been able to determine any diffference between the events that are and aren't showing. Not using any filters except for min/max start time.

The calendars in question from an outlook account (created by the Outlook app).

Does any one have any idea what might cause this, or how to work around this?

N.B. I have already tried to read these calendars directly from the web using an .ics or .ical link, but Automate doesn't seem to swallow that.

[Henrik "The Developer" Lindqvist]

Does affect non-Outlook calendars as well?

Are the missing events "recurring events"?

A workaround may be to use the Content query block.

[Jeroen Thunnissen]

Yes, ik effects Google Calendar events as well, both recurring and non-recuring events.

That Content Query block looks promising, but I have difficulty figuring out which URI to provide (using the calendar URI from the Event Query block doe not  seem to yield event data). If you could point me in the right direction where to look for this information, i would be very grateful!

[Henrik "The Developer" Lindqvist]

Try Content URI: content://com.android.calendar/instances/when/{minTimestamp*1000;trunc}/{maxTimestamp*1000;trunc}

or: content://com.android.calendar/enterprise/instances/when/{minTimestamp*1000;trunc}/{maxTimestamp*1000;trunc}

See: https://github.com/aosp-mirror/platform_frameworks_base/blob/master/core/java/android/provider/CalendarContract.java#L1890

[Jeroen Thunnissen]

Thank you Hendrik! I will start experimenting with this.

[Henrik "The Developer" Lindqvist]

Please let me know how you manage to query the "missing" events.

[Jeroen Thunnissen]

Unfortunately not, I get the same results as before...

Also, the URI with /enterprise/ in it is not a known endpoint.

--
You received this message because you are subscribed to a topic in the Google Groups "Automate" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/automate-user/MWV9gslMVCQ/unsubscribe.
To unsubscribe from this group and all its topics, send an email to automate-use...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/automate-user/e4174ed9-7db4-4fb5-b8e2-0e8032a957aan%40googlegroups.com.

[Henrik "The Developer" Lindqvist]

No result, wrong kind of result, or proper result but still missing events?

[Jeroen Thunnissen]

Missing events. Now that you mention it, also wrong events; the result contains beside some valid events also some old events, from a repeating series that I deleted a long time ago.

These is results are identical with the result from the Calendar Event Query block.

To view this discussion on the web visit https://groups.google.com/d/msgid/automate-user/200f4502-e026-4be7-8fb6-740ff7bd0c5an%40googlegroups.com.

[Henrik "The Developer" Lindqvist]

Are you sure the missing events aren't in another calendar?

Maybe Outlook consolidate multiple calendars into a single calendar view, maybe some aren't storage in Android's calendar database.

[Jeroen Thunnissen]

Hi Hendrik,

In answer to your question: yes I am sure.

Sorry for the late reply, I was on vacation. I do however not feel like putting in more time into this. I had hoped there was an easy solution. Thanks for your help.

To view this discussion on the web visit https://groups.google.com/d/msgid/automate-user/358eb2b9-7dd1-4a74-94d1-6142add7b600n%40googlegroups.com.