Hi guys,

I have an employee here who claims to have lost tasks from a handful of leads on the website. She claims to have entered information about calls and other stuff, and the information is no longer there.

Is it possible for such a thing to happen on Salesforce servers?

Is there a way I can have this checked against a backup or something?

Thank you in advance.

Hey guys,

I was wondering if there is a way to make some selections available to users depending on the value they select for another field....

For instance, let's say I am creating a new lead, and I select value "x" in my "Lead Source" picklist field. I would like to be able to change the contents of the "Lead Source Detail" picklist, to display options relevant to value "x".

Can this be done in Salesforce? Is there a way of customizing it to do that?

Thank you in advance.

Hi there,

As I mentioned before, I am working on a program that moves accounts back to leads.

However, I have come accross a small problem:

The API will not allow me to change the "converted" field on the lead table. I have gotten to the point that I move all the tasks, events, campaigns back to the lead, but I cannot change the lead converted field to 0.

Is there any way to do this?

If not, I guess I will just have to create another lead and delete the one marked as converted.

Thanks.

Hi again,

I am issuing a query to the server with 50 fields to retrieve on a select struct.

The server response contains only 16 fields. What am I doing wrong?

Here is the request: (I will post the response in a nother message)

<?xml version="1.0"?>
<methodCall>
 <methodName>sfdc.query</methodName>
 <params>
  <param>
   <value>
    <struct>
     <member>
      <name>select</name>
      <value>
       <array>
        <data>
         <value>
          <string>ownerID</string>
         </value>
         <value>
          <string>name</string>
         </value>
         <value>
          <string>00N30000000VPsr</string>
         </value>
         <value>
          <string>00N30000000G3Tj</string>
         </value>
         <value>
          <string>00N30000000YHdi</string>
         </value>
         <value>
          <string>00N30000000byNQ</string>
         </value>
         <value>
          <string>00N30000000G5vW</string>
         </value>
         <value>
          <string>url</string>
         </value>
         <value>
          <string>sales</string>
         </value>
         <value>
          <string>industry</string>
         </value>
         <value>
          <string>00N30000000D3zr</string>
         </value>
         <value>
          <string>employees</string>
         </value>
         <value>
          <string>rating</string>
         </value>
         <value>
          <string>00N30000000G5X8</string>
         </value>
         <value>
          <string>00N30000000G5XQ</string>
         </value>
         <value>
          <string>00N30000000CKdy</string>
         </value>
         <value>
          <string>00N30000000G5Wc</string>
         </value>
         <value>
          <string>00N30000000G5WK</string>
         </value>
         <value>
          <string>00N30000000G5Wp</string>
         </value>
         <value>
          <string>00N30000000bnLX</string>
         </value>
         <value>
          <string>00N30000000aLsJ</string>
         </value>
         <value>
          <string>00N30000000aLt0</string>
         </value>
         <value>
          <string>00N30000000aLuh</string>
         </value>
         <value>
          <string>00N30000000aLsY</string>
         </value>
         <value>
          <string>00N30000000aLrG</string>
         </value>
         <value>
          <string>00N30000000aO4j</string>
         </value>
         <value>
          <string>00N30000000LEys</string>
         </value>
         <value>
          <string>00N30000000boRp</string>
         </value>
         <value>
          <string>00N30000000boS0</string>
         </value>
         <value>
          <string>00N30000000aLqy</string>
         </value>
         <value>
          <string>00N30000000boRu</string>
         </value>
         <value>
          <string>00N30000000boRv</string>
         </value>
         <value>
          <string>00N30000000buei</string>
         </value>
         <value>
          <string>00N30000000buej</string>
         </value>
         <value>
          <string>00N30000000buek</string>
         </value>
         <value>
          <string>00N30000000buel</string>
         </value>
         <value>
          <string>00N30000000CKds</string>
         </value>
         <value>
          <string>00N30000000CKdw</string>
         </value>
         <value>
          <string>00N30000000G5UU</string>
         </value>
         <value>
          <string>00N30000000G5YO</string>
         </value>
         <value>
          <string>00N30000000bnLZ</string>
         </value>
         <value>
          <string>00N30000000aLrd</string>
         </value>
         <value>
          <string>00N30000000aLtC</string>
         </value>
         <value>
          <string>00N30000000aLup</string>
         </value>
         <value>
          <string>00N30000000aLrS</string>
         </value>
         <value>
          <string>00N30000000aLsj</string>
         </value>
         <value>
          <string>00N30000000LEyk</string>
         </value>
         <value>
          <string>00N30000000aLqh</string>
         </value>
         <value>
          <string>00N30000000boRq</string>
         </value>
         <value>
          <string>00N30000000boRo</string>
         </value>
         <value>
          <string>00N30000000GAJI</string>
         </value>
        </data>
       </array>
      </value>
     </member>
     <member>
      <name>filter</name>
      <value>
       <array>
        <data>
         <value>
          <struct>
           <member>
            <name>operator</name>
            <value>
             <string>equals</string>
            </value>
           </member>
           <member>
            <name>field</name>
            <value>
             <string>id</string>
            </value>
           </member>
           <member>
            <name>value</name>
            <value>
             <string>00130000000OmMaAAK</string>
            </value>
           </member>
          </struct>
         </value>
        </data>
       </array>
      </value>
     </member>
     <member>
      <name>version</name>
      <value>
       <string>2.0</string>
      </value>
     </member>
     <member>
      <name>type</name>
      <value>
       <string>account</string>
      </value>
     </member>
     <member>
      <name>scope</name>
      <value>
       <string>filter</string>
      </value>
     </member>
     <member>
      <name>useCaseSafeIDs</name>
      <value>
       <boolean>1</boolean>
      </value>
     </member>
    </struct>
   </value>
  </param>
 </params>
