slloyd has asked for the wisdom of the Perl Monks concerning the following question:

I am using WWW::Salesforce and WWW::Salesforce::Simple to query our Salesforce account. I see a way to limit my search but I do not see a way to get the total record count without querying all the records. We have nearly 500,000 Leads so this takes a tremendous amount of time. Does anyone know a way to tell Salesforce to return the total record count without returning all the data?
s/te/ve/
  • Comment on Total Count with WWW::Salesforce module

Replies are listed 'Best First'.
Re: Total Count with WWW::Salesforce module
by bichonfrise74 (Vicar) on May 08, 2009 at 23:20 UTC
    I have not used this module and I do not have a test account to try this... but it looks like you simply need to use the query( HASH ) method.

    I wonder if query( "select count(*) from table" ) would work?
      Good thought but it does not seem to like "select count". I don't think that SF supports count.
      s/te/ve/