function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
HdWHdW 

Office Toolkit Api 20.0?

Hello,

 

I am trying to develop my own Excel-report-tool.I use the Office Toolkit for the communication with Salesforce. But if I try to send the query:

 

SELECT AccountNumber 

FROM Account

WHERE id in (SELECT ..........)

 

I get the error message, that semi joins are not supported in this API version. I checked it, and the toolkit uses the API 15.0. In the newer versions (I used 20.0) this query is possible.

 

Is there an easy possibility to use the latest API? I do not want to write my own .dll.

 

Thanks in advance

Markus

foghornfoghorn

Give this a try, but keep in mind it is not officially supported by salesforce.

Change the server url before you login,

 

sfApi.SetServerUrl("https://www.salesforce.com/services/Soap/c/20.0")

 

I've run some basic sanity tests against this endpoint with version 3.5 of the toolkit (the one that comes with the production version of the offline version) on windows 7, seemed ok.  That said, you'll only get a subset (pretty good one though) of the api object and field properties that were available in v 13 of the soap api.