</methodCall>

Hi there,

I am working on a process to move accounts back to leads. As I was matching the columns I realized the names of the custom fields are 15 characters long (case sensitive). Even if I request case insensitive ID's, the server still returns 15 character ones.

Is there a way to get the 18 character IDs? Will I ever run intro trouble with duplicate case insensitive field names?

Thanks!

Hi guys,

Is there a way to convert an account back to a lead through the site's interface?

I know the leads are not deleted, but marked as converted when an account is created from a lead, so I was hoping there would be a way to do just the opposite.

Thanks.

Hi there,

I am issuing update calls with my XMLRPC Implementation, using Case Insensitive IDs. Everything goes well, but the response is not case insensitive. Am I doind something wrong? Here is the request source. I will post the response in another thread for lack of space.

<?xml version="1.0"?>
<methodCall>
 <methodName>sfdc.update</methodName>
 <params>
  <param>
   <value>
    <struct>
     <member>
      <name>version</name>
      <value>
       <string>2.0</string>
      </value>
     </member>
     <member>
      <name>type</name>
      <value>
       <string>lead</string>
      </value>
     </member>
     <member>
      <name>useCaseSafeIDs</name>
      <value>
       <boolean>1</boolean>
      </value>
     </member>
     <member>
      <name>record</name>
      <value>
       <struct>
        <member>
         <name>id</name>
         <value>
          <string>00Q30000000gNltEAE</string>
         </value>
        </member>
        <member>
         <name>status</name>
         <value>
          <string>Purged</string>
         </value>
        </member>
        <member>
         <name>id</name>
         <value>
          <string>00Q30000000gNltEAE</string>
         </value>
        </member>
        <member>
         <name>00N30000000cJSC</name>
         <value>
          <dateTime.iso8601>20030925T00:00:00</dateTime.iso8601>
         </value>
        </member>
        <member>
         <name>id</name>
         <value>
          <string>00Q30000000gNltEAE</string>
         </value>
        </member>
        <member>
         <name>00N30000000cJS8</name>
         <value>
          <string>Blah</string>
         </value>
        </member>
       </struct>
      </value>
     </member>
    </struct>
   </value>
  </param>
 </params>
</methodCall>

I have a quick question. I do not ask this on Salesforce.com support, because they take days to reply and I have a situation that needs immediate attention : )

