+ Start a Discussion
sflnd8sflnd8 

Missing ParentId with Sharepoint integration

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


 
MKRMKR
Hi,

Do you know if the ParentId__c is set on sharepoint side as Queryable. Below is a possible cause of the issue picked from the documentation:

"
To search on these custom properties in Salesforce, a Sharepoint administrator must create a corresponding Managed Property.
To display these properties in external object fields, or use them in SOQL or SOSL SELECT queries, set the corresponding Managed Property to Retrievable.
To filter on these properties in external objects, or use them as query criteria in a SOQL or SOSL WHERE clause, set the corresponding Managed Property to Queryable.
"


To me, it seems that the ParentId__c is Queryable but not Retrievable.

Regards,
MKR