When I query Partner Last Modified Dates, I get it as:
<timestamp xsi:type="xsd:dateTime">2003-07-01T18:05:01+0000</timestamp>

to by consistent with other queries shouldn't it be:
<lastModifiedDate xsi:type="xsd:dateTime">2003-07-01T18:05:01+0000</lastModifiedDate>

** BEGIN SOAP REQUEST: 8/6/2003 3:02:13 PM
URL: https://na1-api.salesforce.com/servlet/servlet.SoapApi
 
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="salesforce" xmlns:types="salesforce/encodedTypes" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <soap:Header>
    <tns:headerStruct id="h_id1">
      <session_id xsi:type="xsd:string">LL732jELEHc1kH1cUnIoFnkXz0kADGL1mmSyslJhUjVlZytPiQSLaf9_m.ZjqAoODiIsxBqiLxAtnUoByFAHsfbtzKggVlhL</session_id>
      <version xsi:type="xsd:string">2.0</version>
    </tns:headerStruct>
  </soap:Header>
  <soap:Body soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
    <q1:query xmlns:q1="sfconnector:SalesforceConnector">
      <scope xsi:type="xsd:string">filter</scope>
      <type xsi:type="xsd:string">partner</type>
      <maxRows xsi:type="xsd:int">500</maxRows>
      <select href="#id1" />
      <filter href="#id2" />
      <ifModifiedSince xsi:type="xsd:dateTime">1950-01-01T00:00:00.0000000-05:00</ifModifiedSince>
      <useCaseSafeIDs xsi:type="xsd:boolean">true</useCaseSafeIDs>
    </q1:query>
    <soapenc:Array id="id1" soapenc:arrayType="xsd:string[3]">
      <Item>accountToID</Item>
      <Item>id</Item>
      <Item>lastModifiedDate</Item>
    </soapenc:Array>
    <soapenc:Array id="id2" soapenc:arrayType="xsd:anyType[1]">
      <Item href="#id3" />
    </soapenc:Array>
    <soapenc:Array id="id3" soapenc:arrayType="tns:mapEntry[3]">
      <Item href="#id4" />
      <Item href="#id5" />
      <Item href="#id6" />
    </soapenc:Array>
    <tns:mapEntry id="id4" xsi:type="tns:mapEntry">
      <key xsi:type="xsd:string">field</key>
      <value xsi:type="xsd:string">opportunityID</value>
    </tns:mapEntry>
    <tns:mapEntry id="id5" xsi:type="tns:mapEntry">
      <key xsi:type="xsd:string">value</key>
      <value xsi:type="xsd:string">00630000000h8Ob</value>
    </tns:mapEntry>
    <tns:mapEntry id="id6" xsi:type="tns:mapEntry">
      <key xsi:type="xsd:string">operator</key>
      <value xsi:type="xsd:string">equals</value>
    </tns:mapEntry>
  </soap:Body>
</soap:Envelope>
 
** END SOAP REQUEST
 
** BEGIN SOAP RESPONSE: 8/6/2003 3:02:14 PM

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="salesforce" xmlns:types="salesforce/encodedTypes" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <soap:Header />
  <soap:Body>
    <sfdc:queryResponse xmlns:sfdc="sfconnector:SalesforceConnector">
      <return>
        <value xsi:type="tns:array">
          <valueMap xsi:type="tns:map">
            <accountToID xsi:type="xsd:string">00130000000ZcvCAAS</accountToID>
            <timestamp xsi:type="xsd:dateTime">2003-07-30T20:53:48+0000</timestamp>
            <id xsi:type="xsd:string">00I30000000c69iEAA</id>
          </valueMap>
          <valueMap xsi:type="tns:map">
            <accountToID xsi:type="xsd:string">00130000000ZcvNAAS</accountToID>
            <timestamp xsi:type="xsd:dateTime">2003-07-30T20:53:48+0000</timestamp>
            <id xsi:type="xsd:string">00I30000000c69jEAA</id>
          </valueMap>
          <valueMap xsi:type="tns:map">
            <accountToID xsi:type="xsd:string">00130000000ZcvLAAS</accountToID>
            <timestamp xsi:type="xsd:dateTime">2003-07-01T18:05:01+0000</timestamp>
            <id xsi:type="xsd:string">00I30000000c2j0EAA</id>
          </valueMap>
          <valueMap xsi:type="tns:map">
            <accountToID xsi:type="xsd:string">00130000000ZcvNAAS</accountToID>
            <timestamp xsi:type="xsd:dateTime">2003-07-01T18:05:01+0000</timestamp>
            <id xsi:type="xsd:string">00I30000000c2j1EAA</id>
          </valueMap>
          <valueMap xsi:type="tns:map">
            <accountToID xsi:type="xsd:string">00130000000ZcvJAAS</accountToID>
            <timestamp xsi:type="xsd:dateTime">2003-07-01T18:05:01+0000</timestamp>
            <id xsi:type="xsd:string">00I30000000c2j4EAA</id>
          </valueMap>
          <valueMap xsi:type="tns:map">
            <accountToID xsi:type="xsd:string">00130000000ZcvNAAS</accountToID>
            <timestamp xsi:type="xsd:dateTime">2003-07-01T18:05:01+0000</timestamp>
            <id xsi:type="xsd:string">00I30000000c2j5EAA</id>
          </valueMap>
        </value>
      </return>
    </sfdc:queryResponse>
  </soap:Body>
</soap:Envelope>
 
** END SOAP RESPONSE

To query using the updated or deleted scope it says you need to have "replicate: access to the entity type.  How do you enable the Database Replication feature? Is it possible to do so under the developer edition?  Is it possible to do so through the API?

-Pawan

Is it Possible to put HTML in Note Body?

-Pawan