We have the web lead capture feature turned on.

Is there a way to get notified by e-mail or something when a lead is captured from our website?

Currently we are producing our own e-mail before submitting the lead to Salesforce.com in our web page, but we have been experiencing problems with it. Can SalesForce.com generate a notification upon receiving the web lead?

Thanks in advance.

Hi guys,

Does anyone out there have a piece of code to insert the results of a query into a dataset?

Thanks!

Hi guys,

I am creating a SOAP version of my XMLRPC client (completely new to SOAP), and I was hoping someone could share a piece of code that will show me how to get all the records for an entity.

Thanks!

Hi guys,

I am not sure if someone else is having this problem, and this is probably not the right place to mention it, but I figured I would let you know.

When I login to the developer's site (here), I get taken to my company's Salesforce page, rather than coming here, so I have to logout, login again, and only then it brings me here. Judging from the behavior I can say this is probably a cookie issue.

More of an inconvinience than a problem....

Thanks!

Hey guys,

I am trying to install the SDK Toolkit for VS .NET. I installed Visual Studio .NET in a different path than the default one, and I think now the installer for the SDK cannot find it on the computer, and it gives me an error saying I do not have it.

How can I go around this? Is there a way to get it to install?

Hey guys,

I need to generate an aging report on opportunities. Specifically, what I need to do is provide an average of how many days all the opportunities have been on the current stages. For example I have an stage called "Initial Meeting". I have X number of opportunities currently on this stage, so I want to get an average on the number of days, so I could report that opportunities on this stage have been there for an average x days. This way we can know how long we are letting them sit there before they move on to the next stage.

The problem:

Since the opportunity history entity is not available through the XML RPC interface, the only way I could figure out for producing such numbers was to generate a report on the website, and create a local table from the results in Excel. Now this works great, until I get to the point where I need to filter certain opportunities out. When I do a join by the opportunity ID field  I GET AN EMPTY RECORDSET???.... after carefull examination, I found out what the problem was: the XML RPC interface is producing 18 digit record IDs (Case unsensitive) where as the website is producing 15 character record ids..... bummer... all that work, and I cannot perform the final join.....

Is there a way around it?

Can the website produce 15 digit IDs?

Has anyone else achieved this before? If so, how did you do it?

Another issue I noticed.... there is no Stage Change Date field in opportunity history.... I am using the [last modified] date field hoping it will reflect when the record was created.....

Please let me know ASAP.... this report is very important for us, and I need to get it running as soon as possible.... Thanks!

I am able to generate the aggregates

Hey guys,

Maybe this is not the place to ask this, but I NEED HELP! .... he he

There is a report in Salesforce.com that our Inside Sales Team uses to keep track of the tasks and events they have pending.

For some weird reason, this report does NOT work anymore. It just returns no records (the data is there, I checked manually).

I called Tech Support and left a message, but it has been more than 24 hours already and I have gotten no response.

Any ideas?.... has anyone else experienced this problem?

Thanks in advance!

Hi guys,

There is a field called Last Modified in the opportunity history dump ( ** Dump because this is not accessible through the XMLRPC unfortunately **)

Does this field indicate when the opportunity stage was changed? (in the case it is an opportunity stage change of course)

I assume that is it because there is no other date field in the dump, and I cannot join it with my local "opportunity" table because the dump generated by the Website report section returns case sensitive (15 character) IDs.

Another quick question, is there a way to generate a report with case insensitive (18 character) IDs?

Thanks!

Hi guys,

I am trying to create a  price book to be used by the sales team.

I am able to create the price book, but I can't find a way to associate it with the opportunities. In other words, the price book is there, but how do I make the opportunities select information from it?

Thanks in advance.

Hey guys,

This is probably not the right place to post this question, but it takes days when I e-mailed customer support, he he, so I figured I would give it a shot:

The "Web to Lead" feature of the site allows you to create leads from your website. Is there a way to automatically assign these leads to a campaign, or should I create my own component to do that using the XMLRPC Interface?

