Hi All

I have setup a Sharepoint Online integration via the Files Connector which works great except I can't retrieve the ParentId__c of any of the objects returned. I can however filter on the ParentId__c field.

How do I get a populated ParentId__c field in my query results?

Example:

SELECT Id, Name__c, IsFolder__c, ParentId__c FROM items_Sharepoint_Online__x

This returns a set of results, but ParentId__c is empty for every row.

Example:

SELECT Id, Name__c, IsFolder__c, ParentId__c FROM items_Sharepoint_Online__x WHERE ParentId__c = 'xxx'

This correctly returns the child items of 'xxx' (but the ParentId__c returned in the results is still blank!)

Any help, much appreciated.

Thanks