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
HarryKHarryK 

Trouble with Query Call in Excel Connector

I get "No data returned for this Query" from a query call regardless of the "where" clause when used with the 7.0 (or 8.0) Server URL endpoints.  6.0 endpoint works fine.
The Describe, Retrieve (query selected rows),  Update, and Delete functions work fine. Only the Query call does not  appear to work.  On a larger query (expect over 2K records), it takes longer to respond but it always returns the "No data returned for this Query" dialog box. Same is true for "Multiple Queries" option.

I have tried both the Enterprise and the PE version of the connector (6.16) with outlook edition 2.0. I am working with an Enterprise Org.
Any suggestions on how to troubleshoot?   Must I use the 6.0 endpoint?

Thanks,
Harry

Ron HessRon Hess
Excel connector uses the Office toolkit,  ( or Outlook ediition)  COM object to access the Apex API and move data, this toolkit is only tested/ supported to the 6.0 level.
forceAMPforceAMP

The new Excel Connector that I wrote (QueryAmp) used the 8.0 API and may give you the functionality you're looking for. It's in free beta right now; see www.queryamp.com for more details.

Bill

forceAmp.com