Thanks in advance.

Regards.

Hey guys,

I'm having a hard time combining filters. I am trying to figure out what's wrong with this query:

<?xml version="1.0"?>
<methodCall>
 <methodName>sfdc.query</methodName>
 <params>
  <param>
   <value>
    <struct>
     <member>
      <name>select</name>
      <value>
       <array>
        <data>
         <value>
          <string>company</string>
         </value>
        </data>
       </array>
      </value>
     </member>
     <member>
      <name>filter</name>
      <value>
       <array>
        <data>
         <value>
          <struct>
           <member>
            <name>operator</name>
            <value>
             <string>OR</string>
            </value>
           </member>
           <member>
            <name>value</name>
            <value>
             <array>
              <data>
               <value>
                <struct>
                 <member>
                  <name>operator</name>
                  <value>
                   <string>contains</string>
                  </value>
                 </member>
                 <member>
                  <name>field</name>
                  <value>
                   <string>company</string>
                  </value>
                 </member>
                 <member>
                  <name>value</name>
                  <value>
                   <string>Achievers</string>
                  </value>
                 </member>
                </struct>
               </value>
               <value>
                <struct>
                 <member>
                  <name>operator</name>
                  <value>
                   <string>contains</string>
                  </value>
                 </member>
                 <member>
                  <name>field</name>
                  <value>
                   <string>company</string>
                  </value>
                 </member>
                 <member>
                  <name>value</name>
                  <value>
                   <string>ACN</string>
                  </value>
                 </member>
                </struct>
               </value>
              </data>
             </array>
            </value>
           </member>
          </struct>
         </value>
        </data>
       </array>
      </value>
     </member>
     <member>
      <name>version</name>
      <value>
       <string>2.0</string>
      </value>
     </member>
     <member>
      <name>type</name>
      <value>
       <string>lead</string>
      </value>
     </member>
     <member>
      <name>scope</name>
      <value>
       <string>filter</string>
      </value>
     </member>
     <member>
      <name>useCaseSafeIDs</name>
      <value>
       <boolean>1</boolean>
      </value>
     </member>
    </struct>
   </value>
  </param>
 </params>
</methodCall>

Any idea of what's wrong with it? Please help

Thank you in advance.

Hi everyone,

Is it possible to query the server through the XMLRPC to get an aggregate function such as "COUNT"?

In concrete, I would like to know the number of records in a given table by issuing a command.

I have not seen anything like that on the manual, so I am currently doing it by issuing a query of 1 field only, and counting the results (which is most definitely not recommended)

Thank you in advance, I appreciate your help.

Hello again,

How do we enable replication for our company?

Thank you in advance

Hi guys,

I have an employee here who claims to have lost tasks from a handful of leads on the website. She claims to have entered information about calls and other stuff, and the information is no longer there.

Is it possible for such a thing to happen on Salesforce servers?

Is there a way I can have this checked against a backup or something?

Thank you in advance.

Hi again,

I am issuing a query to the server with 50 fields to retrieve on a select struct.

The server response contains only 16 fields. What am I doing wrong?

Here is the request: (I will post the response in a nother message)

