Trying to get all fields from our ACCOUNT table limiting it by 200 and getting an error in SSMS.
Syntax: SELECT * FROM OPENQUERY(XXXX,'SOQL:SELECT FIELDS(ALL) FROM Account LIMIT 200') (where XXXX is the Linked Server)
OLE DB provider "MSDASQL" for linked server "XXXX" returned message "[Devart][ODBC][Salesforce]Invalid SOQL: unexpected token: 'FIELDS' at position 7
Detail: function not supported".
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "MSDASQL" for linked server "XXXX".
If this is just a syntax issue - please just advise on the proper way to utilize "FIELDS(ALL)"