You need to sign in to do that
Don't have an account?
Jingli Hu 3
external object for external data sources for box
Hi,
I am trying to make our external data source which is link to our box to be able to be searchable in salesforce. I created an external object the link to it. and sync and validate it. when I go to the external object tab to check the records, I got the error. "This query syntax is not supported by this external data source". any ideas?
I am trying to make our external data source which is link to our box to be able to be searchable in salesforce. I created an external object the link to it. and sync and validate it. when I go to the external object tab to check the records, I got the error. "This query syntax is not supported by this external data source". any ideas?
Based on trailblazer community link(https://success.salesforce.com/_ui/core/chatter/groups/GroupProfilePage?g=0F9300000009Mrp&fId=0D53A00002xr1mY) I see that SOQL is not supported by Box integration, only SOSL is supported.
From an end-user POV, this means that an external object can only be created to search in Box from the Salesforce global search. If you link your external object to a tab and access the tab, then Salesforce executes a SOQL query (depending on what your view filters are), and hence the error is shown.
Related:https://developer.salesforce.com/forums/?id=906F0000000kFdUIAU
https://salesforce.stackexchange.com/questions/302036/unable-to-query-external-object-created-from-files-connect-for-box
Hope this helps you. Please mark this answer as best so that others facing the same issue will find this information useful. Thank you
Thanks Swetha!
I tried to search a box file in salesforce global search by change gloabl search for File and input part of box file name. the box file doesn't show up. I don't think global search for box file is working.