<?xml version="1.0"?>
<methodCall>
 <methodName>sfdc.query</methodName>
 <params>
  <param>
   <value>
    <struct>
     <member>
      <name>select</name>
      <value>
       <array>
        <data>
         <value>
          <string>ownerID</string>
         </value>
         <value>
          <string>name</string>
         </value>
         <value>
          <string>00N30000000VPsr</string>
         </value>
         <value>
          <string>00N30000000G3Tj</string>
         </value>
         <value>
          <string>00N30000000YHdi</string>
         </value>
         <value>
          <string>00N30000000byNQ</string>
         </value>
         <value>
          <string>00N30000000G5vW</string>
         </value>
         <value>
          <string>url</string>
         </value>
         <value>
          <string>sales</string>
         </value>
         <value>
          <string>industry</string>
         </value>
         <value>
          <string>00N30000000D3zr</string>
         </value>
         <value>
          <string>employees</string>
         </value>
         <value>
          <string>rating</string>
         </value>
         <value>
          <string>00N30000000G5X8</string>
         </value>
         <value>
          <string>00N30000000G5XQ</string>
         </value>
         <value>
          <string>00N30000000CKdy</string>
         </value>
         <value>
          <string>00N30000000G5Wc</string>
         </value>
         <value>
          <string>00N30000000G5WK</string>
         </value>
         <value>
          <string>00N30000000G5Wp</string>
         </value>
         <value>
          <string>00N30000000bnLX</string>
         </value>
         <value>
          <string>00N30000000aLsJ</string>
         </value>
         <value>
          <string>00N30000000aLt0</string>
         </value>
         <value>
          <string>00N30000000aLuh</string>
         </value>
         <value>
          <string>00N30000000aLsY</string>
         </value>
         <value>
          <string>00N30000000aLrG</string>
         </value>
         <value>
          <string>00N30000000aO4j</string>
         </value>
         <value>
          <string>00N30000000LEys</string>
         </value>
         <value>
          <string>00N30000000boRp</string>
         </value>
         <value>
          <string>00N30000000boS0</string>
         </value>
         <value>
          <string>00N30000000aLqy</string>
         </value>
         <value>
          <string>00N30000000boRu</string>
         </value>
         <value>
          <string>00N30000000boRv</string>
         </value>
         <value>
          <string>00N30000000buei</string>
         </value>
         <value>
          <string>00N30000000buej</string>
         </value>
         <value>
          <string>00N30000000buek</string>
         </value>
         <value>
          <string>00N30000000buel</string>
         </value>
         <value>
          <string>00N30000000CKds</string>
         </value>
         <value>
          <string>00N30000000CKdw</string>
         </value>
         <value>
          <string>00N30000000G5UU</string>
         </value>
         <value>
          <string>00N30000000G5YO</string>
         </value>
         <value>
          <string>00N30000000bnLZ</string>
         </value>
         <value>
          <string>00N30000000aLrd</string>
         </value>
         <value>
          <string>00N30000000aLtC</string>
         </value>
         <value>
          <string>00N30000000aLup</string>
         </value>
         <value>
          <string>00N30000000aLrS</string>
         </value>
         <value>
          <string>00N30000000aLsj</string>
         </value>
         <value>
          <string>00N30000000LEyk</string>
         </value>
         <value>
          <string>00N30000000aLqh</string>
         </value>
         <value>
          <string>00N30000000boRq</string>
         </value>
         <value>
          <string>00N30000000boRo</string>
         </value>
         <value>
          <string>00N30000000GAJI</string>
         </value>
        </data>
       </array>
      </value>
     </member>
     <member>
      <name>filter</name>
      <value>
       <array>
        <data>
         <value>
          <struct>
           <member>
            <name>operator</name>
            <value>
             <string>equals</string>
            </value>
           </member>
           <member>
            <name>field</name>
            <value>
             <string>id</string>
            </value>
           </member>
           <member>
            <name>value</name>
            <value>
             <string>00130000000OmMaAAK</string>
            </value>
           </member>
          </struct>
         </value>
        </data>
       </array>
      </value>
     </member>
     <member>
      <name>version</name>
      <value>
       <string>2.0</string>
      </value>
     </member>
     <member>
      <name>type</name>
      <value>
       <string>account</string>
      </value>
     </member>
     <member>
      <name>scope</name>
      <value>
       <string>filter</string>
      </value>
     </member>
     <member>
      <name>useCaseSafeIDs</name>
      <value>
       <boolean>1</boolean>
      </value>
     </member>
    </struct>
   </value>
  </param>
 </params>
</methodCall>

Hi there,

I am working on a process to move accounts back to leads. As I was matching the columns I realized the names of the custom fields are 15 characters long (case sensitive). Even if I request case insensitive ID's, the server still returns 15 character ones.

Is there a way to get the 18 character IDs? Will I ever run intro trouble with duplicate case insensitive field names?

Thanks!

Hi there,

