You need to sign in to do that
Don't have an account?
HarryK
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
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
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