Retrieve more info from Qlik Outlook 365 Connector, we need full calendar body text not only body_preview

[dirkoomscegeka]

Hello All,

I'm testing for a customer case, the Qlik Outlook 365 Web-Connector.

I managed to retrieve the list of calendar items for a specific user, but this is only giving partial information.

With the connector you can fetch the body_preview (limited text of the calender item) but we need the full body text.

Is this possible with the connector or should we use direct Microsoft Graph api call's with the rest connector?
(In that case, could we re-use the authentication mechanism of the web connector?)

I can see when reading the MS information about the graph-api's there are much more possibility's then there are options in the webconnector. (ex: Reading items from share calendars)
Would be great if we can extend the connector with other API calls.

Thanks in advance all for any tips, advice or work arounds!
 

[chrisbrain]

@dirkoomscegeka Thanks for your message - yes we can look at adding full body text as a column to the events tables (which I think is what you need).

Unfortunately I don't see a way you would be able to re-use the current authentication with the REST connector.

Regarding shared calendars, does this not already work? i.e. the Calendars table lists any calendars you have access to and you can use the ID from here for a shared calendar in the EventsForCalendar table?

[marcel_olmo]

Hi @dirkoomscegeka  how did you connect to your data? I'm trying to do the same testing but I'm only getting data from MyProfile and MyFolders tables. 

Could you tell me what do I missing?

Regards, Marcel.

[dirkoomscegeka]

Hi @marcel_olmo ,

Finally we used the rest connector to the graph API.
- Retrieve an access token
- Retrieve list of all users
- Get all calendar items of each user (loop over time to avoid to use paging

[marcel_olmo]

Thanks @dirkoomscegeka for your quick response, I'll give it a try.

Regards, Marcel.