I am issuing update calls with my XMLRPC Implementation, using Case Insensitive IDs. Everything goes well, but the response is not case insensitive. Am I doind something wrong? Here is the request source. I will post the response in another thread for lack of space.

<?xml version="1.0"?>
<methodCall>
 <methodName>sfdc.update</methodName>
 <params>
  <param>
   <value>
    <struct>
     <member>
      <name>version</name>
      <value>
       <string>2.0</string>
      </value>
     </member>
     <member>
      <name>type</name>
      <value>
       <string>lead</string>
      </value>
     </member>
     <member>
      <name>useCaseSafeIDs</name>
      <value>
       <boolean>1</boolean>
      </value>
     </member>
     <member>
      <name>record</name>
      <value>
       <struct>
        <member>
         <name>id</name>
         <value>
          <string>00Q30000000gNltEAE</string>
         </value>
        </member>
        <member>
         <name>status</name>
         <value>
          <string>Purged</string>
         </value>
        </member>
        <member>
         <name>id</name>
         <value>
          <string>00Q30000000gNltEAE</string>
         </value>
        </member>
        <member>
         <name>00N30000000cJSC</name>
         <value>
          <dateTime.iso8601>20030925T00:00:00</dateTime.iso8601>
         </value>
        </member>
        <member>
         <name>id</name>
         <value>
          <string>00Q30000000gNltEAE</string>
         </value>
        </member>
        <member>
         <name>00N30000000cJS8</name>
         <value>
          <string>Blah</string>
         </value>
        </member>
       </struct>
      </value>
     </member>
    </struct>
   </value>
  </param>
 </params>
</methodCall>

Hey guys,

I am trying to install the SDK Toolkit for VS .NET. I installed Visual Studio .NET in a different path than the default one, and I think now the installer for the SDK cannot find it on the computer, and it gives me an error saying I do not have it.

How can I go around this? Is there a way to get it to install?

Hey guys,

I need to generate an aging report on opportunities. Specifically, what I need to do is provide an average of how many days all the opportunities have been on the current stages. For example I have an stage called "Initial Meeting". I have X number of opportunities currently on this stage, so I want to get an average on the number of days, so I could report that opportunities on this stage have been there for an average x days. This way we can know how long we are letting them sit there before they move on to the next stage.

The problem:

Since the opportunity history entity is not available through the XML RPC interface, the only way I could figure out for producing such numbers was to generate a report on the website, and create a local table from the results in Excel. Now this works great, until I get to the point where I need to filter certain opportunities out. When I do a join by the opportunity ID field  I GET AN EMPTY RECORDSET???.... after carefull examination, I found out what the problem was: the XML RPC interface is producing 18 digit record IDs (Case unsensitive) where as the website is producing 15 character record ids..... bummer... all that work, and I cannot perform the final join.....

Is there a way around it?

Can the website produce 15 digit IDs?

Has anyone else achieved this before? If so, how did you do it?

Another issue I noticed.... there is no Stage Change Date field in opportunity history.... I am using the [last modified] date field hoping it will reflect when the record was created.....

Please let me know ASAP.... this report is very important for us, and I need to get it running as soon as possible.... Thanks!

I am able to generate the aggregates

Hi guys,

I am trying to create a  price book to be used by the sales team.

I am able to create the price book, but I can't find a way to associate it with the opportunities. In other words, the price book is there, but how do I make the opportunities select information from it?

Thanks in advance.

Hey guys,

I'm having a hard time combining filters. I am trying to figure out what's wrong with this query:

