Forum Discussion

vpserefin's avatar
vpserefin
Frequent Visitor
2 years ago
Solved

start.datetime is NULL for CalendarView object from Microsoft Data Connect

I am trying to extract all calendar data(BasicDataSet_v0.CalendarView_v0) using our Microsoft 365 connector and Grap Data Connect app  using Data Pipeline on Microsft Fabric. I am able to get data in some fields but the start.datetime is always NULL. Can you please help me why this is happening. Followed the instructions from here:

https://learn.microsoft.com/en-us/graph/app-registration

https://learn.microsoft.com/en-us/graph/data-connect-quickstart?tabs=AzureSynapsePipeline&tutorial-s...

https://learn.microsoft.com/en-us/entra/identity/enterprise-apps/configure-admin-consent-workflow

 

I have also added the following consents to the app.

 

 

I had earlier created a post in the wrong forum: https://community.fabric.microsoft.com/t5/General-Discussion/start-datetime-is-NULL-for-CalendarView-object-from-Microsoft/m-p/4035549#M3390

 

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi vpserefin,

    I'd like to suggest you check if these missed value fields are custom fields.
    AFIAK, the official data connector only picks the original table fields, these custom fields did not include in the results.
    For this scenario, you may need to use the custom fields related REST API to get these fields from the data source.

    Regards,

    Xiaoxin Sheng

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi vpserefin,

    I'd like to suggest you check if these missed value fields are custom fields.
    AFIAK, the official data connector only picks the original table fields, these custom fields did not include in the results.
    For this scenario, you may need to use the custom fields related REST API to get these fields from the data source.

    Regards,

    Xiaoxin Sheng