In my application, I can get a list of task, event, account etc.. ID's properly with function similar to the one below, However, I am not getting any ID's back from my query calls for notes and attachments.  This used to work properly in 1.9 but not in 2.0.  Please help.

-Pawan

public bool GetOpNoteIDs(string opportunityID, out ArrayList noteIDs)
{

Console.WriteLine("Getting list of Note ID's with Opportunity ID " + opportunityID + "...");

object[] filter = new object[1]; //Final filter array
filter[0] = MakeSimpleFilter("parentID", opportunityID, "equals");

System.Collections.ArrayList SelectList = new System.Collections.ArrayList();
SelectList.Add("id");

return ReturnQueryList("note", filter, (string[])SelectList.ToArray(typeof(string)), out noteIDs);

}

I've been trying to insert properly encoded (base-64) data for attachments in C# but it's notworking.  In fact it is the same data that salesforce is passing me.  I am passing it as a string but I get "Value ... not of required type base64 on field body", so does that mean I have to pass it as a type other than a string? 

It seems you have changed your XML schema for version 2.0, I would appreciate it it you could update the C# sample code for version 2.0.

Thanks.

Message Edited by pawan on 06-09-2003 11:34 AM

Message Edited by pawan on 06-09-2003 11:34 AM

Hi,

 I wrote one java program to fetch an opportunity details using query method.(scope is idList).

It was worked well upto yesterday.  When I run the same program Today I am getting SOAP fault with

fault string  select list not specified in query.

Please let me know whether there  is  any change in the  API?  .

I am including my soap request at the end. Please look at the message and advise me if there is any change.

any help would be much appreciated.

Thanks and regards,

Prudhvi

I am using following soap request to fetch the opp details.

Request:

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="salesforce" xmlns:types="salesforce/encodedTypes" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <soap:Header>
    <tns:headerStruct id="id1">
      <session_id xsi:type="xsd:string">A88zC97HIqHnZIlRhIemUk5cNamuFFrgC8.mkYiGGVDEesUfciyliy._DWGd4UrmD1qjRrjmKArOo.rZcbQUIvbtzKggVlhL</session_id>
      <version xsi:type="xsd:string">2.0</version>
    </tns:headerStruct>
  </soap:Header>
  <soap:Body soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
    <q1:query xmlns:q1="sfconnector:SalesforceConnector">
      <version xsi:type="xsd:string">2.0</version>
      <session_id xsi:type="xsd:string">A88zC97HIqHnZIlRhIemUk5cNamuFFrgC8.mkYiGGVDEesUfciyliy._DWGd4UrmD1qjRrjmKArOo.rZcbQUIvbtzKggVlhL</session_id>
      <scope xsi:type="xsd:string">idList</scope>
      <type xsi:type="xsd:string">opportunity</type>
      <maxRows xsi:type="xsd:int">1</maxRows>
      <select href="#id1"/>
      <idList href="#id2"/>
    </q1:query>
    <soapenc:Array id="id1" soapenc:arrayType="xsd:string[9]">
      <Item>id</Item>
      <Item>name</Item>
      <Item>accountID</Item>
      <Item>type</Item>
      <Item>leadSource</Item>
      <Item>amount</Item>
      <Item>closeDate</Item>
      <Item>stage</Item>
      <Item>probability</Item>
      <Item>description</Item>
      <Item>closed</Item>
      <Item>won</Item>
      <Item>createdDate</Item>
      <Item>createdByID</Item>
      <Item>lastModifiedDate</Item>
      <Item>lastModifiedByID</Item>
    </soapenc:Array>
    <soapenc:Array id="id2" soapenc:arrayType="xsd:string[1]">
      <Item>00600000006qJqB</Item>
    </soapenc:Array>
  </soap:Body>
</soap:Envelope>

Response

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="salesforce" xmlns:types="salesforce/encodedTypes" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema ">

<soap:Header/><soap:Body><soap:Fault><faultcode>ÑR</faultcode><faultstring>select list not specified in query</faultstring></soap:Fault></soap:Body></soap:Envelope>

To query using the updated or deleted scope it says you need to have "replicate: access to the entity type.  How do you enable the Database Replication feature? Is it possible to do so under the developer edition?  Is it possible to do so through the API?

-Pawan

Any idea what the following error means or how can i get more detail?

bad field names on insert/update call: Item

What i'm doing:

C#.Net using the sample insert code, i'm trying to insert a new lead into a SalesForce.com customer account. FYI, i can insert into my test salesforce.com account with the same code.

Any ideas?

Thanks

Shane

In my application, I can get a list of task, event, account etc.. ID's properly with function similar to the one below, However, I am not getting any ID's back from my query calls for notes and attachments.  This used to work properly in 1.9 but not in 2.0.  Please help.

-Pawan

public bool GetOpNoteIDs(string opportunityID, out ArrayList noteIDs)
{

Console.WriteLine("Getting list of Note ID's with Opportunity ID " + opportunityID + "...");

object[] filter = new object[1]; //Final filter array
filter[0] = MakeSimpleFilter("parentID", opportunityID, "equals");

System.Collections.ArrayList SelectList = new System.Collections.ArrayList();
SelectList.Add("id");

return ReturnQueryList("note", filter, (string[])SelectList.ToArray(typeof(string)), out noteIDs);

}

I've been trying to insert properly encoded (base-64) data for attachments in C# but it's notworking.  In fact it is the same data that salesforce is passing me.  I am passing it as a string but I get "Value ... not of required type base64 on field body", so does that mean I have to pass it as a type other than a string? 

It seems you have changed your XML schema for version 2.0, I would appreciate it it you could update the C# sample code for version 2.0.

Thanks.

Message Edited by pawan on 06-09-2003 11:34 AM

Message Edited by pawan on 06-09-2003 11:34 AM