<?xml version="1.0"?>
<methodCall>
 <methodName>sfdc.query</methodName>
 <params>
  <param>
   <value>
    <struct>
     <member>
      <name>select</name>
      <value>
       <array>
        <data>
         <value>
          <string>company</string>
         </value>
        </data>
       </array>
      </value>
     </member>
     <member>
      <name>filter</name>
      <value>
       <array>
        <data>
         <value>
          <struct>
           <member>
            <name>operator</name>
            <value>
             <string>OR</string>
            </value>
           </member>
           <member>
            <name>value</name>
            <value>
             <array>
              <data>
               <value>
                <struct>
                 <member>
                  <name>operator</name>
                  <value>
                   <string>contains</string>
                  </value>
                 </member>
                 <member>
                  <name>field</name>
                  <value>
                   <string>company</string>
                  </value>
                 </member>
                 <member>
                  <name>value</name>
                  <value>
                   <string>Achievers</string>
                  </value>
                 </member>
                </struct>
               </value>
               <value>
                <struct>
                 <member>
                  <name>operator</name>
                  <value>
                   <string>contains</string>
                  </value>
                 </member>
                 <member>
                  <name>field</name>
                  <value>
                   <string>company</string>
                  </value>
                 </member>
                 <member>
                  <name>value</name>
                  <value>
                   <string>ACN</string>
                  </value>
                 </member>
                </struct>
               </value>
              </data>
             </array>
            </value>
           </member>
          </struct>
         </value>
        </data>
       </array>
      </value>
     </member>
     <member>
      <name>version</name>
      <value>
       <string>2.0</string>
      </value>
     </member>
     <member>
      <name>type</name>
      <value>
       <string>lead</string>
      </value>
     </member>
     <member>
      <name>scope</name>
      <value>
       <string>filter</string>
      </value>
     </member>
     <member>
      <name>useCaseSafeIDs</name>
      <value>
       <boolean>1</boolean>
      </value>
     </member>
    </struct>
   </value>
  </param>
 </params>
</methodCall>

Any idea of what's wrong with it? Please help

Thank you in advance.

Hi everyone,

Is it possible to query the server through the XMLRPC to get an aggregate function such as "COUNT"?

In concrete, I would like to know the number of records in a given table by issuing a command.

I have not seen anything like that on the manual, so I am currently doing it by issuing a query of 1 field only, and counting the results (which is most definitely not recommended)

Thank you in advance, I appreciate your help.

Hi there,

We would like to run a local copy of the database to extend our report capabilities. Does Salesforce support any means of data replication?

We have MS SQL Server running locally. We would like to replicate the data to this server.

Thank you in advance.

Hi there,

I am trying to run queries, and I get the following error:

FaultCode = 1101

filter must be a unknown type

Here is the XML-RPC being sent to the server:

<?xml version="1.0"?>
<methodCall>
  <methodName>sfdc.query</methodName>
  <params>
    <param>
      <value>
        <struct>
          <member>
            <name>select</name>
            <value>
              <array>
                <data>
                  <value>
                    <string>id</string>
                  </value>
                  <value>
                    <string>name</string>
                  </value>
                </data>
              </array>
            </value>
          </member>
          <member>
            <name>filter</name>
            <value>
              <struct>
                <member>
                  <name>field</name>
                  <value>
                    <string>name</string>
                  </value>
                </member>
                <member>
                  <name>value</name>
                  <value>
                    <string>Fanbuzz, Inc.</string>
                  </value>
                </member>
              </struct>
            </value>
          </member>
          <member>
            <name>version</name>
            <value>
              <string>2.0</string>
            </value>
          </member>
          <member>
            <name>type</name>
            <value>
              <string>account</string>
            </value>
          </member>
          <member>
            <name>scope</name>
            <value>
              <string>filter</string>
            </value>
          </member>
        </struct>
      </value>
    </param>
  </params>
</methodCall>

What am I doing wrong?

Thank you in advance for your help.

Hi,

I have been able to login to the RPC server (prior post), but I am unable to logout. The problem seems to be the session HTTP cookie. This is what I am doing:

xmlhttp.setRequestHeader "Cookie", "session_id=" & session_id

The error returned is: 1112, session id missing or invalid

Please help, thank you.

Hi there,

Im trying to connect to SalesForce using an XML-RPC client from VB 6.0. However, when I issue requests, I get a response "404 - Document not found" from the server, which probably means that either the port is not 80, or the address to the RPC API is not correct. This is what I am using:

http://www.salesforce.com/servlet/servlet.api

Port = 80

How can I correct this?

Thank you in advance