function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Jingli Hu 3Jingli 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?
SwethaSwetha (Salesforce Developers) 
HI Jingli,
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
Jingli Hu 3Jingli Hu 3

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.